Oracle DBA Studio Error - Failed to parse tnsnames.ora file

When i tried to Connect using Oracle DBA Studio, it gives the following error."Failed to parse tnsnames.ora fileError : 100 --NLNV-NLNV String Format Error".When i copied some part of text and created new tnsnames.ora file, its working.But the existing tnsnames.ora file is not working with DBA studi ...

oracle database - tnsnames.ora file

i wish to know that , for a case i was connecting to a database in the system, and i found an error stating that could not resolve the name on tnsnames.ora file. and when i chacked that file, the database existed on the file. Can u kindly tell me why did that erroe message came and how can i solve t ...

Oracle How to recover TNSNAMES.ORA file

Hi, im using Oracle 8i 8.16 database running on win2k server. Im getting a an error whenever i try to connect to the databese using the DBA Studio program - the error was "ORA-12154:TNS:Could Not resolve service name". I noticed that the TNSNAMES.ORA file is blank in the home directory of Oracle8i, ...

how to point oracle to correct tnsnames.ora file?

What do I need to set so that sqlPlus, sqlNavigator etc knows where to find the tnsnames.ora file?Do I need an environment variable? ...

Oracle Should dbassist create an entry in my tnsnames.ora file?

I just created an instance on Solaris with dbassist and the sample minimal.rsp response file (8.1.7). I was surprised to note that no entry was created in the tnsnames.ora file as I would expect (it does create an entry on Windows platforms). Is this typical behavior? I did not see any option in the ...

Oracle Please help with tnsnames.ora file ora-12203

