kapil12
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/pr oduct/11.2 .0/dbhome_ 1 and I installed Oracle 11gR2 client 32 bit on the same machine - /home/oracle/app/oracle/pr oduct/11.2 .0/client_ 1. Then I export
enter code here
ORACLE_HOME= /home/oracle/app/oracle/pr oduct/11.2 .0/client_ 1
ORACLE_SID =orcl
LIBPATH=$LIBPATH:$ORACLE_H OME/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)(HO ST=)(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/pr oduct/11.2 .0/dbhome_ 1/bin/tnsl snr 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/pr oduct/11.2 .0/dbhome_ 1/network/ admin/list ener.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/pr oduct/11.2 .0/dbhome_ 1/network/ admin/tnsn ames.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/pr oduct/11.2 .0/dbhome_ 1/network/ admin/sqln et.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/pr oduct/11.2 .0/client_ 1/network/ admin/sqln et.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA =(SERVICE_ NAME=))(AD DRESS=(PRO TOCOL=TCP) (HOST=10.1 31.91.157) (PORT=1521 )))
OK (530 msec)
have one question - the host which tnsping is pinging Attempting to contact (DESCRIPTION=(CONNECT_DATA =(SERVICE_ NAME=))(AD DRESS=(PRO TOCOL=TCP) (HOST=10.1 31.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
I have database oracle11gR2 11.2.0.1 installed on my machine AIX 6.1 64 bit at location - /home/oracle/app/oracle/pr
enter code here
ORACLE_HOME= /home/oracle/app/oracle/pr
ORACLE_SID =orcl
LIBPATH=$LIBPATH:$ORACLE_H
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)(HO
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/pr
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/pr
# 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/pr
# 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/pr
# 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/pr
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA
OK (530 msec)
have one question - the host which tnsping is pinging Attempting to contact (DESCRIPTION=(CONNECT_DATA
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
never tried reload ?
edit the listener.ora
then from command prompt:
> lsnrctl
lsnrctl> reload
lsnrctl> status
done
ASKER
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 ?