| shared memory realm already exists [message #52451] |
Tue, 23 July 2002 00:47  |
Adina R
Messages: 1
Registered: July 2002
|
Junior Member |
|
|
I had installed Oracle 8i Enterprise and wanted to create a DB on my computer (I copied the db data files from the server). The global db name = TEST and the SID = TEST. The orders are given through cmd prompt, as such:
C:> oradim -new -sid TEST -intpwd manager -startmode auto -pfile D:OradataTESTinitTEST.ora
(the OracleServiceTEST had automatically started)
C:> set ORACLE_SID=TEST
C:> svrmgrl
SVRMGR> connect internal/manager
Connected.
SVRMGR> startup nomount pfile=D:OradataTESTinitTEST.ora
ORA-27100: shared memory realm already exists
SVRMGR> connect internal/manager
Connected.
SVRMGR> shutdown immediate
ORA-01034: ORACLE not available
And the database could not be start. Do anybody know what caused the ORA-27100 and ORA-01034 errors? Please help me. Thank you very much.
|
|
|
|
| Re: shared memory realm already exists [message #52452 is a reply to message #52451] |
Tue, 23 July 2002 01:48  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
first try to do a clean shutdown of datase.
(shutdown immediate).
if it doesnt helps, then go for shutdown abort.
REboot the sytem.
and start the database.
still problems? reset the SID and try again.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
