Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 715
  • Last Modified:

Error Logging into Oracle 11g

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
swgit
Asked:
swgit
  • 5
  • 4
1 Solution
 
slightwv (䄆 Netminder) Commented:
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
 
swgitAuthor Commented:
@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
 
slightwv (䄆 Netminder) Commented:
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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
swgitAuthor Commented:
@slightwv -  i'll go through and will let you know.  thanks.
0
 
slightwv (䄆 Netminder) Commented:
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
 
swgitAuthor Commented:
@slightwv - i am away from the office until the 20th, will update you then.  sorry for the delay in response.  thanks.
0
 
swgitAuthor Commented:
@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
 
slightwv (䄆 Netminder) Commented:
>>"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
 
swgitAuthor Commented:
i managed to get it working again by re-installing the network adapter drivers.  thanks, slightwv.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now