I am trying to configure the Oracle 8i Personal edition on Windows 98.I successfully installed developer and Oracle8i (in 2 separate homes)My tnsnames.ora file has defaulted tns and I added one:po8.world =(DESCRIPTION=(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TPC)(Host = localhost)(Port = 1521)))(CONNEC ...

Oracle Please help with tnsnames.ora file ora-12203

I am trying to configure the Oracle 8i Personal edition on Windows 98.I successfully installed developer and Oracle8i (in 2 separate homes)My tnsnames.ora file has defaulted tns and I added one:po8.world =(DESCRIPTION=(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TPC)(Host = localhost)(Port = 1521)))(CONNEC ...

Oracle Please help with tnsnames.ora file ora-12203

I am trying to configure the Oracle 8i Personal edition on Windows 98.I successfully installed developer and Oracle8i (in 2 separate homes)My tnsnames.ora file has defaulted tns and I added one:po8.world =(DESCRIPTION=(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TPC)(Host = localhost)(Port = 1521)))(CONNEC ...

Oracle tnsnames.ora file could not be found in the network/admin!!!

When I try to install Documentum e-Content Server 4.1 I get....Cannot determine Database Connection aliases defined on your machine. Error returned:"The tnsnames.ora file could not be found in the network/admin or net80/admin directory"any ideas on what the issue may be. oh and tnsnames.ora is in th ...

Oracle Create a list of the DB's available from the tnsnames.ora file.

i would like to know if there is a code available to Create a list of the DB's available from the tnsnames.ora file..... ...

Oracle Create a list of the DB's available from the tnsnames.ora file

i would like to know if there is a code available to Create a list of the DB's available from the tnsnames.ora file..... ...

Oracle DBA studio: Error add/connect database "Failed to parse tnsnames.ora file"

I have Oracle (version 8.1.7) installed in my XP machine and when I try to (having chosen "Launch DBA Studio standalone") to open a connection I get:"Failed to parse tnsnames.ora fileERROR: 100 -- NLNV-NLNV String Format Error".Also got this when I tried to manually add a database to a tree.I can ac ...

Getting Oracle SID from TNSNAMES.ora file

I am writing a visual basic application that pulls information from an Oracle database. I would like to be able to pull the names of the different Oracle SIDs from the TNSNAMES.ora file so that the user can choose which database to log into. Is there an easy way to do this? Is this data stored in th ...

Oracle failed to parse tnsnames.ora file

I opened Oracle Enterprise Manager Console, and when I right-click on Databases to add a new database, I get an error -- Failed to parse tnsnames.ora fileoracle.net.config.ServiceAliasException : 10I am just not able to do anything with the Enterprise Manager Console except just starting the tool.Wh ...

Oracle client PCs have a common shared tnsnames.ora file

In Windows, can I create a situation where all my client PCs have a common shared tnsnames.ora file (which resides on a seperate box on the network)? I want to do this without mapping the drive externally. ...

Oracle Can't srvctl command write tnsnames.ora file?

I use srvctl to create a new service correctly, but I find the information of this service isn't written into tnsnames.ora file, it means, user can't connect database by directly using this service name, it's very stranger, who can tell me how to use srvctl to create a service and ensuer the informa ...

Oracle location of tnsnames.ora file

i am using Solaris box and have oracle client installed..in this box i can find many copies of tnsnames.ora files eg. in ORACLE_HOME/network/admin, /opt/vqr/tnsnames/, /var/opt/oracle etc... so i want to know which file will be used by oracle...Also is there any environment variable that will show t ...

Oracle How to use ODBC SQLDriverConnect() without using tnsnames.ora file

I have an ODBC application that connects to an Oracle 10g database. Currently, my SQLDriverConnect() function call uses the following connection string:DRIVER={Oracle in OraClient10g_home1}; DBQ=MyDB.world; DBA=W; UID=foo; PWD=barThis requires an entry in the tnsnames.ora file that looks like this:M ...

Oracle PRESENTATION = RO in tnsnames.ora file

I tried searching Oracle documentation for PRESENTATION = RO sub-parameter in CONNECT_DATA parameter in tnsnames.ora file. I think it is an undocumented parameter.Can somebody please help me out... ...

Oracle listener.ora and tnsnames.ora file

OS: UnixDB: 10.2How to create listener.ora and tnsnames.ora file on the database server?Database is installed and running from the server. no problem.I have a problem to connect to the database through client.I do not find any listener.ora and tnsnames.ora file on Database server under$ORACLE_HOME/n ...

Oracle Using a TNSNAMES.ORA file from a network drive

My XE database currently uses the TNSNAMES.ORA file on my PC.Is it possible to use a TNSNAMES.ORA from a shared network drive instead? ...

Oracle DBUA editing tnsnames.ora file

SR 7030507.994http://qmon.oraclecorp.com/qmon3/quickpicks.pl?t=t&q=7030507.994Hi all,Customer has set local_listener = '(ADDRESS = (PROTO =TCP)(HOST=themis)(PORT=1532))' . Then he used DBUA to upgrade from 10.2.0.3 to 10.2.0.4. Post upgrade, he noticed that DBUA has edited the tnsnames.ora file. ...

Oracle TNSNAMES.ORA file is not available on 10g xe client pc

I installed oracle 10g xe client on my pc but TNSNAMES.ORA file is not showing in my intalled loacationDharmendra ...

Oracle How to deactivate an entry in tnsnames.ora file

I am working with Oracle 10g enterprise edition. I have a data source named with DEVDATA which should not be affected while I am working on my project. Usually, I will add DEVDATA entry in tnsname.ora file if I want to use it and I will remove that entry from tnsnames.ora file in order to protect th ...

Oracle client not using correct tnsnames.ora file

all, i have installed oracle 10g client on my machine...but here is the thing....i have multiple tnsnames.ora file on my machine (which i cannot delete or play around with)...and because of that oracle is not able to connect to the database i want to it to connect it to....i cannot tnsping to the da ...

Oracle Tnsnames.ora file unable to edit in my Laptop

I have installed Oracle 10g on my personal laptop.It worked fine on the day I installed.Now I get tnsconnect timeout occured.I searched the tnsnames.ora file and could not modify the file. # tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora # Generated ...

Oracle Overwritten my TNSNAMES.ORA file

I've got ORACLE XE on my VISTA laptop. I accidentally overwritten my TNSNAMES.ORA file, and now my XE entry is no longer in the TNSNAMES. My XE database is on my laptop. Is there an easy way to create (add) the XE to my TNSNAMES. If so, what information do I put in there? ...

Oracle Location of tnsnames.ora file in 11gR2

Recently i have installed database db1 in 11gR2 using DBCA Now i need to know where the tnsnames.ora file location And i have checked the following location ORACLE_HOME/network/admin/Only the sample tnsnames.ora file is available But I need to know where the db1 tnsnames.ora file is located ...

Oracle tnsnames.ora file location in WIndows 7

I just installed Oracle XE 10g on my PC running windows 7. I was told that the tnsnames.ora file was located in C:\XEClient\Network\Admin, however i see no such folder in my XE CLient folder. Any Ideas? ...

Oracle BUG? tnsnames.ora file location

Timesten client ignore tnsname.ora file location specified in ttendaemon.options file.I have -tns_admin /etc/TimesTen string in ttendaemon.options file and tnsnames.ora in /etc/TimesTen directory. When I connect using ttIsql and execute passthrough query - all ok. Later I try to execute same query i ...

Oracle How can you "share" 1 common TNSNAMES.ORA file amngst many clients?

We're installing into a large enterprise, and have the rqmt of installing 8.1.7 client locally, yet sharing a common network copy of TNSNAMES.ORA. Has anyone ever done this? Better yet, the question might ought to be what is the proper approach here? Local client is necessary for compatibility reaso ...

Oracle 9i tnsping gives me nothing despite a working tnsnames.ora file

I can't connect to a data base, even using tnsping with a tnanames.ora file that I copied from a user's PC that was able to connect. It's a new install of 9i on my PC. What did I miss? ...

Oracle Question about tnsnames.ora file

I need to be able to access our production database (on a network server) and Oracle Express on my local computer.Is this possible using just one tnsnames file? If so, is there an example somewhere?If it isn't, what do I need to do? ...

Oracle Need HELP with TNSNAMES.ORA file

I accidentally crushed my TNSNAMES files with a NEW one. This wiped out my XE settings... The XE database was my local database on my LAPTOP !I want to rebuild the XE entry in the TNSNAME file but I don't know what to put in there.Can anybody help me? ...

Oracle TOAD/OID and TNSNAMES.ORA

We had OID installed on a trial basis here to replace tnsnames.ora files on servers, laptops and desktops. We have since uninstalled and removed all files and registry entries of the application from the server where it was installed. I had my laptop set up to use OID and I removed my TNSNAMES.ORA f ...

Toad with Oracle Instant Client 10.2.0.1.0(not able to locate tnsnames.ora

I have both Oracle Client 9.2 and Instant Client 10.2.0.1.0 on my laptop. How to make Toad 8.5.1 locate tnsnames.ora file for instant client.When I open Toad, and selects "Instant Client 10.2.0.1.0" as installed client, it shows the error message "tnsnames.ora not found!"Below is the setting:Instant ...

multiple tnsnames.ora

A client has SQL Plus, Toad & D2K intalled. I have added new db service in tnsnames.ora & I can connect to db through sql plus but while connecting through Toad I get tnsname protocol error. This might be because since multiple tnsnames.ora file is created, the file used is not the one in wh ...

tnsnames.ora

when i am trying to connect to a database using TOAD i get this messageORA-12154: TNS:could not resolve service name.under which directory should i go and update the TNSNames.ora fileto avoid getting this error--------------------------------------------------------------------------------This is wh ...

Oracle Instant client and tnsnames.ora

This "probably" isn't a instant client answer, BUTI have installed instant client (winxp) and I can connect to my databases, BUT many of the apps (i.e. quest SQL nav/toad) do a drop down list of available databases in the tnsnames.ora file, I assume by some call to oci.dll ... these drop down lists ...

Oracle Problems with tnsnames.ora

Recently my system administrator dropped my computer from the network, changed its name and then re-attached it. I log into the network, so because my account was acting strange he deleted my old account on the network and created a new one with my same user login and password. I'm not sure why but ...

Oracle Editing tnsnames.ora

I am new to this can anyone help me configure tnsnames.ora file for connecting it with Toad.I have Oracle 10g. I have never done this before. ...

Oracle connection hangs when using tnsnames.ora alias

Situation: Oracle 9i 9.2.0.1 on Windows XP SP2When installing Oracle 9i, I used as much default settings as possible (also following a few tutorials). Getting it installed was an accomplishment in itself, with restarting the listener process while the default database was being created. Right now I ...

Oracle something wrong with tnsnames.ora

i'm using XE 10g for more than 1 year. There wasnt any problem on Win Xp. I could connect without any troubles to XE via TOAD. I've got new laptop with Win 7 Home Premium. Installed XE 10g, and can use through IE and sqlplus CLI. But cant connect via TOAD. I set up setting on TOAD and clicked connec ...

Oracle cannot find tnsnames.ora error message

We are using oracle 10.2.0.1 via Toad. I get a cannot find tnsnames.ora file error message and see only a tnsnames.ora file in the sample file under the c:\ORACLE\product\10.2.0.1\NETWORK\ADMIN\ directory.Do I need to create this file, and if so how do I do this?Thanks in advance for your help ...

Oracle 9iDS-tnsnames.ora

Happy Holidays!I am receiving the following error:1) Oracle forms builder-data block wizardORA:12154: TNS:could not resolve service namePlease clarify....Which Oracle file do I place my Professors tnsnames.ora file so that I may create a data block? ...

Oracle TnsNames.ora

Got a PC with several applications that install some sort of client to connect to a remote database. Did a search on the PC and found 14 different TnsNames.ora files. Some were just samples. How can you tell what application is using what tnsNames.ora file? ...

DNS vs. Oracle Name Service vs. tnsnames.ora

Can anyone shed some light on this?I heard that Oracle is going toward a DNS solution and going away fromtnsnames.ora and the Oracle Naming Service. Is this true?We are looking to place a naming solution in our environment and I want toknow which direction to head in. Also, if possible, I would like ...

TNS Names from tnsnames.ora

Is there a programmatic way to get hold of the DB entries in the tnsnames.ora file ? I mean, I can read the file and parse it, but it would be neater to be able to get it from the Oracle server in some manner.TIA/Rob ...

tnsnames.ora

We're playing around with the tnsnames.ora file, trying to get failover to work successfully in 10g. In doing so, we noticed that there was a copy of tnsnames.ora on the database server.My understanding is that for an Oracle connection to be possible, a tnsnames.ora file on the client must be compat ...

Another TNSNames.Ora question

I began by searching through several posts about the usage and location of the tnsnames.ora file but haven't found the exact issue that we are having.Currently this file in our setup is located C:\Program Files\Tnsnames\TnsNames.oraFor a certain access databases we had to add a new entry to this fil ...