Need help creating a database

From: Randy Harris <randy_at_SpamFree.com>
Date: Mon, 07 Nov 2005 19:57:08 GMT
Message-ID: <okObf.5601$Y61.1280@newssvr33.news.prodigy.com>

I'm trying to follow the 9i docs for "Manually Creating an Oracle Database".

Step 1
Select a SID, create ORACLE_SID env var Done

Step 2
Establish DBA authentication method
I chose OS authentication - my user is a member of dba group

Step 3
Create the pfile
Done

Step 4
Connect to the instance
From docs:
$ sqlplus /nolog
connect sys/password as sysdba

What password?

connect / as sysdba gives me insufficient privelege error

connect sys/ as sysdba prompts for a psssword

How do I get past this?

In step 6, it shows how to set the sys password when issuing the CREATE DATABASE command but I can't get to that point. Received on Mon Nov 07 2005 - 13:57:08 CST