TNS-01152

[rlowe]

Oracle 8.1.5
Solaris 7

I am trying to change listener.ora and cannot start the listener due to the following error:

TNS-01152: All addresses specified for the listener name, LISTENER, failed

I have scanned all ports on the machine, nothing is running on the 4 unique specified ports. I know that this version of listner has some bugs, is this one of them?

Please Advise,
R

[julian]

What values do you have for startup_wait_time_listener and connect_timeout_listener ? Could you post listener.ora?

[rlowe]

Following is a copy of the listener.ora file
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(PROTOCOL_STACK =
(PRESENTATION = TTC)
(SESSION = NS)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sun1004)(PORT = 1521))
(PROTOCOL_STACK =
(PRESENTATION = TTC)
(SESSION = NS)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sun1004)(PORT = 2481))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sun1004)(PORT = 2483))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/OraHome1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = /usr/OraHome1)
(SID_NAME = sun1004)
(PRESPAWN_MAX = 6)
(PRESPAWN_LIST =
(PRESPAWN_DESC =
(PROTOCOL = TCP)
(POOL_SIZE = 3)
(TIMEOUT = 3)
)
)
)
)

I am unsure of what SID_NAME=PLSExtProc and PROGRAM=extproc mean. Can somebody explain?

[julian]

Could it be that some other application is listening on the same addresses?

Have you installed the protocol adapters?

SID_NAME=PLSExtProc and PROGRAM=extproc are neede for calling external procedures.

[rlowe]

What do you mean, "Have you installed the protocol adapters"? Do I need to do something special for this? This db works (sqlplus uname/pass@orcl)... from localhost and other oracle hosts...

Do I need special protocol adapter for PLSExtProc??

R

[sambavan]

Here are some of the things that I could notice of.

1. Provide a fully qualified host.domain in the HOST or provide the IP address on the HOST.

2. I notice the SID name to be the same as your Host name. Have your created the Oracle instace same as your HOST? Its not a good practice. On the other hand its not harm again. If you have created your instance name different from that of the SID you have provided, you would want to change that.

3. PLSExtProc gets greated bu the ORACLE and you don't have to worry about that.

4. Use the netstat to check all the ports that are currently being used.

Hope one of the above would give you the fix.

Sam

[rlowe]

Having resolved the previous problem (thank you very much, everyone) by removing some entries from listener.ora, I am now encountering an ORA-12541: TNS:no listener error. I can connect on the local machine using username/pass@orcl, but cannot connect from other machines using username/pass@jupiter.

I believe the problem stems from tnsnames.ora not being in sync. Below are the files:

HOST:

ORCL.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT=1520))
)
(CONNECT_DATA = (SID = ORCL)
)
)


**** CLIENT ****

JUPITER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1520))
(CONNECT_DATA=(SERVICE_NAME=ORCL))
)

I am trying to connect to the host (from client) using: sqlplus username/pass@jupiter, but cannot resolve host..... any suggestions??

R

[Edited by sambavan on 09-13-2001 at 02:35 PM]

[sambavan]

I have edited your posting by removing the IP address. In the future, please be aware that you do not want to post your IP and expose your system.

Make sure that your listener had been started. If you make any chage after you start, reload it again. Then try changing the service name on client to SID. i.e

(SID = ORCL)

That should fix the problem

Sam

[rlowe]

Thank you for changing IPs

I have tried the configuration with both as
SERVICE_NAME=ORCL
and both as
SID=ORCL

I have even tried with both entered in each file...

R

[sambavan]

Looks like you have defined the port 1521 in the listener and trying to use the port 1520. Make sure the port you specified on the listener is the same as the port you are using on the tnsnames.ora file. In the mean time I also would like to take a look into the sqlnet.ora file from your client machine.

Sam