A small but very useful tip on connecting to local and remote Oracle databases using SQL Plus
You must be already aware of this - how to connect to a local database using SQL plus. If not, it is very simple as given below: -
sqlplus user/pass@sidname
But, do you know how to connect to a database which is running on a different host.The following command will help you to achieve this.
sqlplus "user/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=xxx.xxx.x.xxx)(Port=1521))(CONNECT_DATA=(SID=sidname)))"
Hope you find this tip useful.
You must be already aware of this - how to connect to a local database using SQL plus. If not, it is very simple as given below: -
sqlplus user/pass@sidname
But, do you know how to connect to a database which is running on a different host.The following command will help you to achieve this.
sqlplus "user/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=xxx.xxx.x.xxx)(Port=1521))(CONNECT_DATA=(SID=sidname)))"
Hope you find this tip useful.
No comments:
Post a Comment