java7man
asked on
DBA Studio won't parse tnsnames file
I have been using a local oracle instance for many weeks, via sqlplus.
I tried to start up DBA Studio , select DBA Stand Alone
and get this error :
Failed to parse tnsnames.ora file
Error 100: -- NLNV-NLNV String Format Error
Since I can use sqlplus, I know my tnsnames.ora file is okay. Any thoughts ?
I have other installations that work okay, tnsnames files
look the same(syntactically)
I tried to start up DBA Studio , select DBA Stand Alone
and get this error :
Failed to parse tnsnames.ora file
Error 100: -- NLNV-NLNV String Format Error
Since I can use sqlplus, I know my tnsnames.ora file is okay. Any thoughts ?
I have other installations that work okay, tnsnames files
look the same(syntactically)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The joys of tnsnames and listener files with hidden control characters. It looks like a duck quacks like a duck even flies like a duck but when the lines added are deleted and re-entered it works. This is a fairly common problem that most dba's will hit sooner or later. It happens in unix as well even when using terminal emulators usually cat and grep the file can reveal characters and there is a command in vi that I just cannot remember that will reveal hidden items. This happened three times in one week to 3 different people whilst configuring development databases 2 weeks ago.
Hi,
To add databases to your dba Studio, you must change the entries in your tnsnames.ora from SID to SERVICE_NAME. Relaunched DBA Studio will find all tnsnames entries then. Before connecting to your databases, change back your entries from SERVICE_NAME to SID. Then you can connect to your databases.
An easier way is to edit the file C:\oracle\ora81\sysman\dba
DB1.WORLD=//NORMAL
DB2.WORLD=//NORMAL
After starting DBA Studio, you will find in your DB Selection list the entries DB1 and DB2.
To add databases to your dba Studio, you must change the entries in your tnsnames.ora from SID to SERVICE_NAME. Relaunched DBA Studio will find all tnsnames entries then. Before connecting to your databases, change back your entries from SERVICE_NAME to SID. Then you can connect to your databases.
An easier way is to edit the file C:\oracle\ora81\sysman\dba
DB1.WORLD=//NORMAL
DB2.WORLD=//NORMAL
After starting DBA Studio, you will find in your DB Selection list the entries DB1 and DB2.
ASKER
checked each line length in file,
size of file, etc. all were the same.
Basically, made a copy of file, removed original file,
re-created file, via a real editor (vi), and both DBA studio and various instance names now work/connect, etc.
Another weird behavior when moving files from UNIX to
win2K/NT.