Forum Home » Database » Database - General

Thread: ORACLE not available problem 10g release 2

Reply to this Thread Reply to this Thread Search Forum Search Forum Back to Thread List Back to Thread List

Permlink Replies: 11 - Pages: 1 - Last Post: Feb 25, 2006 2:00 PM Last Post By: user490661
aR kEi

Posts: 21
Registered: 10/07/05
ORACLE not available problem 10g release 2
Posted: Oct 9, 2005 8:09 PM
Click to report abuse...   Click to reply to this thread Reply
hi all,
I encounter a problem for everytime a restart the server and login to the server using sqlplus, the err as follow...

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

when i check the oracle services, all are started. but in the oradim.log, some err found as below...

Mon Oct 10 10:47:48 2005
c:\oracle\product\10.2.0\db_1\bin\oradim.exe -startup -sid db01 -usrpwd * -log oradim.log -nocheck 0
Mon Oct 10 10:47:50 2005
ORA-12560: TNS:protocol adapter error

and also a sqlnet.log generated as below...

Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracledb01)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=db01)(CID=(PROGRAM=c:\oracle\product\10.2.0\db_1\bin\oradim.exe)(HOST=TEST134)(USER=SYSTEM))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
Time: 10-OCT-2005 10:47:50
Tracing not turned on.
Tns error struct:
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 2
nt OS err code: 0

the most funny thing is that when i copy the command on the oradim.log file

c:\oracle\product\10.2.0\db_1\bin\oradim.exe -startup -sid db01 -usrpwd * -log oradim.log -nocheck 0
and execute it, I can login successfully in the sqlplus... so what is the possible cause of this ?? One point to add is that I am using 2003 with 10g release 1 installed originally and worked fine, after I have unstalled the release 1 and installed release 2, the problem occur......would anyone help ?? thx so much for that...
DBMS Direct

Posts: 4,609
Registered: 10/07/99
Re: ORACLE not available problem 10g release 2
Posted: Oct 10, 2005 2:39 AM   in response to: aR kEi in response to: aR kEi
Click to report abuse...   Click to reply to this thread Reply
The only thing I can think of is that your ORACLE_SID is not set before your ran SQLPLUS. Your Services may be up and started, but your command prompt does not know which service or its related sid you want to connect to.

set ORACLE_SID=db01

Or if it is the only database you have got on the system, set it is the default Oracle SID in the registry for Oracle.

Then try again.
aR kEi

Posts: 21
Registered: 10/07/05
Re: ORACLE not available problem 10g release 2
Posted: Oct 10, 2005 3:20 AM   in response to: DBMS Direct in response to: DBMS Direct
Click to report abuse...   Click to reply to this thread Reply
ugonic,

I had tried all methods I searched in this forum including the obne you suggest... but it still not works..........V.V

thx anyway....
The Human Fly

Posts: 4,750
Registered: 11/24/00
Re: ORACLE not available problem 10g release 2
Posted: Oct 10, 2005 3:35 AM   in response to: aR kEi in response to: aR kEi
Click to report abuse...   Click to reply to this thread Reply
my question would be, why are you using oradim to startup your instance?
set your oracle service to automatic mode. also, set oracle_sid in your regedit oracle home.

Jaffar
DBMS Direct

Posts: 4,609
Registered: 10/07/99
Re: ORACLE not available problem 10g release 2
Posted: Oct 10, 2005 3:59 AM   in response to: aR kEi in response to: aR kEi
Click to report abuse...   Click to reply to this thread Reply
The Human Fly made a good suggestion you can use.

Try something else to ensure your Oracle is working fine. Even if you do not want to set an AUTO Startup. After starting your service. From command prompt,
c:\>set ORACLE_HOME=c:\oracle\product\10.2.0\db_1
c:\>set ORACLE_SID=db01,
c:\>sqlplus /nolog
SQL>connect /as SYSDBA
SQL>startup
aR kEi

Posts: 21
Registered: 10/07/05
Re: ORACLE not available problem 10g release 2
Posted: Oct 11, 2005 7:50 PM   in response to: DBMS Direct in response to: DBMS Direct
Click to report abuse...   Click to reply to this thread Reply
Ugonic, I had try the method you mentioned and found oracle is working.

Jaffar, all oracle service is in automatic mode and oracle_sid is set by default to 'db01' in oracle home. I try to use oradim to start the server just because I found err in the oradim log and thus I try that command.

So, are there any suggestions? I am thinking if the problem occur due to uninstallation of 10g release 1 and then install 10g release 2... anyway, thanks for your help :)
acrlewis

Posts: 21
Registered: 06/28/00
Re: ORACLE not available problem 10g release 2
Posted: Oct 12, 2005 9:03 AM   in response to: aR kEi in response to: aR kEi
Click to report abuse...   Click to reply to this thread Reply
I had this same error and had to recreate the listener after the upgrade. also, check the PGA/SGA parameters
aR kEi

Posts: 21
Registered: 10/07/05
Re: ORACLE not available problem 10g release 2
Posted: Oct 12, 2005 7:23 PM   in response to: acrlewis in response to: acrlewis
Click to report abuse...   Click to reply to this thread Reply
acrlewis, you also upgrade from 10g r1 to r2 ?
and i would like to ask what do you mean by recreate the listener?
and are the PGA/SGA parameters affect performance only ?
thx for your reply
acrlewis

Posts: 21
Registered: 06/28/00
Re: ORACLE not available problem 10g release 2
Posted: Oct 13, 2005 7:32 AM   in response to: aR kEi in response to: aR kEi
Click to report abuse...   Click to reply to this thread Reply
Yes, I upgraded from 10g r1 to 10g r2 and had to build a new listener using the net manager from r2 in order to get it to work. the old listener would not recognize the DB for some reason.

On one instance, the auto memory settings made shared_pool_size 0, which would not allow the DB to start. Since you are running the same OS, I thought you might want to look at that as well, just in case.
aR kEi

Posts: 21
Registered: 10/07/05
Re: ORACLE not available problem 10g release 2
Posted: Oct 13, 2005 7:19 PM   in response to: acrlewis in response to: acrlewis
Click to report abuse...   Click to reply to this thread Reply
thx for your great help, acrlewis !!
acrlewis

Posts: 21
Registered: 06/28/00
Re: ORACLE not available problem 10g release 2
Posted: Oct 14, 2005 6:25 AM   in response to: aR kEi in response to: aR kEi
Click to report abuse...   Click to reply to this thread Reply
No problem buddy, post back here if you continue to have issues with it
user490661

Posts: 6
Registered: 02/25/06
Re: ORACLE not available problem 10g release 2
Posted: Feb 25, 2006 2:00 PM   in response to: aR kEi in response to: aR kEi
Click to report abuse...   Click to reply to this thread Reply
See

http://forums.oracle.com/forums/thread.jspa?messageID=1215843
Pages: 1
Back to Thread List Back to Thread List
Legend
Guru Guru : 2500 - 1000000 pts
Expert Expert : 1000 - 2499 pts
Pro Pro : 500 - 999 pts
Journeyman Journeyman : 200 - 499 pts
Newbie Newbie : 0 - 199 pts
Oracle ACE Director
Oracle ACE Member
Oracle Employee ACE
Helpful Answer (5 pts)
Correct Answer (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums