SQL> connect sys/pass@orcl as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
SQL> connect sys/pass@orcl
Connect durchgeführt.
SQL>
SQL> show parameter remote
NAME TYPE VALUE
------------------------------------ ------- -------------------
remote_dependencies_mode string TIMESTAMP
remote_login_passwordfile string NONE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE
SQL>
SQL>disconnect
Verbindung zu Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production With the Partitioning option
JServer Release 8.1.7.0.1 - Production beendet
shutdown database, edit init.ora file set remote_login_passwordfile = EXCLUSIVE. Create new password file using orapwd .. If old one exists then rename it..
orapwd file=orapwORCL entries=10 password=pass
start database again..
SQL> connect sys/pass@orcl as sysdba
Connect durchgeführt.
SQL>
SQL> show user
USER ist "SYS"
SQL> show parameter remote
NAME TYPE VALUE
------------------------------------ ------- -------------------
remote_dependencies_mode string TIMESTAMP
remote_login_passwordfile string EXCLUSIVE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE
SQL>disconnect
Verbindung zu Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production beendet