?
Solved

Error Logging into Oracle 11g

Posted on 2013-06-11
9
Medium Priority
?
710 Views
Last Modified: 2013-07-05
Dear Experts,

I have disk failure on the server that hosts some applications in Oracle databases. After the disk volume (RAID-1) has been recovered and rebuilt, I get some errors logging on

"Error Code: -1 Row: 0 - Database transaction information not available | Call SetTrans or SetTransObject function".

"Entry for ENABLE_MAIL_ID_ADMIN not found in table STS",

"Entry for NOTIFY_EMAIL_ID_ADMIN not found in table STS".

"ORA-12528: TNS:listener: all appropriate instances are blocking new connections."

Please advise on how fix this.  Thanks so much!
0
Comment
Question by:swgit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39239126
What are those errors from?

Based on the last one which is an actual Oracle error, check the database alert log for additional messages from the database.
0
 
LVL 1

Author Comment

by:swgit
ID: 39239148
@lightwv - thanks for the quick response.  I am not too familiar with Oracle, so please bear with me here.  The errors came from an application called MainSaver which uses Oracle as its database.  Where can I find the database alert log please?
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39239168
It is pointed to by the database spfile parameter DIAGNOSTIC_DEST:
http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams078.htm#REFRN10280

 The structure of the directory specified by DIAGNOSTIC_DEST is as follows:
<diagnostic_dest>/diag/rdbms/<dbname>/<instname>



My guess is it is using the default location.


Where you have Oracle installed, look for a diag folder.

Then continue drilling down.  Eventually you will see a trace folder.  The alert log is in there.
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 1

Author Comment

by:swgit
ID: 39239188
@slightwv -  i'll go through and will let you know.  thanks.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39239209
I should add it should have the name alert_<SID>.log where <SID> is the database name.

For future reference, there is also an alert folder that has the same information but it is in XML format for use by Enterprise Manager or dbConsole.

The one in the trace folder is easier to read for humans.
0
 
LVL 1

Author Comment

by:swgit
ID: 39255216
@slightwv - i am away from the office until the 20th, will update you then.  sorry for the delay in response.  thanks.
0
 
LVL 1

Author Comment

by:swgit
ID: 39264157
@slightwv - whenever i tried to do something in oracle, i got the following error "ORA-01033: ORACLE initialization or shutdown in progress" ... how would I get pass this?  Please advise.
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 39264175
>>"ORA-01033: ORACLE initialization or shutdown in progress"

Looks like your database isn't starting up.  To look in the alert log, you don't need to connect to Oracle.  The alert log should tell you why the database isn't starting.
0
 
LVL 1

Author Closing Comment

by:swgit
ID: 39302869
i managed to get it working again by re-installing the network adapter drivers.  thanks, slightwv.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question