Home » RDBMS Server » Security » Problem in connecting as sysdba for manual database creation
Problem in connecting as sysdba for manual database creation [message #61510] Thu, 29 April 2004 21:24 Go to next message
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 #61511 is a reply to message #61510] Thu, 29 April 2004 22:38 Go to previous messageGo to next message
Anatol Ciolac
Messages: 113
Registered: December 2003
Senior Member
What error you give???
Re: Problem in connecting as sysdba for manual database creation [message #61513 is a reply to message #61510] Fri, 30 April 2004 00:15 Go to previous messageGo to next message
Ronald
Messages: 15
Registered: October 2001
Junior Member
Check your password parameter in "initSID.ora" file and set the parameter to "Exclusive"
Re: Problem in connecting as sysdba for manual database creation [message #61521 is a reply to message #61510] Fri, 30 April 2004 15:59 Go to previous message
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
Previous Topic: creating a new user and grant issues
Next Topic: creating a new user and grant issues
Goto Forum:
  


Current Time: Tue Mar 19 05:45:02 CDT 2024