Home » RDBMS Server » Networking and Gateways » oracle networking problem (oracle9.2.0.1,oracle linux 4)
oracle networking problem [message #293274] Fri, 11 January 2008 09:16 Go to next message
yjshanmukh
Messages: 4
Registered: January 2008
Junior Member
hi,
we R using oracle 9.2.0.4 on oracle linux 4
I am having problem with the oracle networking
the alias for the db i created is not pinging but it is
working the other which I have not created & also connecting with
alias to the db

The 1st alias ALIAS was written by me.

The second alias ORCL was created when I was trying OEMAPP CONSOLE where it asked service name and I gave listener1

now the listener file it is taking default (port=1521) was not created by me. I checked the locations $HOME& $ORACLE_HOME/network/admin -->where my actual listener.ora file is there but there no listener with port 1521

when I start listener it is defaultly taking the one with port1521 & even when I start listener1(1522) it is refering to the other one(1521) and the same is the problem with alias names
I am giving the contents and results. can someone suggest me solution for its proper functioning.

my listener.ora file contents

LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = TCP)(HOST = dhcppc11)(PORT = 1522))
)
)
)

SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = /oraeng/app//oracle/product/9.2.0/)
(PROGRAM = extproc)
)
)


my tnsnames.ora file contents

ALIAS =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dhcppc11)(PORT = 1522))
)
)
) (CONNECT_DATA =
(SID = ORCL)
(SERVER = DEDICATED)
)

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dhcppc11)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
(SERVER = DEDICATED)
)
)




[oracle@dhcppc11 admin]$ lsnrctl status

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 11-JAN-2008 20:18:17

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@dhcppc11 admin]$ lsnrctl start listener1

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 11-JAN-2008 20:18:33

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Starting /oraeng/app//oracle/product/9.2.0//bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.2.0.4.0 - Production
System parameter file is /oraeng/app//oracle/product/9.2.0//network/admin/listener.ora
Log messages written to /oraeng/app//oracle/product/9.2.0/network/log/listener1.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dhcppc11)(PORT=1522)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias listener1
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 11-JAN-2008 20:18:33
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oraeng/app//oracle/product/9.2.0//network/admin/listener.ora
Listener Log File /oraeng/app//oracle/product/9.2.0/network/log/listener1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dhcppc11)(PORT=1522)))
Services Summary...
Service "ORCL" has 1 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@dhcppc11 admin]$ lsnrctl status

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 11-JAN-2008 20:18:42

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@dhcppc11 admin]$ lsnrctl status listener1

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 11-JAN-2008 20:18:49

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias listener1
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 11-JAN-2008 20:18:33
Uptime 0 days 0 hr. 0 min. 15 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oraeng/app//oracle/product/9.2.0//network/admin/listener.ora
Listener Log File /oraeng/app//oracle/product/9.2.0/network/log/listener1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dhcppc11)(PORT=1522)))
Services Summary...
Service "ORCL" has 1 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@dhcppc11 admin]$ lsnrctl start

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 11-JAN-2008 20:19:01

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Starting /oraeng/app//oracle/product/9.2.0//bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.2.0.4.0 - Production
System parameter file is /oraeng/app//oracle/product/9.2.0//network/admin/listener.ora
Log messages written to /oraeng/app//oracle/product/9.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dhcppc11)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 11-JAN-2008 20:19:01
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oraeng/app//oracle/product/9.2.0//network/admin/listener.ora
Listener Log File /oraeng/app//oracle/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dhcppc11)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@dhcppc11 admin]$ tnsping ALIAS

TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 11-JAN-2008 20:19:37

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dhcppc11)(PORT = 1522))))) (CONNECT_DATA = (SID = ORCL) (SERVER = DEDICATED))

[oracle@dhcppc11 admin]$ tnsping ORCL

TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 11-JAN-2008 20:19:48

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dhcppc11)(PORT = 1521))) (CONNECT_DATA = (SID = ORCL) (SERVER = DEDICATED)))
OK (10 msec)

[oracle@dhcppc11 admin]$ sqlplus system/manager@alias

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 11 20:23:04 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve service name


Enter user-name: system
Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL> sho user
USER is "SYSTEM"
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
[oracle@dhcppc11 admin]$ sqlplus system/manager@orcl

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 11 20:23:34 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL> sho user
USER is "SYSTEM"
SQL>


Regards

jay




Re: oracle networking problem [message #293550 is a reply to message #293274] Mon, 14 January 2008 01:09 Go to previous messageGo to next message
vishym_68
Messages: 8
Registered: September 2007
Location: India
Junior Member
Hi,
The Listener running on default port 1521 is created by default when you have created the Database through DBCA.
Maybe it has not been automated to startup automatically , hence when you give the command
"oracle@dhcppc11 admin]$ lsnrctl status -- It is giving the following error
-----------------------------------------
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
-----------------------------------------
Either you automate so that the Listener starts up automatically or start the Listener before starting the Database.

Whnever you are using the Listener to port other than Default port , PMON cannot register with the Listener.
If you want PMON to register with a local listener that does not use TCP/IP, port 1521,configure the LOCAL_LISTENER parameter in the initialization parameter file to locate the local listener.

Set the LOCAL_LISTENER parameter as follows:
LOCAL_LISTENER=listener_alias.

For example, if the listener is configured to listen on port 1522 rather than port 1521,you can set the LOCAL_LISTENER parameter in the initialization parameter file as
follows:
LOCAL_LISTENER=listener1

You can then resolve listener_alias <listener1> in the local tnsnames.ora as follows:
listener1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1522)))

For More info pls refer to the Oracle 9i Net Services Administration Guide.
Re: oracle networking problem [message #294050 is a reply to message #293550] Wed, 16 January 2008 04:40 Go to previous messageGo to next message
yjshanmukh
Messages: 4
Registered: January 2008
Junior Member
I tried to mention in initxxx.ora the following parameter
local_listener=listener1 (also tried with whole path & with single quotes)

but it throwed the following error when I tried to start the db


SQL> startup
ORA-00119: invalid specification for system parameter local_listener
ORA-00132: syntax error or unresolved network name '/oraeng/app/oracle/product/9.2.0/network/admin/listener1'


thanks
jay
Re: oracle networking problem [message #294226 is a reply to message #293274] Wed, 16 January 2008 22:01 Go to previous messageGo to next message
vishym_68
Messages: 8
Registered: September 2007
Location: India
Junior Member
Hi,

ORA-00132: syntax error or unresolved network name 'string'
Cause: Listener address has syntax error or cannot be resolved.
Action: If a network name is specified, check that it corresponds to an entry in TNSNAMES.ORA or other address repository as configured for your system. Make sure that the entry is syntactically correct.

Have you mentioned the Local Listener in the local TNSNAMES.ora, so that It can be resolved.
Re: oracle networking problem [message #294370 is a reply to message #293274] Thu, 17 January 2008 06:22 Go to previous message
vishym_68
Messages: 8
Registered: September 2007
Location: India
Junior Member
Hi,
Let me explain with an Example :

For example, if the listener is configured to listen on port 1421 rather than port 1521,
you can set the LOCAL_LISTENER parameter in the initialization parameter file as follows:
LOCAL_LISTENER=listener1
You can then resolve listener1 in the local tnsnames.ora as follows:
listener1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1421)))

Hope this helps. Pls. refer to the Oracle9i Net Services Administrator's Guide
Previous Topic: ORA-12154 while importing from sql server
Next Topic: ORA-20000 while using FTP
Goto Forum:
  


Current Time: Thu Mar 28 11:24:41 CDT 2024