Message 3511 not found; No message file for product=network, facility=TNSTNS-03505: Message 3505 not found; No message file for product=network, facility=TNS

February 14, 2014

You may hit TNSTNS-03505 Message 3511 error message while you are trying to use tnsping command.Complete error message is:

Message 3511 not found; No message file for product=network, facility=TNSTNS-03505: Message 3505 not found; No message file for product=network, facility=TNS

You may hit this error while on database machine or machine which only has client installataion.

I have been face this problem on machine which has 11g client. Also the user is not installation user,so  We have been created one other user and give that user to development team.

My installation user is oracle, development user is oracle1… Both user group are same(dba)

Even I can use tnsping with oracle user i can get response, but wiht oracle 1 I am hitting below error

With Oracle user:
[oracle@client_machine]</oracle11g/app/oracle/product/11.2.0/client_1/bin>tnsping DB_NAME

TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.4.0 – Production on 14-FEB-2014 11:08:13

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

Used parameter files:
/oracle11g/app/oracle/product/11.2.0/client_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1525)) (ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1525)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = xxx)))
OK (0 msec)

With Oracle1 user:
[oracle1@client_machine]</oracle11g/app/oracle/product/11.2.0/client_1/bin> tnsping DB_NAME

TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.4.0 – Production on 14-FEB-2014 11:05:05

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

Message 3511 not found; No message file for product=network, facility=TNSTNS-03505: Message 3505 not found; No message file for product=network, facility=TNS

So issue has been solved by below steps:

At oracle1 user I have been set below parameter to .profile

export ORACLE_BASE=/oracle11g/app/oracle
export ORACLE_HOME=/oracle11g/app/oracle/product/11.2.0/client_1
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH

[oracle1@client_machine]</oracle11g/app/oracle/product/11.2.0/client_1/bin> tnsping DB_NAME
TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.4.0 – Production on 14-FEB-2014 11:08:13

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

Used parameter files:
/oracle11g/app/oracle/product/11.2.0/client_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1525)) (ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1525)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = xxx)))
OK (0 msec)

If you are on db server than you also need to set ORACLE_SID.


Oracle E-Business Suite Release 12.2.2 Media Pack v1 for Linux x86-64-bit avaliable NOW!

September 19, 2013

Hi Friends;

Finally Oracle E-Business Suite Release 12.2.2 Media Pack is available at e-delivery site.

For a now it has been published for linux x86-64.

Setup size almost 83G

Here is the some notes:

Read the rest of this entry »


LsInventorySession failed: OracleHomeInventory::load() gets null oracleHomeInfo

September 17, 2013

I faced with that error message while I was trying to apply 10.2.0.4 patch on AIX 6.1

Here is the my steps:

1. Error  Message:

[oracle@test]</u01/app/oracle/product/10.2.0/OPatch>opatch lsinventory

Invoking OPatch 10.2.0.3.0

Oracle interim Patch Installer version 10.2.0.3.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..
Oracle Home : /u01/app/oracle/product/10.2.0
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.3.0
OUI version : 10.2.0.3.0
OUI location : /u01/app/oracle/product/10.2.0/oui
Log file location : /u01/app/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2013-09-17_10-42-49AM.log

List of Homes on this system:

Inventory load failed… OPatch cannot load inventory for the given Oracle Home.
Possible causes are:
Oracle Home dir. path does not exist in Central Inventory
Oracle Home is a symbolic link
Oracle Home inventory is corrupted
LsInventorySession failed: OracleHomeInventory::load() gets null oracleHomeInfo

OPatch failed with error code 73

Read the rest of this entry »


ex: 0602-101 Out of memory saving lines for undo.

August 15, 2013

While you are trying to open alert_SID.log file with vi editor you may hit ex: 0602-101 Out of memory saving lines for undo  error message,

# cd /u01/app/oracle/admin/DB_NAME/bdump

# vi alert_SID.log

ex: 0602-101 Out of memory saving lines for undo.

So you can use below syntax to can open your alert.log :

export EXINIT=”set ll=80000000″

Reference:
Hints and tips when using vi on AIX

 


ksh: /usr/bin/rm: arg list too long

August 15, 2013

While you are deleting some xxx.trc -c-dump files or some other files which fill up your disk you may hit ksh: /usr/bin/rm: arg list too long error message,

# cd /u01/app/oracle/admin/DB_NAME/bdump

# rm -rf *.trc

ksh: /usr/bin/rm: arg list too long

So you can use below syntax to can delete those files:

# find . -name “DIR_PATH/*.trc” -type f -exec rm -f {} \;

or:

# find DIR_PATH -name “*.trc” -type f -exec rm -f {} \;

PS: In our case DIR_PATH=/u01/app/oracle/admin/DB_NAME/bdump


ORA-15018-ORA-15030 How to recreate ASM Diskgroup Oracle 10g&11g

August 13, 2013

Sometimes  as DBAs may need to recreate ASM Diskgroup on their environments. I face with one issue on our disaster test. Our ORADATA diskgroup sync with Disaster center but ORAFRA diskgroup do not copy to disaster center.
Normally If you have disk on disaster center(In our case diskgroup is ORAFRA) you can select a different name for the diskgroup or drop diskgroup and recreate the raw devices.Recreate the raw devices is required in order to remove completely the ASM metadata.

In my case, Storage team give me one new raw device at disaster center and I need to recreate ORAFRA at disaster center.

You can follow below steps to recreate ASM Diskgroup for 10g&11g.

Steps are different for 10g&11g.So Here is the steps for 11g:

Read the rest of this entry »


Book Review… One good book advice

July 23, 2013

As you know one of the high availability solution is Data Guard. My dear friends Emre Baransel and Nassyam Basha have been published one new book about Data Guard product.

Before start, let me remind you some information about Oracle Data Guard:

Oracle Data Guard provides the management, monitoring, and automation software to create and maintain one or more standby databases to protect Oracle data from failures, disasters, human error, and data corruptions while providing high availability for mission critical applications. Data Guard is included with Oracle Database Enterprise Edition.

Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions

Oracle Data Guard can be deployed to maintain standby databases at a secondary site. These standby databases are maintained as synchronized copies of the production database.

If the production database becomes unavailable because of a planned or an unplanned outage, Data Guard can switch the standby database to the production role, thus minimizing the downtime associated with the outage, and preventing any data loss.

Those lines are from Oracle® Data Guard Concepts and Administration guide. You can find more details at that guide.

Read the rest of this entry »


Follow

Get every new post delivered to your Inbox.