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 is a Sr. Database Engineer/Data Architect (in Atlanta, USA) who is an Oracle certified (OCP) DBA, (OCP) Developer, Certified Cloud Architect Professional as well as OCI Autonomous DB specialist with extensive expertise in Database design, configuration, tuning, capacity planning, RAC, DG, Scripting, Python, PL/SQL etc. He achieved 16th position in worldwide first-ever PL/SQL Challenge cup playoff- http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
4096 Columns1 week ago
-
-
-
-
-
-
-
Oracle Cloud & Third party tools4 years ago
-
-
-
Moving Sideways8 years ago
-
Upcoming Events...10 years ago
-
No comments:
Post a Comment