Networking And Gateways :: ORA-12514 / TNS / Listener Could Not Resolve SERVICE_NAME

Apr 22, 2011

I have a database named DBKNIT and my server name is USMSERVER, But i cant login to the PLSQL from my client PC , there is an error :

ORA-12514:TNS:listener could not resolve SERVICE_NAME given in connect descriptor

View 2 Replies


ADVERTISEMENT

Networking And Gateways :: ORA-12514 - Listener Does Not Currently Know Of Service Requested

Nov 18, 2012

I am getting the following error.

C:>sqlplus sys/oracle@duptest as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 18 17:58:22 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Enter user-name:

My tnsnames.ora is as follows:

# tnsnames.ora Network Configuration File: C:appAliproduct11.2.0dbhome_1NETWORKADMIN nsnames.ora
# Generated by Oracle configuration tools.

DUPTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-LRTU6C15D75.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = duptest.localdomain)
[code]....

The command completed successfully

View 6 Replies View Related

Networking And Gateways :: ORA-12514 - TNS - Listener Does Not Currently Know Of Service Requested In Connect

Jan 25, 2010

im getting error ORA-12514.our prod db runs under default listener.nw i have configured another listener.if i try to connect from the loacl im grtting above error,bt im able to tnsping from the local system.

View 8 Replies View Related

Networking And Gateways :: ORA-12514 - TNS - Listener Does Not Currently Know Of Service Requested In Connect Descriptor

Feb 9, 2010

I have oracle 11g on windows xp. I can connect to oracle by SQL Plus without any problem, but when i want to connect to oracle by Toad or SQuirrel i see this error:

PTM Coding: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

my listner.ora and tnsnames.ora come below:

listner.ora:
# listener.ora Network Configuration File: C:appKiarashproduct11.1.0db_1
etworkadminlistener.ora
# Generated by Oracle configuration tools.

[Code].....

View 4 Replies View Related

Networking And Gateways :: Can't Resolve Tns 12541 Error - No Listener

Nov 1, 2010

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

LISTENER ENTRY:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
[Code] ......

None of the above should be the cause because there was no change been made on any of these.

View 3 Replies View Related

Networking And Gateways :: TNS Could Not Resolve Connect Identifier Specified

Nov 4, 2010

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 !

View 2 Replies View Related

Networking And Gateways :: ORA-12154 / TNS - Could Not Resolve Service Name

Dec 18, 2003

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

# SQLNET.ORA Network Configuration File: C:oracleora90networkadminsqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

[code]....

View 39 Replies View Related

Networking And Gateways :: TNS-03505 / Failed To Resolve Name

May 21, 2012

I have 2 virtual machines, in that two vitual machines oracle servers are there.

machine 1 environment file (ofdb.env):

TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=localhost.localdomain; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_SID=ofdb; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM

[code]....

machine 2 environment file (.bash_profile):

TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=localhost.localdomain; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_SID=DB11G; export ORACLE_SID

[code]....

Now i want to connect from "DB11G (client)" to "ofdb (server)"

ofdb (TNSNAMES.ora) :

TO_OFDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1523))

[code]....

DB11G (listener.ora) :

ofdb =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

[code]....

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"

View 9 Replies View Related

Networking And Gateways :: ORA-12154 / TNS / Could Not Resolve Service Name

May 15, 2013

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.

My configuration

sqlnet.ora
# SQLNET.ORA Network Configuration File: D:oracleora92
etworkADMINsqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = B81DCS.COM
SQLNET.AUTHENTICATION_SERVICES= (NTS)

[code]....

View 21 Replies View Related

Networking And Gateways :: TNS - Could Not Resolve Connect Identifier Specified

Dec 29, 2012

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.

View 5 Replies View Related

Networking And Gateways :: ORA-12154 - TNS - Could Not Resolve Service Name?

May 14, 2013

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 TNSLISTENER.ora file is

# TNSNAMES.ORA Network Configuration File: /u01/app/oracle/product/9.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

SINGERDB =
(DESCRIPTION =
(ADDRESS_LIST =

[code]....

View 7 Replies View Related

Networking And Gateways :: ORA-12154 TNS - Could Not Resolve Service Name?

Dec 24, 2010

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.

View 9 Replies View Related

Networking And Gateways :: ORA-12154 / TNS - Couldn't Resolve Service Name

May 19, 2010

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.

View 21 Replies View Related

Networking And Gateways :: ORA-12154 / TNS / Could Not Resolve Connect Identifier Specified

Dec 4, 2012

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.

View 6 Replies View Related

Networking And Gateways :: ORA-12154 - Could Not Resolve Connect Identifier Specified

Dec 26, 2008

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

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 70.63.134.203)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = APPDEV)))
VISLINUX = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 75.
182.87.181)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = VISLINUX) )
TNS-12533: TNS:illegal ADDRESS parameters

D:Documents and SettingsBAR>tnsping vislinux

TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 25-DEC-2
008 20:23:21

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
C:DevSuiteHome_1
etworkadminsqlnet.ora

TNS-03505: Failed to resolve name

and when I use TOAD to connect the schema's I get the following error ORA-12154:TNS:could not resolve the connect identifier specified

