Link to home
Start Free TrialLog in
Avatar of kapil12
kapil12Flag for India

asked on

Not able to start/stop listener having client and database on same machine (AIX 6.1)

Hi,

I have database oracle11gR2 11.2.0.1 installed on my machine AIX 6.1 64 bit at location - /home/oracle/app/oracle/product/11.2.0/dbhome_1 and I installed Oracle 11gR2 client 32 bit on the same machine - /home/oracle/app/oracle/product/11.2.0/client_1. Then I export

    enter code here
    ORACLE_HOME= /home/oracle/app/oracle/product/11.2.0/client_1
    ORACLE_SID =orcl
    LIBPATH=$LIBPATH:$ORACLE_HOME/lib and
    PATH =$PATH:$ORACLE_HOME/bin

I also copied the TNSNAMES.ORA from dbhome_1/network/admin to client_1/network/admin

From db_home/bin - Am trying to start and stop the listener it is saying -
    bash-3.2# ./lsnrctl

    LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production on 12-JUN-2013    
    01:55:12


Welcome to LSNRCTL, type "help" for information.

    LSNRCTL> status
    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    IBM/AIX RISC System/6000 Error: 79: Connection refused

I also checked -    bash-3.2# ps -ef | grep lsnr
    oracle 12845248 1 0 11:18:12 - 0:10     /home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr LISTENER -inherit
root 15466574 11272326 0 02:06:54 pts/0 0:00 grep lsnr

I need to connect sqlplus / as sysdba which is complaining bash-3.2$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jun 13 01:05:07 2013

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

    ERROR:
    ORA-12545: Connect failed because target host or object does not exist

My listener.ora file -

# listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
          (ADDRESS = (PROTOCOL = TCP)(HOST =lodibm17.ca.com)(PORT = 1521))
        )
      )

    ADR_BASE_LISTENER = /home/oracle/app/oracle


My tnsnames.ora file  -

# tnsnames.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

    LISTENER_ORCL =
      (ADDRESS = (PROTOCOL = TCP)(HOST =lodibm17.ca.com)(PORT = 1521))


    ORCL =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST =lodibm17.ca.com)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME =orcl.ca.com)
        )
      )

SQlnet.ora
# sqlnet.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

    NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

    ADR_BASE = /home/oracle/app/oracle

I also noticed -

tnsping orcl.ca.com

TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production on 13-JUN-2013 01:10:24

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

Used parameter files:
    /home/oracle/app/oracle/product/11.2.0/client_1/network/admin/sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=10.131.91.157)(PORT=1521)))
OK (530 msec)

have one question - the host which tnsping is pinging Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=10.131.91.157)(PORT=1521))), it should be same in tnsnames.ora or listener.ora ?

From which file tnsping is picking up the HOST=10.131.91.157 because in tnsnames.ora/listener.ora the hostname is lodibm17.ca.com (141.202.119.143) is different as it is shown below in /etc/hosts file..

ere is my content of /etc/hosts file on AIX -

127.0.0.1       loopback localhost      # loopback (lo0) name/address
141.202.119.143      lodibm17.ca.com lodibm17

Please help me to resolve the issue
SOLUTION
Avatar of johnsone
johnsone
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kapil12

ASKER

Yes able to Resolve the by setting ORACLE HOME to dbhome_1 and can able to start and stop the listener and able login sys as sysdba.

But it can't be possible with client ? From client am able to login with system/firewall@orcl. So can we start and stop listener from client ?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kapil12

ASKER

Thanks for the Info. Am successfully able to run from database.
downtime for a listener ?
never tried reload ?

edit the listener.ora
then from command prompt:

> lsnrctl
lsnrctl> reload
lsnrctl> status

done