Often we might need to connect to remote database servers using sqlplus.
In such cases we can use the following connection string format
Open command prompt and execute the following line after giving proper values for
1)remotehostname
2)portnumber
3)sid
4)username
5)password
sqlplus username/password@'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST= remotehostname)(PORT=portnumber)))(CONNECT_DATA=(SID=sid)))'
In such cases we can use the following connection string format
Open command prompt and execute the following line after giving proper values for
1)remotehostname
2)portnumber
3)sid
4)username
5)password
sqlplus username/password@'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST= remotehostname)(PORT=portnumber)))(CONNECT_DATA=(SID=sid)))'
No comments:
Post a Comment