-
Ora-01031insufficient privileges
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.6.0 - Production on Wed May 18 15:32:59 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/oracle as sysdba
Connected to an idle instance.
SQL> startup nomount pfile=initspdemo.ora
ORA-01031: insufficient privileges
Last edited by Subha; 05-18-2005 at 03:49 PM.
-
I am trying to create a database and i am getting this error .
-
Originally posted by Subha
I am trying to create a database and i am getting this error .
sqlplus /nolog
connect / as sysdba
Did you log in?
-
sorry hal, oracle wont let you do that!
use a user with the correct privs - thanks for visiting!
-
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.6.0 - Production on Wed May 18 15:32:59 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/oracle as sysdba
Connected to an idle instance.
SQL> startup nomount pfile=initspdemo.ora
ORA-01031: insufficient privileges
oracle:x:1001:101:Oracle dba :/usr/local/oracle:/bin/ksh
-
-rwsr-s--x 1 oracle dba 69431872 Feb 20 09:37 oracle
-rwxr-x--x 1 oracle dba 1058864 Feb 20 09:38 sqlplus
Last edited by Subha; 05-18-2005 at 04:10 PM.
-
Check the init file privileges and the user privileges to login.....
"What is past is PROLOGUE"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|