OraFAQ Forum: Security » Problem in connecting as sysdba for manual database creation

Home » RDBMS Server » Security » Problem in connecting as sysdba for manual database creation

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Problem in connecting as sysdba for manual database creation [message #61511 is a reply to message #61510]

Thu, 29 April 2004 22:38

Anatol Ciolac
Messages: 113
Registered: December 2003

Senior Member

What error you give???

Report message to a moderator

Re: Problem in connecting as sysdba for manual database creation [message #61513 is a reply to message #61510]

Fri, 30 April 2004 00:15

Ronald
Messages: 15
Registered: October 2001

Junior Member

Check your password parameter in "initSID.ora" file and set the parameter to "Exclusive"

Report message to a moderator

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

Report message to a moderator

Previous Topic:	creating a new user and grant issues
Next Topic:	creating a new user and grant issues

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 21:36:02 CDT 2025