Hamid - Are you using sqlplus or sysmgr?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 19, 2004 1:49 PM
To: Multiple recipients of list ORACLE-L
Hi list,
when I connect as sys/password as sysdba I get an error not sufficient
privilege
What is the value of your remote_login_password init parameter?
What is the value of SQLNET.AUTHENTICATION_SERVICES in sqlnet.ora file?
-Original Message-
Hamid Alavi
Sent: Monday, January 19, 2004 2:49 PM
To: Multiple recipients of list ORACLE-L
Hi list,
when I connect as sys/password
sqlplus
-Original Message-
Sent: Monday, January 19, 2004 2:00 PM
To: Multiple recipients of list ORACLE-L
Hamid - Are you using sqlplus or sysmgr?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 19, 2004 1:49 PM
To: Multiple
here it is:
remote_login_password= EXCLUSIVE
sqlnet.authentication=(NTS)
-Original Message-
Sent: Monday, January 19, 2004 2:01 PM
To: Multiple recipients of list ORACLE-L
What is the value of your remote_login_password init parameter?
What is the value of SQLNET.AUTHENTICATION_SERVICES
Do you have that password in your password file?
-Original Message-
Sent: Monday, January 19, 2004 4:14 PM
To: Multiple recipients of list ORACLE-L
here it is:
remote_login_password= EXCLUSIVE
sqlnet.authentication=(NTS)
-Original Message-
Sent: Monday, January 19, 2004 2:01 PM
the password still is chamge_on_install I could connect as a normal user
means it's there but not enough privilege to connect as sysdba.
-Original Message-
Sent: Monday, January 19, 2004 3:25 PM
To: Multiple recipients of list ORACLE-L
Do you have that password in your password file?
:RE: SYS Privilege
the password still is chamge_on_install I could connect as a normal user
means it's there but not enough privilege to connect as sysdba.
-Original Message-
Sent: Monday, January 19, 2004 3:25 PM
To: Multiple recipients of list ORACLE-L
Do you have that password
Use the ORAPWD.EXE utility and create a password file:
Assume your DB name is test:
1. Find any files named testpwd.ora.
2. Delete these file(s)
3. Find orapwd.exe and, at the command line:
c:\oracle\ora92\bin orapwd file=testpwd.ora password=ginger
no spaces before or after the=signs.
The