hot to connect oracle server from remote using router

[njaluka]

Please help me , I want to access oracle server from remote location.
I am using the router for internet connection in both side.

but it is not connecting.

the diagram in the server side is like bellow

Client Side
Client Machine------------->Router------(Interner)
(LAN)



Server Side
(Internet)--------->Router----------------->Oracle Server
(Fix IP (LAN)
with port
forwarding)

LISTENER.ORA
--------------
PASSWORDS_LISTENER= (oracle)

STARTUP_WAIT_TIME_LISTENER = 0

LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world))
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (COMMUNITY = NMP.world)(PROTOCOL = NMP)(SERVER = JEWELAGE)(PIPE = ORAPIPE))
(ADDRESS = (PROTOCOL = TCP)(Host = jewelage)(Port = 1521))
(ADDRESS = (PROTOCOL = TCP)(Host = jewelage)(Port = 1526))
(ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
(ADDRESS = (PROTOCOL = TCP)(Host = jewelage)(Port = 1520))
(ADDRESS = (PROTOCOL=IPC)(KEY=J))
)

CONNECT_TIMEOUT_LISTENER = 10

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = jewelage)
(SID_NAME = ORCL)
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM = extproc)
)
(SID_DESC = (SID_NAME=J))
)

TRACE_LEVEL_LISTENER = 0


TNSNAMES.ORA
--------------
JA.TCP.KGK =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 60.121.134.131)(PORT = 1520))
(CONNECT_DATA = (SID = J))
)



Note : The IP Address has changed for security reasons.


thanks

nirmal

 

[rcurva]

Let's start with this one:

JA.TCP.KGK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 60.121.134.131)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 60.121.134.131)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = J)
)
)

One question, can you start your listener correctly? I mean, no errors encountered?

 

[njaluka]

Thanks for reply ,

if i put the ip address in the listener.ora then listener can not start , it is giving following error.

Could not start the Oracle TNSListener80 service \\jewelage
error 1067 : The process terminated unexpectedly.


plese help me to solve the problem

 

[njaluka]

Please help me , I want to access oracle server from remote location.
I am using the router for internet connection in both side.

but it is not connecting.

the diagram in the server side is like bellow

Client Side
Client Machine------------->Router------(Interner)
(LAN)



Server Side
(Internet)--------->Router----------------->Oracle Server
(Fix IP (LAN)
with port
forwarding)

LISTENER.ORA
--------------
PASSWORDS_LISTENER= (oracle)

STARTUP_WAIT_TIME_LISTENER = 0

LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world))
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (COMMUNITY = NMP.world)(PROTOCOL = NMP)(SERVER = JEWELAGE)(PIPE = ORAPIPE))
(ADDRESS = (PROTOCOL = TCP)(Host = jewelage)(Port = 1521))
(ADDRESS = (PROTOCOL = TCP)(Host = jewelage)(Port = 1526))
(ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
(ADDRESS = (PROTOCOL = TCP)(Host = jewelage)(Port = 1520))
(ADDRESS = (PROTOCOL=IPC)(KEY=J))
)

CONNECT_TIMEOUT_LISTENER = 10

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = jewelage)
(SID_NAME = ORCL)
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM = extproc)
)
(SID_DESC = (SID_NAME=J))
)

TRACE_LEVEL_LISTENER = 0


TNSNAMES.ORA
--------------
JA.TCP.KGK =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 60.121.134.131)(PORT = 1520))
(CONNECT_DATA = (SID = J))
)


if i put the ip address in the listener.ora then listener can not start , it is giving following error.

Could not start the Oracle TNSListener80 service \\jewelage
error 1067 : The process terminated unexpectedly.


plese help me to solve the problem


Note : The IP Address has changed for security reasons.


thanks

nirmal

 

[rcurva]

Before we proceed further, need to clarify with you the ffg, otherwise we don't need to touch listener.ora:

You have mentioned that after you put the ip address in the listener.ora, the listener can not start. Does removing the ip address from the listener.ora file starts the listener without any errors?

If you can start the listener, can you do a tnsping of the instance?

I assume, you are using WinNT. More questions:

1. What can you see when u issue ipconfig?
2. Are you using NMP protocol in your server? If not, erase the (ADDRESS = (COMMUNITY = NMP.world)(PROTOCOL = NMP)(SERVER = JEWELAGE)(PIPE = ORAPIPE)) from your listener.ora.
3. Can you ping jewelage? loopback?
4. Lets make your listener more readable, but make a backup of your original listener.ora. Create another one with the following:

