Create database

[vrudenko]

Hi,

I need DBA's help. I tried to create database by using a script. I prepared init.ora file, created and run service and run SQLPlus and than tried to startup an instance:
SQL>startup nomount pfile="my_init_ora"
I got an error ORA-27100: shared memory realm already exists

Please tell me how handle that

Platform: Oracle 8.1.7.0.0 on Windows 2000

Thank you in advance

 

[sem]

It means that you probably have another instance already started.

Regards, Dima

 

[cliousa]

Shutdown the instance first, then try again. And always set the oracle_sid on the command prompt before working with each instance, eg.

c:\>set oracle_sid=.....
c:\>sqlplus /nolog
SQL> .....




Hope that helps,
clio_usa - OCP DBA
------------------

http://www.dbaclick.com