Home » Infrastructure » Linux » Oracle not available (Oracle 10G on Redhat 4 Linux)
Oracle not available [message #323363] Wed, 28 May 2008 05:35 Go to next message
altafhk
Messages: 45
Registered: June 2007
Location: Islamabad
Member

I have oracle10g in linux os. I am weak in linux. I newly joined an organization, there in test server, database was running fine. In /$ORACLE_HOME/network/admin/ there was no listener.ora, tnsname.ora, sqlnet.ora... why and how the database was running.
I created above files. From that time, I am receiving errors
ORA-01034, ORA-27101.
Please help me.
Re: Oracle not available [message #323380 is a reply to message #323363] Wed, 28 May 2008 06:22 Go to previous messageGo to next message
Michel Cadot
Messages: 59499
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
why and how the database was running

The database does not need these files to run.

Quote:
I created above files. From that time, I am receiving errors
ORA-01034, ORA-27101

There is no relation between the 2, either:
- your database is now stopped
- the database you are pointing with these files is not the currently one.

Regards
Michel
Re: Oracle not available [message #323677 is a reply to message #323380] Thu, 29 May 2008 03:49 Go to previous messageGo to next message
altafhk
Messages: 45
Registered: June 2007
Location: Islamabad
Member

Michel,
The problem is errors
ORA-01034 Oracle not available and
ORA-27101 shared memory realm does not exist.

I have one database and in .bash_profile base, home, sid are all set. Again I used set $ORACLE_SID=testdb. I can use workstation (windows) not directly server machine (Redhat linux), so using putty utility. If there is a problem with shutdown database, how can I give command to shutdown abort.
My listener log is:
Started with pid=9521
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testdb)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
29-MAY-2008 13:10:55 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=testdb)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169869568)) * status * 0

[Updated on: Thu, 29 May 2008 04:06]

Report message to a moderator

Re: Oracle not available [message #323682 is a reply to message #323363] Thu, 29 May 2008 03:58 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
conn /as sysdba
startup
Re: Oracle not available [message #323684 is a reply to message #323682] Thu, 29 May 2008 04:13 Go to previous message
altafhk
Messages: 45
Registered: June 2007
Location: Islamabad
Member

Problem solved. It was abnormal shutdown. I applied following commands:
> sqlplus /nolog
> conn system/manager as sysdba
> shutdown abort
> startup

Regards
Altafhk
Previous Topic: Why this script can not make database startup at OS bootup?
Next Topic: Dataguard OS issues
Goto Forum:
  


Current Time: Thu Oct 30 23:55:23 CDT 2014

Total time taken to generate the page: 0.19438 seconds