I am using the latest 10.0.5 version of the plsql developer software and I use Win 7 prof 64 bit. I have Oracle client 32 bit software installed.
We have two linux 5.1 machines one for devl and another for test instances.
I can connect to any instances in DEVL machine but I can't connect to any instances in TEST machine. I get ORA-12541: TNS:no listener error.
Here is the tnsnames.ora file that I am using. I can connect to any instances in both machines using Oracle SQL Developer 4.0. (I hate SQL developer).
Marco, can you please advice why I can't connect
Host = dev-ebs-mycompany
DEV1=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=dev-ebs-mycompany)
(PORT=1522)
)
(CONNECT_DATA=
(INSTANCE_NAME=DEV1)
(SERVICE_NAME=DEV1)
)
)
Host test-ebs-mycompany:
TST1=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=test-ebs-mycompany)
(PORT=1522)
)
(CONNECT_DATA=
(INSTANCE_NAME=TST1)
(SERVICE_NAME=TST1)
)
)
Any help will be appreciated.
TIA
We have two linux 5.1 machines one for devl and another for test instances.
I can connect to any instances in DEVL machine but I can't connect to any instances in TEST machine. I get ORA-12541: TNS:no listener error.
Here is the tnsnames.ora file that I am using. I can connect to any instances in both machines using Oracle SQL Developer 4.0. (I hate SQL developer).
Marco, can you please advice why I can't connect
Host = dev-ebs-mycompany
DEV1=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=dev-ebs-mycompany)
(PORT=1522)
)
(CONNECT_DATA=
(INSTANCE_NAME=DEV1)
(SERVICE_NAME=DEV1)
)
)
Host test-ebs-mycompany:
TST1=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=test-ebs-mycompany)
(PORT=1522)
)
(CONNECT_DATA=
(INSTANCE_NAME=TST1)
(SERVICE_NAME=TST1)
)
)
Any help will be appreciated.
TIA