Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Need help creating a database

Re: Need help creating a database

From: Randy Harris <randy_at_SpamFree.com>
Date: Mon, 07 Nov 2005 22:25:57 GMT
Message-ID: <VvQbf.6690$Kv.6124@newssvr22.news.prodigy.net>

"Eric de Redelijkheid" <ericdere_at_xs4all.nl> wrote in message news:436fc6c1$0$11062$e4fe514c_at_news.xs4all.nl...
> Anno Domini 7-11-2005 20:57, Randy Harris sprak aldus:
>
> >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.
> >
> >
> >
> >
> You mixed up both authentication methods, I guess. The OS authentication:
>
> 1. make sure your environment is in order : ORACLE_HOME,ORACLE_SID, PATH
> , etc
> 2. create parameter file - set remote_login_passwordfile=none
> 3. sqlplus "/ as sysdba"
> Connected to an idle instance
> 4. sql> startup nomount
> 5. sql> create database ...
>
> The account SYS is not there until you have created the database. After
> you have created the database and logged in using "/ as sysdba" and type
> on the sql prompt 'show user', lo and behold: SYS

I'm tearing my hair out (not much left) trying to figure this out. I am definitely in the dba group. I set remote_login_passwordfile=none in the parameter file. When I try to connect I get "ORA-01031: insufficient privileges". Is it possible that it is not looking at the parameter file that I created, maybe getting the remote_login_passwordfile setting from another pfile? I can't get in to do the startup nomount. Received on Mon Nov 07 2005 - 16:25:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US