Tuesday, January 11, 2011

Connect to the oracle instance without creating any database

Connect to the oracle instance without creating any database
-------------------------------------------------------------
suppose requirement like bellows :-

I have not created any database.
I have only install the oracle software.
I just want to connect to the Ideal instance of database through sqlplus.


Solution:-
=========
create a service name with oradim utility .

CMD> set oracle_sid=prod

CMD> oradim -NEW -SID prod -STARTMODE auto -PFILE C:\oracle\product\10.1.0\admin\prod\pfile\init.ora

Then start the service ...

then you can connect to the idle instance ..

No comments: