| listener not Running on SCO UNIX Operating System with ORACLE 7.1.6.2 [message #72985] |
Fri, 09 January 2004 03:15  |
Arvind Bhandari
Messages: 50
Registered: May 2003
|
Member |
|
|
Good Evening,
Here we have a Two Server with different operating system and different versions of ORACLE
1 server contains SCO UNIX 5.0 with ORACLE 7.1.6.2 and
2 server Contains WINDOWS 2000 with ORACLE 9i.
We have a problem related with listner Services is not running on UNIX Machine and when we connect from 9i Server/ or any windows Client Machine by giving host Name(Through TNSNAMES.ORA we have already Defined host String by giving Host Name/ IP Address and SID Name) it gives a error "NO Listner".
so we tried to Start Listner Service on UNIX Machine it gives Error :
I am writing the Following Procedure
to start listner Services on UNIX Machine
$ lsnrctl
LSNRCTL for AT&T System V/386: Version 2.1.6.0.0 - Production on 08-JAN-04 15:32:49
Copyright (c) Oracle Corporation 1994. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> start
Starting /u1/oracle/bin/tnslsnr: please wait...
TNSLSNR for AT&T System V/386: Version 2.1.6.0.0 - Production
NL-00462: error loading parameter file /etc/listener.ora
NL-00405: cannot open parameter file
SNL-00016: snlfohd: error opening file
we have also find Listner.ORA in Oracle Home Directory. But Listner.ORA is not there in oracle Home ie not exists in "etc" folder.I think it may be Deleted. also Initial Parameter file ie Initorcl.ora is ok
is there any solution or reason for that.
Arvind
|
|
|
|
|
|
| Re: listener not Running on SCO UNIX Operating System with ORACLE 7.1.6.2 [message #72991 is a reply to message #72989] |
Fri, 09 January 2004 20:20  |
Arvind Bhandari
Messages: 50
Registered: May 2003
|
Member |
|
|
thanks Mahesh. exactly by default listner.ora is in oracle_home/network/admin directory but in our case there is not network directory in oracle home. and also when we try to start listner it searches in
etc folder ie
NL-00462: error loading parameter file /etc/listener.ora
also how to create listner.ora ? or if create mannually then is there any difference in listner.ora in windows and unix environment.can we copy listner.ora of oracle 8 in windows os to unix by changing database name parameter and host address
here in windows NT the contents of listner.ora in oracle 8 is
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= MIRASHNT)
(PIPE= ORAPIPE)
)
(ADDRESS=
(PROTOCOL= TCP)
(Host= mirashnt)
(Port= 1521)
)
(ADDRESS=
(PROTOCOL= TCP)
(Host= mirashnt)
(Port= 1526)
)
(ADDRESS=
(PROTOCOL= TCP)
(Host= 127.0.0.1)
(Port= 1521)
)
(ADDRESS=
(PROTOCOL= SPX)
(Service= mirashnt_lsnr)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = 0
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = mirashnt)
(SID_NAME = ORCL)
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM=extproc)
)
)
PASSWORDS_LISTENER = (oracle)
thanks
Arvind
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
