Here are the examples to connect using sqlplus to an oracle database without adding any tnsnames entry.
sqlplus scott/tiger@//10.103.18.99:1560/practicedb
If it does not work try this too
connect scott/tiger@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.103.18.99)(PORT = 1560))) (CONNECT_DATA = (SID = practicedb)))
sqlplus scott/tiger@//10.103.18.99:1560/practicedb
If it does not work try this too
connect scott/tiger@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.103.18.99)(PORT = 1560))) (CONNECT_DATA = (SID = practicedb)))
No comments:
Post a Comment