Windows 7 install oracle 11 g,

Related parameters configuration is as follows:
SQLNET. AUTHENTICATION_SERVICES=(NTS)
NAMES. DIRECTORY_PATH=(TNSNAMES EZCONNECT)

Os_authent_prefix=OPS $
Remote_os_authent=false
Remote_login_passwordfile=EXCLUSIVE

Perform the conn/as sysdba can be successful,
Execute the following statement, however, when connection error:
The create user ops $administrator identified externally;
Grant connect, the resource to ops $administrator;
Conn/
ORA - 01017,

It's urgent, hope to recognize

CodePudding user response:

Conn ops $administrator/externally

CodePudding user response:

The average user login can also use operating system authentication? You have so many don't know which login user system

CodePudding user response:

reference 1st floor js14982 response:

conn ops $administrator/externally

10 g
SQL> Conn ops $administrator/externally
ERROR:
ORA - 01017: invalid username/password. Logon denied

CodePudding user response:

reference sych888 reply: 3/f

Quote: refer to 1st floor js14982 response:

Conn ops $administrator/externally

10 g
SQL> Conn ops $administrator/externally
ERROR:
ORA - 01017: invalid username/password. Logon denied

First, the user to unlock
The alter user ops $administrator account unlock.
Secondly he create user password command is wrong, identified by, create statements off a by
The alter user ops $administrator identified by externally;
The above two statements can be executed concurrently
The alter user ops $administrator identified by externally account unlock;
Again through the user password link
Conn ops $administrator/externally

CodePudding user response:

reference 4 floor js14982 response:

Quote: reference sych888 reply: 3/f

Quote: refer to 1st floor js14982 response:

Conn ops $administrator/externally

10 g
SQL> Conn ops $administrator/externally
ERROR:
ORA - 01017: invalid username/password. Logon denied

First, the user to unlock
The alter user ops $administrator account unlock.
Secondly he create user password command is wrong, identified by, create statements off a by
The alter user ops $administrator identified by externally;
The above two statements can be executed concurrently
The alter user ops $administrator identified by externally account unlock;
Again through the user password link
Conn ops $administrator/externally

I checked the user status is OPEN

In this machine you can test your method?
Is the version of the database?

CodePudding user response:

reference 5 floor sych888 reply:

I checked the user status is OPEN

In this machine you can test your method?
Is the version of the database?

I didn't check lock is unlocked, but I remember the new user is locked?
I 11 g database, the native, effective measurement, redefining the password,