Problem solve Get help with specific problems with your technologies, process and projects.

Error when trying to add a database

I have installed Oracle8i with DBA studio. The problem is that whenever I try to add the database tree to hierarchy it gives an error of something like "nlvln error 100 unable to parse tnsnames.ora". It is creating a lot of problems for us as no one can access this database from client. What should I do?

I haven't seen that particular error before and couldn't locate anything about it on Metalink. But, if the problem is that it is giving this error when you try to add a database from tnsnames.ora, why not try doing it manually instead and see if that will work? Here's what to do:

Add a database manually
You can add databases to the DBA Studio navigator tree by manually filling in the following fields:
SID: the database system identifier, usually the instance name, such as ORCL
Hostname: the machine or node name where the database is located
Port Number: the database listener port address, usually 1521 or 1526
Net Service Name: A name which uniquely identifies a database when connecting to a machine. It is usually the global database name. For example: ORCL.world.

Note: Adding a database manually automatically updates the local tnsnames.ora file located in your /network/admin directory.

Note: Currently only TCP/IP service names can be manually entered.

Dig Deeper on Oracle error messages

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.