I recently changed my database from dedicated server to shared server. The problem is I can't connect to the server from another machine. I get this error:
I ran 'lsnrctl services' and got this:
Could these instances (in red) be an issue?
Code:
Enter user-name: /@pan as sysdba
ERROR:
ORA-12170: TNS:Connect timeout occurred
I ran 'lsnrctl services' and got this:
Code:
LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "TEST" has 2 instance(s).
[COLOR=red]Instance "TEST", status UNKNOWN, [/color]has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:6 refused:0
LOCAL SERVER
[COLOR=red]Instance "TEST", status READY, [/color]has 4 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
"D002" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER <machine: PANDATA, pid: 2712>
(ADDRESS=(PROTOCOL=tcp)(HOST=PANDATA.apainsurance.org)(PORT=1339))
"D001" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER <machine: PANDATA, pid: 1576>
(ADDRESS=(PROTOCOL=tcp)(HOST=PANDATA.apainsurance.org)(PORT=1338))
"D000" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER <machine: PANDATA, pid: 3748>
(ADDRESS=(PROTOCOL=tcp)(HOST=PANDATA.apainsurance.org)(PORT=1337))
The command completed successfully