Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Error Logging into Oracle 11g

Posted on 2013-06-11
9
Medium Priority
?
711 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

598 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