This is my tnsnames.ora but when i try to tnsping college it gives me following error CODE[oracle@localhost 10.2.0]$ vi tnsnames.ora [oracle@localhost 10.2.0]$ tnsping college
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 14-OCT-2011 14:37:22
Copyright (c) 1997, 2005, Oracle. All rights reserved.
in both server & client i had set "TNS_ADMIN = $HOME" (see the above environment files) so,
my listener file is in server home directory
my tnsname file is in client home directory
i was started listener in server (ofdb):
$ lsnrctl start ofdb
listner started successfully then came to client side (DB11G) :
$ tnsping TO_OFDB
"TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 21-MAY-2012 10:11:27
Copyright (c) 1997, 2007, Oracle. All rights reserved. Used parameter files: /u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora TNS-03505: Failed to resolve name"
11.2.0.1 I am still resolving the locking issues in our database Often the delete is blocked by some transaction. The operations said that it is intermittent. Last night they were able to delete the 1M transactions without the locking.But the past days lock often occurred, and they have to bounced the database to release the locks.
I there a way I can compare what happened last night why the batch was able to delete smoothly , and compare it against the other night where the delete was blocked?By using ASH, AWR, ADDM? I also run now this procedure, to identify the blocking sql statement:
I have installed Oracle 10g client and am trying to connect to an Oracle 9i database with it. I have already created the required Listner and service names. But when I try to login to SQL * Plus , it gives me the following error: Ora-12154: TNS: Could not resolve the connect identifier specified
Could Oracle 10g client connect to a 9i database? If so how do I fix this problem?
I am trying to create a DR on the same server as that of primary server.
Specifictaions: Primary server:test DR: testdr
I have made thetns entries and i am also able to tnsping both test and testdr. But below is the error that is being constantly getting logged in the alert of primary server.
Error 12154 received logging on to the standby Fri Dec 14 20:09:36 2012 Errors in file /11g/oradata/admin/ettest/bdump/ettest_arc0_7336.trc: ORA-12154: TNS:could not resolve the connect identifier specified PING[ARC0]: Heartbeat failed to connect to standby 'ettestdr'. Error is 12154.
I have a really strange problem connecting from a new client to an Oracle server, here are the points :
- There is no problem with DB server and its listener and all that as I am able to connect from other clients - I have installed the oraclient on this machine ( it is a XP machine ) and copy/pasted the TNSNAMES.ORA from one of those correct PCs here and when I do a TNSPING is returns OK - even when I open oracle net manager I see the TNS entries in there and when I test a connection thru it is says successfull - BUT WHEN I USE SQL+ or TOAD or ODBC ( any of these) trying to make a connection using the exact same TNS entries it returns :
"ORA-12154: TNS:could not resolve the connect identifier specified"
- I have tried with both IP and Host name but no luck - TNSNames.Ora and sqlnet.ora both are located here : oracleproduct10.2.0client_1NETWORKADMIN - there is just one oracle home - I have already uninstalled/installed oracle client - These lines are included in Sqlnet.ora : SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES)
I marked those entries in Sqlnet.ora and that made no diff in result, another thing : if I use easy connect method : sqlplus scott/tiger@<Servername>:1521/ORCL it does connect but using TNSNames still I can not get connected. so strange!!, seems somehow the TNS file even is not being picked or looked at !
I installed Oracle 9i under W2K with preconfigured DB (SID=ORCL), after that I intalled Oracle developer suite and everything is OK but, When I created second DB (SID=SUMM), I get "ORA-12154: TNS:could not resolve service name" when I tried to connect with :
SQL> connect sys/oracle@summ as sysdba
NB: I have no problem when I use
SQL> connect sys/oracle@orcl as sysdba
Below, are my SQLNET.ORA, TNSNAMES.ORA, LISTENER.ORA files
What I'm trying to do Establish a remote connection to an Oracle 9i R2 9.2.0.8.0 database using "Oracle Provider for OLEDB 9.2.0.7.0" (I was unable to find an 9.2.0.8.0 equivalent) on a Windows Server 2008 R2 64-bit machine.
I have both 10g and 11g installed in my machine.There are so many CI builds that runs without problems.For few builds which uses 10g, it throws errors as ,
SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 27 01:18:52 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. ERROR: ORA-12154: TNS:could not resolve the connect identifier specified Enter user-name:
Only at a particular step, this is happening. After this,if some-other target is connecting to Oracle,it is able to connect.
My database is oracle 9i when try to connect oracle database using putty to AIX server like..
$ sqlplus
SQL*Plus: Release 9.2.0.8.0 - Production on Wed May 15 09:50:01 2013
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: sys@testdb as sysdba Enter password: (given password)
(then showing the following Error message)
ERROR: ORA-12154: TNS:could not resolve service name
But I try to connect using SQLPlus window then it is successfully connected also if i try to connect using command line window like..
C:>sqlplus /
Enter user-name: sys@testdb as sysdba Enter password: Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production JServer Release 9.2.0.8.0 - Production
SQL> select name from v$database;
NAME --------- TESTDB
then it is also successfully connected to database..what is the problem .
My server database is not connected today whenever I try to connect it. It was working properly till yesterday but today morning when I came to office and want to connect with server then my database server show the message "ORA-12154 TNS: could not resolve the service name" and not connected.
I can able to login to the database through an user A. But when I try login as B,I am getting the follwing error. ORA-12154: TNS:could not resolve service name...I am using the following method.
1. Login to the database server via putty. 2. sqlplus A/****
for the user A,the step2 is working fine. But the same step is failing for the user B.And the user B is trying to connect to the database from the same server as the user A logged in to the database successfully.
db01: sqlplus B/***** SQL*Plus: Release 9.2.0.4.0 - Production on Wed May 19 13:12:52 2010 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password: ERROR: ORA-12154: TNS:could not resolve service name
Enter user-name: I don't know why this error is coming for a particular user only.
My database link to the remote database used to work fine until the company VPN was updated for some security reasons. Now When I try to connect using the DBlink now, error comes up:
TNS 12541 no listener.
Checked the actual listener on the remote database(destination) and it is up and running fine. I am able to ping their machine.
ping <remote host> -works fine tnsping<remte host> -fails
it comes back with error TNS 12541: no listener
Nothing has been changed on both databases. The destination database can connect to our database without any issues(they can tnsping and use the dblinks to our database).
While connecting to Database through sqlplus as sysdba, error pop-up.
SQL> conn sysdba@disdevt Enter password: ******* ERROR: ORA-12154: TNS:could not resolve the connect identifier specified Warning: You are no longer connected to ORACLE. SQL>
but i am able to log-in to database through pl/sql developer. Since TNS is same for both.
I have oracle 10g and Developer suite installed locally in my system and I have edited my TNSNAMES.ora file and added a entry for VISLINUX(for both Developer suite and oracle DB TNSNAMES.ora files).
When I use TNSPING comand I get an error for the schemas APPDEV and VISLINUX.
D:Documents and SettingsBAR>tnsping appdev
TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 25-DEC-2 008 20:22:57
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files: C:DevSuiteHome_1 etworkadminsqlnet.ora
What works: There is a oracle database on the local network. I'm connecting to it through my web server on my pc (apache/php). I have installed "oracle_instantclient10". It works fine - i can connect to oracle db, queries are executed fine.
What doesnt work: I'm trieing to connect to the same oracle db from a Linux server, but i get the error:
ORA-12154: TNS:could not resolve the connect identifier specified
My linux server can connect to remote oracle db, because "nmap ORACLE_DB_MACHINE_IP -PN", gives me answer "1521/tcp open oracle". I have the same firewall allowance with my winXp pc.
I use the same "TNSNAMES.ORA" and "SQLNET.ORA" files on both: linux server, winXp pc. The only difference between winXp and linux machines is that winXp uses oracle instant client version 10.2, and linux uses version 11.2.
I'm not able to login to PL/SQL Developer 7.0.3.1123.I'm receiving "ORA-12154: TNS: could not resolve the connect identifier specified" error. Although it lists all TNS entries in Database drop down.It was working fine last week but now I'm not able to login.
i tried for 3 days to setup a connection between my oracle database 11.2 (resides on 2003,64 bit Microsoft windows) and a mysql database (resides on 2003,32 bit Microsoft widows).
i used dg4odbc 64 bit which was installed on oracle server, my steps was as follows :
1- configure ODBC driver (MYSQL 3.51 odbc) on oracle server that connect to mysql database and the connection was tested successfully (the name of odbc dsn is DG4ODBC).
2- configure the listener.ora file (which resides on dg4odbc installation path) that contains the following :
4- configure that initdg4odbc.ora file that resides on the dg4odbc installation.
HS_FDS_CONNECT_INFO = DG4ODBC HS_FDS_TRACE_LEVEL = off
5- restart the gateway listener.
6- test DG4ODBC service by tnsping which was successful .when i try to get some data from mysql database by SELECT * FROM MDL_COURSE@DG4ODBC query,the query take some time (15 second !!) and return
ORA-12154: TNS:could not resolve the connect identifier specified
we have oracle Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bi PL/SQL Release 10.1.0.2.0 - Production CORE 10.1.0.2.0 Production TNS for IBM/AIX RISC System/6000: Version 10.1.0.2.0 - Productio NLSRTL Version 10.1.0.2.0 - Production
and SQL Server 2005 on MS windows Server 2003
i followed the article and i get succeed on each steps
[URL]
when i execute the select statement under user by name NEW I got below error
ORA-02019: connection description for remote database not found
it seems to me that the file tnsnames.ora is not read when i execute sqlplus.whit the command: sqlplus username / password @ servicename i receive the error ORA-12154, while if i pass the whole connection string i can connect without problems
I have overwritten tnsnames.ora file with newone. In new tnsnames.ora file I have added new host string, remaining all unchanged.
after that, when trying to connect using sqlplus(from windows machine, sqlplusw.exe), working fine. But when trying to connect through putty getting error.
ORA-12154: TNS:could not resolve service name
for the same reason my scheduled cron tab can not run export backup. cron tab error is
EXP-00056: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve service name EXP-00000: Export terminated unsuccessfully
I am suspecting problem may be due to file accessing permission related issue. But cant solve it. Current tnsnames.ora files permission is
I have a Primary database and Standby database both in ASM. Recently my archive logs got deleted and i am trying to recover my standby database with an incremental backup based on scn from primary database. But i face the below error when i recover the standby database with the incremental backup taken in primary database.
RMAN> recover database noredo;Starting recover at 06-NOV-13using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=21 device type=DISKchannel ORA_DISK_1: starting incremental datafile backup set restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setdestination for restore of datafile 00001: +STDBY/11gdb/datafile/system.258.805921881destination for restore of datafile 00002: +STDBY/11gdb/datafile/sysaux.259.805921967destination for restore of datafile 00003: +STDBY/11gdb/datafile/undotbs1.260.805922023destination for restore of datafile 00004: +STDBY/11gdb/datafile
