Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cant connect remotely to shared server 1

Status
Not open for further replies.

haste

Programmer
Feb 27, 2005
96
GH
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:
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
Could these instances (in red) be an issue?
 
Yes, there is the Window XP firewall. I disabled it and was able to connect. Thanx heaps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top