Oracle Database - No message file

Asked By Nancy Ziese on 10-Aug-10 09:09 PM
I have OracleClient 10g isntalled on a computer running Windows XP Pro SP2.  I used to be able to access tables in the an oracle db.  Now when i attempt I get errors.  I ran tnsping and got the following

Message 3511 not found; No message file for product=NETWORK, facility=TNSTNS-035
05: Message 3505 not found; No message file for product=NETWORK, facility=TNS

ORACLE_HOME is set as well as Path in my environmental variables.  tnsnames.ora is also correct.  Any clues?
Super Man replied to Nancy Ziese on 10-Aug-10 11:12 PM

message usually means one of the following conditions has occurred:

1) The ORACLE_HOME is not set correctly

- this often happens with scripts that are run using cron, at, the Oracle scheduler, or during system startup. We often set the ORACLE_HOME in the /etc/profile ... but that is not invoked by cron, etc. So we need to set the environment variables manually in our scripts.

2) The language setting is incorrect, or indicates a message language that is not loaded

3) The mesg directory or files have become corrupt

Goniey N replied to Nancy Ziese on 10-Aug-10 11:29 PM
//Try This :

Used parameter files:
D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dscp328
2.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_
NAME = google)))
OK (20 msec)

Also Check Your Environment Path :

"C:\oracle\product\10.2.0\db\bin"





For More Details : Click Here

Nancy Ziese replied to Super Man on 11-Aug-10 11:28 AM
msg files were corrupt.  thanks