Oracle DATAGUARD SERVICENAME AND TNSNAMES.ORA problem.

Experts,I have created a database TESTDG10 ( db_unique_name) and using a grid control created a standby TEST10S ( db_unique_name). The dbname is TESTDG10. The dataguard configuration works well. I am able to switchover from one database to another and able to see logs transferred and applied. The Pr ...

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 ...

tnsnames.ora conflict

I am unable to login into an instance via sqlplus. i get ora 12154 error while trying the same.But, i am able to work in the same instance using toad without any problems.I have developer6i installation and oracle workflow installation. so, i have two tnsnames entry one in c:\orant.... and the other ...

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 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 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 TNSNAMES.ORA

My machine has quite a number of tnsnames.ora for various installations done in course of time. I have only one database. I need to make an entry in the tnsnames.ora for connecting from sqlplus. How do I identify the right tnsnames.ora linked to this database. Also how do I get information from the ...

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 Substitute for Tnsnames.ora ?

Actually I don't want to keep the tnsnames.ora on every client ... rather I would like to have it at the server side. So, overtime we have a new entry I don't have to update all client's tnsnames.ora ... one update on the server side should do the job ...Is there any way to accomplish this task ?App ...

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? ...

Oracle Incorrect spelling of TNSNAMES.ORA at many places in 10g documentation!

TNSNAMES.ORA is incorrectly spelled as tsnames.ora at many places. I was going to send the hyperlink to the "2 Day DBA" book to one of our end users when I noticed this error.It seems to be there in many books.A search would give names of these books.http://www.oracle.com/pls/db102/search?word=tsnam ...

Oracle is telnet use local tnsnames.ora?

I was suprise that when the local tnsnames.ora of client was not correct,sqlplus at telnet can't connect to server,and when the file was modify,I can use sqlplus connect to oracle through telnet.is telnet use local tnsnames.ora? ...

Oracle tnsnames.ora

Where can I find out what the entriesmean in tnsnames.ora and how do I find outwhat entries I must have to connect tothe database on my PC in Windows 98? ...

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 ...

Oracle TNSNAMES.ora and LISTENER.ora tuning

