Thursday, August 9, 2012

TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused

While starting listener I got the following error
 lsnrctl start VIS

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 09-AUG-2012 16:16:03

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

Starting /apps/oracle/VIS/db/tech_st/11.1.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.1.0.7.0 - Production
System parameter file is /apps/oracle/VIS/db/tech_st/11.1.0/network/admin/VIS_starworld/listener.ora
Log messages written to /apps/oracle/VIS/db/tech_st/11.1.0/log/diag/tnslsnr/starworld/vis/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=starworld.appstek.ca)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=starworld.appstek.ca)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused


After investigating I noticed that the /etc/hosts had a different ip assigned for the server
cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.1.66    starworld.appstek.ca starworld

ifconfig -a
lo        Link encap:Local Loopback 
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:16 errors:0 dropped:0 overruns:0 frame:0
          TX packets:16 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:960 (960.0 b)  TX bytes:960 (960.0 b)

pan0      Link encap:Ethernet  HWaddr FA:0F:D0:E4:A5:B3 
          BROADCAST MULTICAST  MTU:1500  Metric:1
          RX packets:0 errors:0 dropped:0 overruns:0 frame:0
          TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:0 (0.0 b)  TX bytes:0 (0.0 b)

wlan0     Link encap:Ethernet  HWaddr 8C:A9:82:AD:17:9A 
          inet addr:192.168.1.80  Bcast:192.168.1.255  Mask:255.255.255.0
          inet6 addr: fe80::8ea9:82ff:fead:179a/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:12798 errors:0 dropped:0 overruns:0 frame:0
          TX packets:7146 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:11929017 (11.3 MiB)  TX bytes:1324436 (1.2 MiB)

I changed the ip to point to the correct ip address.
[root@starworld Desktop]# vi /etc/hosts
[root@starworld Desktop]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.1.80    starworld.appstek.ca starworld


 and then started the listener again and Voila it worked.
 lsnrctl start VIS

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 09-AUG-2012 16:18:34

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

Starting /apps/oracle/VIS/db/tech_st/11.1.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.1.0.7.0 - Production
System parameter file is /apps/oracle/VIS/db/tech_st/11.1.0/network/admin/VIS_starworld/listener.ora
Log messages written to /apps/oracle/VIS/db/tech_st/11.1.0/log/diag/tnslsnr/starworld/vis/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=starworld.appstek.ca)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=starworld.appstek.ca)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     VIS
Version                   TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date                09-AUG-2012 16:18:34
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /apps/oracle/VIS/db/tech_st/11.1.0/network/admin/VIS_starworld/listener.ora
Listener Log File         /apps/oracle/VIS/db/tech_st/11.1.0/log/diag/tnslsnr/starworld/vis/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=starworld.appstek.ca)(PORT=1521)))
Services Summary...
Service "VIS" has 1 instance(s).
  Instance "VIS", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oravis@starworld VIS_starworld]$

Thursday, May 3, 2012

After installing OSB 11.1.1.4 in the same domain as SOA I got the following error.



A quick google search gave the following site with the solution.


Change the config.xml in the directory DOMAIN_HOME/config as follows:



wlsbjmsrpDataSource AdminServer,osb_server1 jdbc/wlsbjmsrpDataSource-jdbc.xml




 



this needs to be changed to the following


 
 
 
 
    wlsbjmsrpDataSource
   
    jdbc/wlsbjmsrpDataSource-jdbc.xml
 



After this the AdminServer and osb_server1 Managed Server started successfully.

Again all credit to

A blog without a catchy title — by Peter Lorenzen

Wednesday, April 11, 2012

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/11/2012 14:33:07
RMAN-03015: error occurred in stored script Memory Script
RMAN-04014: startup failed: ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925

for this i had to create the audit_file_dest directory with the directory structure of the primary on the standby side.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/11/2012 14:31:49
RMAN-05541: no archived logs found in target database

For this I had to do a logswitch on the primary.

SQL> alter system switch logfile;

System altered.

Errors encountered during Creating a Physical Standby using Duplicate from Active Database RMAN command

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/11/2012 14:19:42
RMAN-05557: Target instance not started with server parameter file


I needed to restart the target database using spfile as I was using pfile.