Monday, July 14, 2014

sqlplus connect to database without using the SID

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