Showing posts with label Oradim. Show all posts
Showing posts with label Oradim. Show all posts

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 ..