Question : I am currently working on a duplicated infrastructure like this : We have two data server, with two […]
Tag: tnsnames
Oracle: converting a TNS entry with SID to instantclient?
Question : How do I convert a TNS entry that has a SID to instantclient format? I’m able to connect […]
can not connect to oracle database with ip address
Question : I am new to oracle database, I have installed Oracle 11.g on redhat 5.6, I have a database […]
TNS_ADMIN / TNSNAMES location failover
Question : Is there a way to have multiple tnsnames.ora locations defined? We currently use a server path like TNS_ADMIN=\192.168.1.100infosysoracletnsnames […]
Why I can tnsping Server P from Server A but cannot tnsping Server P from Server B?
Question : Here is my situation: I can ping P from both server A and Server B. But I just […]
Significance of “.WORLD” on end of Oracle connection
Question : What is the significance of having “.WORLD” on the end of an Oracle connection name? I’ve found things […]
Unable to connect to pluggable database using TNS but EZCONNECT is OK
Question : I installed oracle 12c pn windows following the defaults settings… I end up with ORCL and ORCLPDB… I […]
use SQLcl with EZconnect and multiple hostnames (ADDRESS_LIST=)
Question : this is our classic tnsnames.ora test1= (DESCRIPTION= (CONNECT_TIMEOUT=4) (TRANSPORT_CONNECT_TIMEOUT=3) (ENABLE=BROKEN) (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=example1.example.com)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=example2.example.com)(PORT=1521)) ) (CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME=EXAMPLE.EXAMPLE.DBS) ) […]
Connect analysis services to oracle database
Question : I am looking to connect analysis services to an oracle database, and when I hit Process in AS, […]