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 ..
Everything Changes
2 weeks ago
No comments:
Post a Comment