How to Connect Oracle DB remotely by sqlplus
1. Update tnsnames.ora with Oracle server you want to connect
C:\Oracle\Middleware\Oracle_Home\network\admin\tnsnames.ora
ex
OraServer1=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 203.292.222.1)(PORT = 1521))
(LOAD_BALANCE = YES)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DEV1
(FAILOVER_MODE =
(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5)
)
)
)
2. Command line
sqlplus username/passs@OraServer1
Subscribe to:
Post Comments (Atom)
AWS how to delete VPC when it has error with Network interface , Gateway decencies
how to delete VPC when it has error with Network interface , Gateway decencies in AWS 1. Check if it is running on EC2 instance then Sto...
No comments:
Post a Comment