| Could Not Mount the Oracle DB [message #116150] |
Mon, 18 April 2005 03:23  |
Nainar
Messages: 35
Registered: January 2005
|
Member |
|
|
Hi
I'm getting error while mounting the Oracle DB.
C:\>set oracle_sid = SERVICENAME
C:\>sqlplus /nolog
SQL*Plus: Release 9.2.0.5.0 - Production on Thu Apr 14 19:35:31 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect /as sysdba
ERROR:
ORA-01031: insufficient privileges
I'm using Oracle 9i version in Windows NT environment. Kinldy give suggestion if any one knows/faced the problem already.
Thanks in advance.
-N
|
|
|
|
|
|
| Re: Could Not Mount the Oracle DB [message #116185 is a reply to message #116172] |
Mon, 18 April 2005 09:01  |
pscjhe
Messages: 38
Registered: April 2005
|
Member |
|
|
oracle_sid=<instanace_name> (without brackets)
not service_name, case doesn't matter in window.
The other possibility is that you have multiple oracle homes and you are not on right Oracle Home path. check out current PATH environment.
D:\>echo %PATH%
D:\Oracle\product\10.1.0\Client_1\bin;D:\Oracle\product\10.1.0\Client_1\jre\1.4.
2\bin\client;D:\Oracle\product\10.1.0\Client_1\jre\1.4.2\bin;d:\sql\ocs-12_0\DLL
;d:\sql\ocs-12_0\bin;d:\sql\DLL;d:\sql\BIN;C:\WINNT\system32;C:\WINNT;C:\WINNT\S
ystem32\Wbem;d:\ORAWIN\BIN;d:\Logician;d:\sql\OCS-12_0\dll;d:\sql\OCS-12_0\bin;C
:\WINNT\System32;C:\WINNT;C:\WINNT\System32\Wbem;d:\Logician\;D:\ORschedule;;d:\
Oacis;
|
|
|
|
| Re: Could Not Mount the Oracle DB [message #116255 is a reply to message #116185] |
Mon, 18 April 2005 18:37 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi
Connecting to the Oracle 9i database with SYS userid with SYSDBA or SYSOPER option produces the error
ORA-01031: "Insufficient Privileges".
CAUSE
SYSDBA & SYSOPER have to be set to TRUE in V$PWFILE_USERS for
SYS user. To verify if they are set to TRUE - run the following
command while logged in as SYS:
Select * from V$PWFILE_USERS ;
RESOLUTION
Create or modify the following parameters in init.ora file on the server
side:
07_DICTIONARY_ACCESSIBILITY = TRUE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
Password file needs to be recreated from $ORACLE_HOME/dbs
directory as (unix system):
orapwd file= password= entries=
EXAMPLE
orapwd file=orapwtest password=oracle entries=6
Note: After the above parameters are added or modified, the service on Oracle database has to be stopped and re-started.
from :- sunil
|
|
|
|
| Re: Could Not Mount the Oracle DB [message #116311 is a reply to message #116255] |
Tue, 19 April 2005 06:51 |
Nainar
Messages: 35
Registered: January 2005
|
Member |
|
|
Thanks Sunil.
I need some more info.
I cudnt connect using sys login. Its throwing Insufficient Privileges error is coming. I'm using oracle 9i in win NT.
as per your suggestion, I cant do any select in the DB.
I checkd the init.ora file. I changed the 07_DICTIONARY_ACCESSIBILITY = TRUE.
REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE
But I dont know how to recreate the password file. Can you give more explanation on this since i'm using Win NT.
Thankx in advance.
Nainar
|
|
|
|
| Re: Could Not Mount the Oracle DB [message #116463 is a reply to message #116311] |
Wed, 20 April 2005 03:58 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi
please try to connect to the oracle database from sql prompt and i hope this should work for you.
sql>connect sys as sysdba
password: change_on_install
But if you want to create password file then see the below written things
-----------------------------------------------------------------
there are two case when you have to create password file
[1] when your password file is corrupt
[2] when you want to change password of sys for security purpose (SYS IS DBA)
below are the instruction to be follwed to create password file
[1]shutdown the database
[2]stop the service by which database starts automatically, this service u can see in control pannel --->in it administrative tool--> in it services (service name:-ORACLESERVICE+SID in Windows NT)
[note:- SID is database name (SID :- SYSTEM IDENTIFIER) so if your database name is mac then service name will be ORACLESERVICEMAC ]
[3]password file are always present in the /oracle_home/database/
[4]so first of all u have to remove the corrupted passwordfile from that location or delete it.
[5]Name of your password file that you are going to create must be pwdsid.ora (note:- u have to give .ora extention if u are working on win NT or 2000)
Below is complete understanding of command by which u can create password file
on dos prompt
c:\>orapwd file=\oracle_home\database\pwdsid.ora password=<password that u want to set> entries=<number of user who can be dba>
note in 9i
oracle_home is ---> eg. D:\oracle\ora90\ (you can have c or d any drive on which oracle is install)
now what u have to do is
C:\>orapwd file=d:\oracle\ora90\database\pwdsid.ora passwrod=nainar entries=5
note :- i believe u have install oracle on d: drive and if u have not install on d: drive then please type that drive in place of d: drive in above command. dont forget to have extension .ora of passwordfile and type your database name at palce of sid (pwdsid.ora) your passwrod will be nainar and 5 user can be granted as sysdba right by DBA.
now go to sqlnet.ora file comment the parameter
SQLNET.AUTHENTICATION_SERVICES
save the file
than again start the service (service name:-ORACLESERVICE+SID in Windows NT)
now try to connect to the oracle database with new password (in your case nainar) that u had created.
-----------------------------------------------------------------
I hope things will work for you now
from:- Mishra sunilkumar vishwanath
|
|
|
|
| Re: Could Not Mount the Oracle DB [message #116639 is a reply to message #116311] |
Thu, 21 April 2005 01:58 |
srix5
Messages: 11
Registered: March 2005
Location: Bangalore
|
Junior Member |
|
|
Hi Nainar,
If you remember the pasword what you have specified while creating the service ( Eg. -intpwd sql, and sql is the password) you can login as sys user easily.
just fire the following command,
first Sqlplus
Enter User Name : sys/sql as sysdba
- Sridhar Krishnan.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
