| Oracle not available [message #323363] |
Wed, 28 May 2008 05:35  |
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 #323677 is a reply to message #323380] |
Thu, 29 May 2008 03:49  |
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 #323684 is a reply to message #323682] |
Thu, 29 May 2008 04:13 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
