[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Error Logging into Oracle 11g

Posted on 2013-06-11
9
Medium Priority
?
713 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 78

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 78

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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
LVL 1

Author Comment

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

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 78

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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

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…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses

612 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