| Problem in connecting as sysdba for manual database creation [message #61510] |
Thu, 29 April 2004 21:24  |
Saeed Ahmad
Messages: 1
Registered: April 2004
|
Junior Member |
|
|
I am trying to create database without database configuration assistant. I have created service and password file with oradim utility. Next i have set Oracle_sid=newsid but still when i try to connect with oracle from new password file through sqlplus i didnot succeeded. And without this i cannot run create database command successfully.
Saeed
|
|
|
|
|
|
|
|
| Re: Problem in connecting as sysdba for manual database creation [message #61521 is a reply to message #61510] |
Fri, 30 April 2004 15:59  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
First you make sure the newly created service is "Started". Then you have to connect as:
SQL> connect sys/change_on_install as sysdba
and issue the CREATE DATABASE command. Example:
connect SYS/change_on_install as SYSDBA
startup nomount pfile="d:TEMPcreateinit.ora";
CREATE DATABASE GPRDLAB1
MAXINSTANCES 1
MAXLOGHISTORY 1
HTH,
clio_usa - OCP 8/8i/9i DBA
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
