| SQLPLUS not logging in. [message #405206] |
Wed, 27 May 2009 00:23  |
lancyld
Messages: 9
Registered: May 2009
|
Junior Member |
|
|
I installed oracle 9.0.1 on windows 2003 enterprise edition sp1 (with oracle database enterprise & software only.)
when i goto the command prompt and type sqlplus /nolog and startup nomount it give me an error
ORA-01031: insufficient privileges
I have checked in windows for the user group called ORA_DBA
I login into windows 2003 using administrator
and administrator is added in the ora_dba group
i used orapwd utility to create a password file with path as d:\oracle\ora90\database. this is where my oracle is installed.
even i changed the remote_login_passwordfile to exclusive in the initSID.ora folder
also my initSID.ora is placed in the same database folder
please help me logon to Oracle.
|
|
|
|
|
|
| Re: SQLPLUS not logging in. [message #405208 is a reply to message #405207] |
Wed, 27 May 2009 00:34  |
lancyld
Messages: 9
Registered: May 2009
|
Junior Member |
|
|
I get this error when tried to logon as u said
C:\>sqlplus "/ as sysdba"
SQL*Plus: Release 9.0.1.0.1 - Production on Wed May 27 11:06:07 2009
(c) Copyright 2001 Oracle Corporation. All rights reserved.
ERROR:
ORA-01031: insufficient privileges
Enter user-name:
I also have searched the forum since morning and tried many options but its not at all working
please help me
[Updated on: Wed, 27 May 2009 00:35] Report message to a moderator |
|
|
|
|
|
| Re: SQLPLUS not logging in. [message #405212 is a reply to message #405211] |
Wed, 27 May 2009 00:45 |
lancyld
Messages: 9
Registered: May 2009
|
Junior Member |
|
|
Sir could you please tell me wheres this file residing.
Is it in the oracle\ora90\database folder
As when i searched in my oracle folder i got one file in the D:\oracle\ora90\network\ADMIN\SAMPLE folder
whats the actual path of this file in a oracle instance?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
