Solved

Error Logging into Oracle 11g

Posted on 2013-06-11
9
704 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
  • 5
  • 4
9 Comments
 
LVL 76

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 76

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
 
LVL 1

Author Comment

by:swgit
ID: 39239188
@slightwv -  i'll go through and will let you know.  thanks.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 76

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 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

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…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Via a live example, show how to take different types of Oracle backups using RMAN.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

759 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now