sqlplus connect to database without using the SID
sqlplus connect to database using description string
sqlplus change expired password
here's the command:
sqlplus user_name/password@"description_string"
Example description string (keep all brackets): (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=name_or_IP)(PORT=1521))(CONNECT_DATA=(SID=sid_name)))
In the case of expired password, it will prompt you to enter a new password.
No comments:
Post a Comment