I have a PE 8.1.7 installed.When connecting fron SQL Navigator to Oracle DB I get an error message and sqlnet.log contains the following:Fatal NI connect error 12538, connecting to:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=Andrei1.domain)(CID=(PROGRAM=E ...

TNS Server - Distributing TNSNAMES.ORA

I am looking at improved methods for updating TNSNAMES.ORA on machines within our organisation (multiple Office locations around the world).Some-one once mentioned a TNS Server which performs in a similar manner to a DNS Server (except for TNSNAMES.ORA instead of HOSTS). However, I cannot find any i ...

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 tnsnames.ora and listener.ora

I am studying oracle and came accross tnsnames.ora and listener.ora file.Can any one tell me in simplified terms about these 2 files. what are they and what exactly they do? ...

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 ...

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, ...

alternative solution to tnsnames.ora

We have about 30 Oracle servers, more than 50 users. I would like to know if it is intersting to think to avoid using local tnsnames.ora and use other solution (NB: we don't have LDAP in our company). Any suggestions ? recommandation ? ...

OEM and tnsnames.ora

This is my first post here... I am in the process of completing my Oracle cert, and I'm running Oracle 9i R2 on RH 9.0. The db runs great, but when I try to use OEM I get this error: ORA-12514: TNS:Listener could not resolve SERVICE_NAME given in connect descriptor I did lookup this error and I know ...

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 ...

problem with tnsnames.ora

I have ten oracle´s client and I need they have the same tnsnames.ora.This file changes a lot.So I would like tnsnames.ora will be in a machine, only one, I modify this when i need and the ten client use this file Is it posible? ...

Oracle tnsnames.ora

Hi, Can anybody tell me, how does oracle pick the tnsnames.ora. I mean, where is the path of tnsnames.ora ...

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 configuration problems. How do I test if tnsnames.ora is being found?

tnsnames.ora is located at:C:\oracle\Ora_Client\network\ADMINSystem Variables set to:ORACLE_HOME C:\oracle\TNS_ADMIN C:\oracle\Ora_Client\network\ADMIN\SQLPlus returns the error "Message file SP1<lang>.msb not found"SQLNavigator returns the error "Cannot initialize OCI Error -1 ...

Unable to create Service name in tnsnames.ora

I am unable to create service name through Oracle netmanager.Due to this, I directly entered my entries in tnsnames.ora.But when I tried to log in through SQLplus, I got error "TNS could not resolve the connect identifier specified."Please help me...Its urgen t.... ...

config Listener.ora and Tnsnames.ora ?

I'm a new in Oracle DB. I'm using Windows 2000 as server and Windows XP as client. I installed Oracle Enterprise on server and Oracle 8.1 on clients.I have some client with 2 different IP address, 172.16.xx.xx and 192.168.xxx.xx whices I want to connect to the server DB. How can I set the Listener.o ...

Oracle tnsnames.ora in unix/aix

We installed Oracle 8 on UNIX box. There is no problem connecting the database from client machines. But when we tried to connect the database via sqlplus from the UNIX box, it failed. I checked the tnsnames.ora and it didn't have any entry referencing BEQ. Did that cause the problem? ...

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 ...

TNSNAMES.ORA Assistance Please

I have a quick question...I am in the process of upgrading a machine running an Oracle database. The catch to this is that I have to have both the old version and the new version running at the same time (for transition and testing purposes). So here's the catch. After cloning the machine and upgrad ...

Oracle how to configure the client tnsnames.ora parameters with a MTS Server

i have modified init.ora and start my oracleas a MTS instance.my client tnsnames.ora is the dedicate servermodel.how can i modify it and my clent can useMTS server.null ...

Is it possible to have 2 EXTPROC_CONNECTION_DATA entries in tnsnames.ora?

Oracle 10g (10.2.0.4) or 11g (11.0.1.6)Can I have two EXTPROC_CONNECTION_DATA in the tnsnames.ora?For example:In the same tnsnames.ora file:++++++++++++++++++++++++++++++++++++++EXTPROC_CONNECTION_DATA =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2)))(CONNECT_DATA =(SID = P ...

how to flush the buffered old tnsnames.ora in a live process?

I have a OCI daemon program which load Oracle client libraries to communicate with Oracle server.The daemon program is running, I add a new node entry in tnsnames.ora. But the new node can not be pickup immediately by the live daemon. The a error reports: "node is not found in the node director ...

Oracle Configuring Clients to Share Net80 Configuration (TNSNAMES.ORA)

I'd like to setup all client net80 connections to share a TNSNAMES.ORA file. I have tried adding the regestry key TNS_ADMIN to HKEY_CURRENT_USER|ENVIORNMENT key but have had no success. Not sure if it should be entered as a environment variable, I added TNS_ADMIN to HKEY_LOCAL_MACHINE|SOFTWARE|Oracl ...

Oracle listener.ora, tnsnames.ora

How can I add entries for new database in listener.ora and tnsname.ora with command line tool??I am building Installshield setup for database for Oracle 9.I can create instance with .bat file using ORADIM, and I can create the database with SQLPLUS scripts, but I cannot add entries in LISTENER.ORA a ...

Oracle Listener Local Naming -- Listener.ora and Tnsnames.ora questions

My understanding from the Oracle Net8 Administrator's Guide is that there are defaults for the listener in the event that there is nothing in the listener.ora file.Our listener configuration appears to be similar, if not exactly the same, as the defaults. Are there advantages or disadvantages to exp ...

Oracle Path of Sqlnet.ora and Tnsnames.ora

Why I have oneSqlnet.orainC:\ORAWIN95\NETWORK\ADMINandone inC:\ORAWIN95\NET80\ADMIN?andTnsnames.orainC:\ORAWIN95\NET80\ADMINandC:\ORAWIN95\NETWORK\ADMINandC:\ORAWIN95\NET80\TNSAPI?why they are duplicated? ...

Oracle a question about tnsnames.ora

I have a problem about the tnsnames.ora file. There are two address entires in the tnsnames.ora file on the database server, one is with protocol: ipc, the other is with protocol: tcp. The log file always tells me the hostname is UNKNOWN. Then I changed the hostname alias in the file into ip address ...

Oracle a question about tnsnames.ora

I have a question about tnsnames.ora file. I have two address entries in the tnsnames.ora, one is with protocol:ipc, the other is with protocol:tcp. The log file always tells me the hostname is UNKNOWN. I changed the hostname alias into ip address, but the error stills exists. But there isn't any ot ...

Oracle Why there are 2 tnsnames.ora & listener.ora files ?

According to the installation guide, I have TNS_ADMIN=/opt/oracle/config/9.2.0; export TNS_ADMINin the .profile at home directory of user "oracle"After installation succeeded, I found that there are two places that have tnsnames.ora & listener.oraOne is at /opt/oracle/config/9.2.0Other one is at ...

Oracle Trying a lot of diferent "listener.ora-tnsnames.ora" combinations

Preview:- DB: Oracle 8i personal edition over Windows 98- Listener running.- Listener.ora and tnsnames.ora, configuration based in article "http://technet.oracle.com/products/oracle8/info/comcart/readme.htm"Hi, i'm looking an answer for the ORA-28575 error, i tried several combinations in listener.o ...