| insufficient privileges [message #125690] |
Tue, 28 June 2005 13:05  |
ravivkumar
Messages: 34
Registered: April 2005
Location: chennai
|
Member |
|
|
hi
i have installed oracle 9i database server in Xp and it worked fine as user / as sysdba , suddenly after installing some software , following error is coming and am unable to login as / as sysdba
C:\>sqlplus
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Jun 28 11:40:47 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: / as sysdba
ERROR:
ORA-01031: insufficient privileges
This is the error am getting. what should i do to enter as a sysdba , am the dba .
when i restart the system and enter its giving
Oracle Intelligent Agent Executable encountered a problem and needed to close.
szAppName : agntsrvc.exe szAppVer : 0.0.0.0 szModName : unknown
szModVer : 0.0.0.0 offset : 00000000
how to solve this problem , pls any one tell me the way to enter into oracle database as a sysdba.( thro other users i can enter)
Ravikumar.
|
|
|
|
|
|
| Re: insufficient privileges [message #125819 is a reply to message #125690] |
Wed, 29 June 2005 06:51  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
hey Ravi,
U forget to write Username and password for sys.
Try this
: sys/password as sysdba
n surely u will be able to login. U remember sys password. It is asked when u install Oracle.
Tarun
|
|
|
|
| Re: insufficient privileges [message #125884 is a reply to message #125690] |
Wed, 29 June 2005 13:42 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
|
Look into possible problems with your oracle password file. There is a utility program called "orapwd" that you can research further.
|
|
|
|
| Re: insufficient privileges [message #125961 is a reply to message #125690] |
Thu, 30 June 2005 02:50 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Ravi,
On my machine its working. There might b some problem with ur password file . U can try one thing delete the previous password file and create the new one with the help of ORADIM utility.Its not going to effect ur database at all.
Then try it, lets see whether it works or not
Tarun
|
|
|
|
| Re: insufficient privileges [message #125978 is a reply to message #125690] |
Thu, 30 June 2005 05:59 |
shettyshetty
Messages: 18
Registered: June 2005
Location: Malaysia
|
Junior Member |
|
|
Ravi,
Do the following,
From the coommand prompt, issue SET command. This will list down all the environmental variables. Make sure $ORACLE_HOME/bin(D:\oracle\product\10.1.0\em_1\bin; --> In my case) is the first sentence in "PATH" variable.
If you have multiple instances then use SET command
C:\>SET ORACLE_SID=EMREP
C:\>sqlplus /nolog
SQL*Plus: Release 9.0.1.4.0 - Production on Thu Jun 30 17:54:52 2005
(c) Copyright 2001 Oracle Corporation. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL>
Sunil
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
