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 ..
Halim, a Georgia Tech graduate Senior Database Engineer/Data Architect based in Atlanta, USA, is an Oracle OCP DBA and Developer, Certified Cloud Architect Professional, and OCI Autonomous Database Specialist. With extensive expertise in database design, configuration, tuning, capacity planning, RAC, DG, scripting, Python, APEX, and PL/SQL, he combines technical mastery with a passion for innovation. Notably, Halim secured 16th place worldwide in PL/SQL Challenge Cup Playoff on the year 2010.
Tuesday, January 11, 2011
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
ASSM states3 weeks ago
-
UKOUG Discover 20241 month ago
-
-
-
-
-
-
-
-
Moving Sideways8 years ago
-
-
Upcoming Events...11 years ago
-
No comments:
Post a Comment