Home » RDBMS Server » Server Administration » SQLPLUS not logging in. (Windows 2003 / Oracle 9.0.1)
SQLPLUS not logging in. [message #405206] Wed, 27 May 2009 00:23 Go to next message
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 #405207 is a reply to message #405206] Wed, 27 May 2009 00:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot startup if you are not logged.
You have to sqlplus '/ as sysdba'

Regards
Michel
Re: SQLPLUS not logging in. [message #405208 is a reply to message #405207] Wed, 27 May 2009 00:34 Go to previous messageGo to next message
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 #405211 is a reply to message #405208] Wed, 27 May 2009 00:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check you have the following line in your sqlnet.ora:
SQLNET.AUTHENTICATION_SERVICES = (NTS)

Regards
Michel
Re: SQLPLUS not logging in. [message #405212 is a reply to message #405211] Wed, 27 May 2009 00:45 Go to previous messageGo to next message
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?
Re: SQLPLUS not logging in. [message #405213 is a reply to message #405212] Wed, 27 May 2009 00:49 Go to previous message
lancyld
Messages: 9
Registered: May 2009
Junior Member
I placed the sqlnet.ora in the D:\oracle\ora90\network\ADMIN
and tried to connect and it connected
thanks a lot sir
you are great
Previous Topic: How to automatically lock account after 10 minutes
Next Topic: Add 2nd listener to same host
Goto Forum:
  


Current Time: Sat Dec 03 22:31:50 CST 2016

Total time taken to generate the page: 0.07084 seconds