ORACLE error 12541 encountered

tnsnames.ora:

# tnsnames.ora Network Configuration File: /oracle/u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = myfullyqualified.domainname.com)(PORT = 1522))


ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = myfullyqualified.domainname.com)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

listener.ora:

# listener.ora Network Configuration File: /oracle/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /oracle/u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
      (ADDRESS = (PROTOCOL = TCP)(HOST =  myfullyqualified.domainname.com)(PORT = 1522))
    )
  )

This is what happens when I try to import the .dmp file:
imp username/username@myfullyqualified.domainname.com file=dumpfile.dmp ignore=Y log=test.log fromuser=username touser=username

Import: Release 10.2.0.1.0 - Production on Thu Jun 4 11:15:08 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


IMP-00058: ORACLE error 12541 encountered
ORA-12541: TNS:no listener
IMP-00000: Import terminated unsuccessfully

Your instance possibly is not registered by the Listener.
Possibly the Listener is not running and you connect using the IPC channels of the computer.

To run the listener:

%  lsnrctl status
% lsnrctl start

To Register the instance by the DB:

Backup LISTENER.ORA file!!!!!!!

In ...\network\admin open listener.ora

see

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\Ora10g)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
  )

Add the entry
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
with regard to the particular Oracle Home and SID Name.

Restart the listener:
c:>lsnrctl stop
c:>lsnctl start

Specifying 'orcl' in the imp command allows me to import the .dmp file, but why is localhost.localdomain still showing up as the listener and host?  Is there another configuration file somewhere that requires a FQDN?  The listener is definitely running.

lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 04-JUN-2009 11:24:24

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                04-JUN-2009 10:58:55
Uptime                    0 days 0 hr. 25 min. 28 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /oracle/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /oracle/u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC2)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1522)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 2 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
  Instance "orcl", status READY, has 2 handler(s) for this service...
The command completed successfully

My posting is not relevant given your explanation.
But:

1. Possibly there is a firewall or antivirus between client and server

2. Check if you can see (ping) the host and if the Listeners listens on port 1522 (tnsping alias)

Have you another Oracle homes and Oracle installations on your server computer or client computer.
Where you initiate the import -on the Oracle server machine or on remote client?

Ran the tnsping command on the server itself.

tnsping myfullyqualified.domainname.com

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 04-JUN-2009 11:29:29

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:
/oracle/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=myfullyqualified.domainname.com))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
TNS-12541: TNS:no listener

@schwertner: I'm initiating the import on the remote server directly, there are no firewall or antivirus problems on the other machines.  There isn't a client/server relationship, I'm directly ssh'd into the Oracle server.

In SQLNET.ORA put TNSNAMES AT FIRST PLACE:

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

You do ssh and possibly this has limitations.
Try to make normal client server connection
checking the visibility of the server and the existence of
Listener.
Make it simple.

tnsping, is just hitting the host to see if the listener is running.  It does not connect to a database.  You need to specify a database name.

Since you are on the same host as the database, then mrjoltcola's suggestion of just setting ORACLE_SID is even better than trying to go through TNS.

@schwertner:
 cat sqlnet.ora
# sqlnet.ora Network Configuration File: /oracle/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

TNSNAMES is in the first place, is this what you meant?

@johnsone:
Although that does allow me to do an import, it still doesn't fix the problem of the host and listener showing up as localhost.localdomain in enterprise management.  I would like to resolve this as well so that my environment is properly configured.

fulcrumit, I think you missed johsone's post or point. I think he pointed out your problem.

You are using the fully qualified domain name in a tnsping and import command. You should not do that, instead, use the TNS alias, or dont use one at all, use ORACLE_SID.

Oops never mind, looks like I did not refresh my browser before posting.

Objection to close: We solved one of the asker's questions as he stated in http:#24549853

Since it was a compound question, it is really not fair to close / refund the question when one question was solved, even if another was not. (The reason against compound questions in the first place)

mrjoltcola


 

1st question was solved by:

http:#24549663
http:#24549788

2nd question schwertner has made good effort to help asker with, however, no response from asker since 6/4. This is why compound questions are not good.

mrjoltcola
Zone Advisor