-------------starts here------------------------------

LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world))
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (PROTOCOL = IPC)(KEY = J))
(ADDRESS = (PROTOCOL = TCP)(Host = jewelage)(Port = 1521))
(ADDRESS = (PROTOCOL = TCP)(Host = jewelage)(Port = 1526))
(ADDRESS = (PROTOCOL = TCP)(Host = jewelage)(Port = 1520))
(ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME=yourorahome )
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM = extproc)
(ORACLE_HOME=yourorahome )
)
(SID_DESC =
(SID_NAME = J)
(ORACLE_HOME=yourorahome )
)
)

CONNECT_TIMEOUT_LISTENER = 10
PASSWORDS_LISTENER= (oracle)
STARTUP_WAIT_TIME_LISTENER = 0
TRACE_LEVEL_LISTENER = USER

-----------------ends here-------------------------------

Try to start the listener again. Post the exact errors if there will be any.

 

[rcurva]

If that still does not work. Make it even simpler such as this one:

LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = jewelage)(Port = 1521))
(ADDRESS = (PROTOCOL = TCP)(Host = jewelage)(Port = 1526))
(ADDRESS = (PROTOCOL = TCP)(Host = jewelage)(Port = 1520))
(ADDRESS = (PROTOCOL = IPC)(KEY = J))
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME=yourorahome )
)
(SID_DESC =
(SID_NAME = J)
(ORACLE_HOME=yourorahome )
)
)

CONNECT_TIMEOUT_LISTENER = 10
PASSWORDS_LISTENER= (oracle)
STARTUP_WAIT_TIME_LISTENER = 0
TRACE_LEVEL_LISTENER = USER

 

[amerbaig]

Can you ping your machine?
Can you connect while using console on physical server?

Reply with exact error

Regards
Amer

 

[kummi]

Hi,
Please check below points-
1. Please check whether your system is connecting to Internet or not.
2. Please check your default gateway.
(check using ipconfig).

what u r using any firewall, if so please check sequrity in u r firewall system and remote firewall system.

Regards,

Kumar.

 

[njaluka]

Hi,

Now the listner can start but from remote i can not connect , this is the content of listener.ora :

LISTENER =
(ADDRESS_LIST =(ADDRESS = (COMMUNITY = TCP.world) (PROTOCOL = TCP)
(HOST = JEWEL)
(SERVER = 61.144.97.87)(PORT= 1522))

(ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
(ADDRESS = (PROTOCOL = SPX)(Service = lanmodem_lsnr))
(ADDRESS = (PROTOCOL = IPC)(KEY = JA))
(ADDRESS = (PROTOCOL = IPC)(KEY = DUMM))
(ADDRESS = (PROTOCOL=IPC)(KEY=TEST))
)


SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = JA)
)
(SID_DESC =
(SID_NAME = DUMM)
)
(SID_DESC = (SID_NAME=TEST))
)

CONNECT_TIMEOUT_LISTENER = 50
PASSWORDS_LISTENER= (oracle)
STARTUP_WAIT_TIME_LISTENER = 0
TRACE_LEVEL_LISTENER = USER


and the client side tnsnames.ora is
JATCP.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 61.144.97.87)(PORT = 1522))
(CONNECT_DATA = (SID = TEST))
)

when i try to connect from remote it is saying

Error ORA:12203 TNS - Unable to connect to destination.

one more thing when i stop the listener it is giving following error.

Error : ORA : 12224 No listener

it means the request is comming , but the listener is rejecting it.

I think this is becuase of Router (both ) side i am using .

Please help me if anyone is having idea.

 

[rcurva]

A few modification from your original file:

LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 61.144.97.87)(PORT= 1522))
(ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
(ADDRESS = (PROTOCOL = SPX)(Service = lanmodem_lsnr))
(ADDRESS = (PROTOCOL = IPC)(KEY = JA))
(ADDRESS = (PROTOCOL = IPC)(KEY = DUMM))
(ADDRESS = (PROTOCOL = IPC)(KEY = TEST))
(ADDRESS = (PROTOCOL = IPC)(KEY = extproc))
)


After starting the listener, can you do a lsnrctl status? Is it really running?

Check also if ORACLE_HOME and ORACLE_SID are correctly set.

If you intend to use external procedures, you should have entries for extproc in listener.ora and tnsnames.ora as well.