This content has been marked as final. Show 13 replies
Check if your user is in local ORA_DBA group to able to login without password.
set ORACLE_SID variable to the database SID which you want to connect.
C:\Users\myuser>set ORACLE_SID=orcl C:\Users\myuser>echo %ORACLE_SID% orcl C:\Users\myuser>sqlplus "/ as sysdba"
I'm in the ora_dba group, my new database's SID is orcl and I typed the following:
G:\oracle\ora10g\BIN>echo %ORACLE_SID% ORCL G:\oracle\ora10g\BIN>sqlplus "/ as sysdba" SQL*Plus: Release 10.2.0.4.0 - Production on Mon Dec 6 08:14:27 2010 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. ERROR: ORA-01031: insufficient privileges
Is the environment variable TWO_TASK set?
If so, unset it.
log off and log in and try again please.
You want to login to a remote database without password? AFAIK this is not possible.
TWO_TASK always points to a remote database. Don't set this variable for a local one.
Edited by: Kecskemethy on Dec 6, 2010 5:49 AM
typo fix remove => remote
Edited by: Kecskemethy on Dec 6, 2010 5:50 AM
No, TWO_TASK is not set:
G:\>echo %TWO_TASK% %TWO_TASK%
No, I don't want to remove the database, I'm trying to login to it using sys so I can change all the passwords from the datapump import I just executed. I imported a copy of production and the dba told me to login with:
so I could then change all of the passwords.
sqlplus / as sysdba
I logged off and then back on - no joy.
I run out of ideas.
Please use search feature of this forum:
Just found this!
check $ORACLE_HOME/network/admin/sqlnet.ora file there provide SQLNET.AUTHENTICATION_SERVICES = (NTS)then try again
I had a typo there sorry.
just fixed it: remove => remote
Thanks Kecskemethy, that was it. It was set to NONE. I had considered that, but thought I had it set to NONE the last time I tried this (many moons ago), and it worked then. I am obviously mistaken. Thanks so much for working with me on this! Setting it to NTS did the trick.
Good. You are welcome.