-
ORA-01031: insufficient privileges message
Hi
I have installed Oracle 9 and it has generated the initial db without any problems. The db is running but when I attempt to perform the following
sqlplus /nolog
connect / as sysdba
or
connect system/@DB AS systdba
I get the ORA-01031: insufficient privileges message.
I understand that this may be a groups issue but the Oracle9 user is assigned to the dba group although the Primary group is orainventory.
I have just investigated this further and can do a
conn sys/ as sysdba
I am missing something here. Apologies for the dumb questions but I haven't touched DBA work for 2-3 years so a little rusty !!
Kevin
-
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
open your sqlnet.ora file and uncomment "SQLNET.AUTHENTICATION_SERVICES" parameter
-nagarjuna
-
Kevin
Check remote_login_passwordfile init.ora parameter.
If it is "exclusive", then u need to create a password file.
use the orapwd utility to create it
$orapwd file=orapwtest password=pwd entries=5
I suggest u create another user with DBA privileges and create the password file, and set the remote_login_passwordfile=exclusive.
SQL>create user dbmon identified by ...
SQL>grant connect, resource, dba, sysdba to dbmon;
Now on any client machine u can connect as sysdba.
c:\>>sqlplus /nolog
SQL>connect dbmon@ as sysdba
Enter password: -- enter the pwd
Connected.
SQL>
Hope this helps.
-
Originally posted by nagarjuna
open your sqlnet.ora file and uncomment "SQLNET.AUTHENTICATION_SERVICES" parameter
There is no sqlnet.ora. I am doing that on the server.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Originally posted by suhasd75
Kevin
Check remote_login_passwordfile init.ora parameter.
If it is "exclusive", then u need to create a password file.
use the orapwd utility to create it
$orapwd file=orapwtest password=pwd entries=5
I suggest u create another user with DBA privileges and create the password file, and set the remote_login_passwordfile=exclusive.
SQL>create user dbmon identified by ...
SQL>grant connect, resource, dba, sysdba to dbmon;
Now on any client machine u can connect as sysdba.
c:\>>sqlplus /nolog
SQL>connect dbmon@ as sysdba
Enter password: -- enter the pwd
Connected.
SQL>
Hope this helps.
remote_login_passwordfile=exclusive and of course I have the password file. And moreover, I am running the command on the server side.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Originally posted by julian
There is no sqlnet.ora. I am doing that on the server.
What if u r doing on server.. sqlnet.ora has no role here?? ..
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Originally posted by abhaysk
What if u r doing on server.. sqlnet.ora has no role here?? ..
Gee, I answered the wrong thread. Sorry :-)
I had the following problem:
SQL> conn / as sysdba
Connected.
SQL> exec dbms_stats.gather_fixed_objects_stats('ALL');
BEGIN dbms_stats.gather_fixed_objects_stats('ALL'); END;
*
ERROR at line 1:
ORA-20000: Insufficient privileges to analyze an object in Fixed Ob
ORA-06512: at "SYS.DBMS_STATS", line 11802
ORA-06512: at "SYS.DBMS_STATS", line 12085
ORA-06512: at "SYS.DBMS_STATS", line 12599
ORA-06512: at line 1
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bi
PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for Solaris: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production
What do you suggest??
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Originally posted by julian
What do you suggest??
Open a case with Oracle.. in metalink
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Originally posted by abhaysk
Open a case with Oracle.. in metalink
:-( Thanks. Never crossed my mind :-)
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
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
|