Here are the contents of my TNSNAMES.ora file

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = anvesh)(PORT = 1521))
(CONNECT_DATA =

[Code]....

View 4 Replies View Related

Networking And Gateways :: ORA-12154 / Could Not Resolve Connect Identifier Specified

Mar 17, 2011

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.

View 16 Replies View Related

Networking And Gateways :: ORA-12154 TNS - Could Not Resolve Connect Identifier Specified

Mar 7, 2011

While connecting to oracle database, i'm getting

SQL> conn red_user/red@orcl
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Warning: You are no longer connected to ORACLE.

View 6 Replies View Related

Networking And Gateways :: Any Option To Change Default Listener As Listener 1

Mar 11, 2010

I am using oracle 11.2.0 in linux platform.i have created a listener for the asm database. and i am using non default port of 1525 whenever i go for lsnrctl>status always shows for the port 1521. i don't want the default port 1521 and i have changed the local listener as listener1 with port 1525 protool tcp in spfile and registered with the asm database.Is there any option to change the default listener as listener1.

also,everytime when i give lsnrctl>show current_listener it is showing "listener"

i have set the current-listener to listener1 and save_config listener1 and reloaded.After exit and enter lsnrctl>status it will show for port 1521 When i attempt to start listener1 every time. it will prompt listener1 is already running.

View 8 Replies View Related

Networking And Gateways :: Select Statement - Could Not Resolve Connect Identifier Specified

Jun 7, 2010

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

View 1 Replies View Related

Networking And Gateways :: Add SID In Listener.ora File To Reload Listener?

Jul 5, 2010

In one of our RAC envrionment, we have more than 15 databases in a server running in AIX Operating system.the Listener file I am able to find only one entry (SID). But while trying to execute lsnrctl status it displays all the 15 SIDs in the list hosted in the ser ver. Not sure how it works?

As we created another one new database in the database, where i need to add this SID in the listener.ora file to reload the listener.

View 4 Replies View Related

Networking And Gateways :: ORACLE Error 12154 Encountered - Could Not Resolve Service Name

May 13, 2013

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

# ls -l admin
total 112
-rw-r--r-- 1 oracle oinstall 14661 Apr 26 2002 libnk59.exp
-rw-r--r-- 1 oracle oinstall 643 Apr 26 2002 libnk59.imp
-rw-r--r-- 1 oracle oinstall 5728 Apr 26 2002 libnrad9.exp

[code]....

View 5 Replies View Related

Networking And Gateways :: Listener Dynamic Registration

Jan 3, 2012

Which parameters are required in init file for 'Dynamic Listener Registration'? (for default port/ protocol). I understand that Local_listener is required only if we are using not default protocol, port.

Also which cases we need listener.ora file? I understand we need it for 'Duplicate Database' using RMAN as well as for 'Data Guard'. what else will need it?

View 4 Replies View Related

Networking And Gateways :: Unable To Start Listener

Mar 1, 2011

I am having a problem getting my listener to start.

[oracle@jhlinux ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 01-MAR-2011 23:26:30
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jhlinux.home.com)(PORT=1521)))
[code]...

View 36 Replies View Related

Networking And Gateways :: How Many Listener Supported In One Database

May 30, 2010

How many listener we can have in one database? How many users can be support by one listener?

View 3 Replies View Related

Networking And Gateways :: Listener Could Not Listen Ora 11 XE Server

Mar 10, 2012

I have installed on my local machine the Ora 11 XE server and the client. Its okay. I can logon from the OAS normally.

However, when I try to connect from my Php application, the messages that comes is: 'ORA-12154: TNS:could not resolve service name'.

View 9 Replies View Related

Networking And Gateways :: How To Find Out The Listener Password

Mar 24, 2011

How to find out the listener password in oracle?

View 3 Replies View Related

Networking And Gateways :: Configure Listener Using Net Manager

Oct 29, 2011

When i configure a listener using net manager,if found that the red text box in the picture can fill "the value of the global name " or "the value of the service_names".

View 7 Replies View Related

Networking And Gateways :: Listener For Oracle HS Not Starting?

Mar 16, 2011

I am done with my configuration for oracle HS to connect to SQLserver. When I tried to start my listener, it is giving the following errors.

-----------------------------------------------------------------
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
System parameter file is D:oracleproduct10.2.0db_1
etworkadminlistener.or
a
Log messages written to D:oracleproduct10.2.0db_1

[code]..

Contents of my listener.ora file are below
--------------------------------------------------------------
LISTENERSQLODBC =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST=

[code]...

View 1 Replies View Related

Networking And Gateways :: Listener Hangs After Starting Up

Apr 28, 2011

I just installed oracle 11g on a fresh RHEL 5.2 installation on virtual box.

The database is up, but the listener (LISTENER) hangs after a minute from starting it, and then any lsnrctl command just hangs without showing any error messages, when I restart the virtual machine and then start the DB and listener, it works for a minute and it hangs again!

View 2 Replies View Related

Networking And Gateways :: Unable To Start Listener?

Feb 27, 2011

I could not able to start the listener if i have named it other than the default name: LISTENER and the default Port:1521

if I name it list and port : 9999 it is throwing an error as

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 27-FEB-2011 13:02:23

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Starting /oraeng/app/oracle/product/11.1.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /oraeng/app/oracle/product/11.1.0/listener.ora
Log messages written to /oraeng/app/oracle/product/11.1.0/log/diag/tnslsnr/server1/list/alert/log.xml
TNS-01151: Missing listener name, list, in LISTENER.ORA

Listener failed to start. See the error message(s) above...

Should i have to do some changes in sqlnet.ora for overriding the default settings?

View 17 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved