Data Guard :: Listener Does Not Currently Know Of Service Requested In Connect Descriptor

Aug 30, 2010

We are trying to configuration the Dataguard in Oracle Database 10g Enterprise Edition Release 10.2.0.1.0. While we check the lsnr configuration the following error has occured.

SQL> select name from v$database;
NAME
ACCLDATA
SQL> select status,error from v$archive_dest;

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

[code]...

View 3 Replies


ADVERTISEMENT

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

Listener Does Not Currently Know Of Services Requested In Connect Descriptor

Oct 3, 2012

I am new to oracle DBA. I have just installed the oracle on centos. when i create the oracle database for the first time then listener created and worked sucessfully. but when i stop the listener and start again. I get message "Listener does not currently know of services requested in connect descriptor.

View 1 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

Listener Doesn't Currently Know Of Service Requested

Jul 15, 2010

I am using Oracle 10g and when i start my server then my database is running and my application use this database.But after 15 min automatically application show this error

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

View 1 Replies View Related

ORA-12514 / TNS / Listener Does Not Currently Know Of Service Requested In Con

Nov 19, 2012

I am facing problem "ORA-12514" error. my database is register in listener but when i connected throw "sqlplus" then i got "ORA-12514" error.

As show below

[oracle@sun3 ~]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 19-NOV-2012 14:40:15
Copyright (c) 1991, 2005, Oracle.  All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     listener1
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production

[code]....

View 14 Replies View Related

JDeveloper, Java & XML :: TNS Listener Does Not Know Of SID Given In Connect Descriptor

Apr 30, 2013

Exception in thread "main" java.sql.SQLException: Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

The Connection descriptor used by the client was:

localhost:1521:orcl

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)

[code]....

View 1 Replies View Related

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

JDeveloper, Java & XML :: ORA-12505 / TNS / Listener Does Not Currently Know Of SID Given In Connect Descriptor

Jul 29, 2011

use oracle 11g and JDeveloper Studio 11.1.1.1.0 but cant connection between database and jdeveloper becouse these message error

Test failed: Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Picture after the annex to the author of this code"isnrctl service" But under the error appears sometimes

View 8 Replies View Related

Express Edition (XE) :: ORA-12505 / TNS / Listener Does Not Currently Know Of SID Given In Connect Descriptor

Jun 2, 2013

DB is up and running fine

Connection test failed.
Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:538)
oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

[code].....

View 8 Replies View Related

Client Tools :: ORA-12505 - TNS - Listener Doesn't Currently Know Of SID Given In Connect Descriptor

Jul 25, 2011

When i'm trying to connect my already-existing database, i get an error: "ORA-12505,TNS:listener does not currently know of SID given in connect descriptor.The Connection descriptor used by the client was: localhost:1521:xe".

i can't loose the builted tables and the information stored in them.My listener.ora file is :

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oraclexeapporacleproduct10.2.0server)
(PROGRAM = extproc)
[code]....

View 36 Replies View Related

Networking And Gateways :: ORA-12504 / TNS Listener Not Given SERVICE-NAME In CONNECT-DATA

Oct 4, 2011

I am trying to connect to Oracle 11g using ODBC.I created a data source name from Admistrative Tools->ODBC Data Sources.I selected Oracle in OraClient11g_home1 as the driver. I tested the connection and it was succesful.I tried to connect from visual studio. I used the Data Source as Microsoft ODBC Data SOurce. Selected my DSN from drop down (LORAC). I gave the user name and password and got the followign errors:

ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

This is my tnsnames.ora located in C:oracleproduct11.1.0client_1
etworkadmin directory.
# tnsnames.ora Network Configuration File: C:oracleproduct11.1.0client_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
LORAC =
(DESCRIPTION =

[code]...

When i do tnsping LORAC, i get OK. When I do tnsping of the other service name i get Failed. However when I try to connect to that service from Visual studio I get a differnt set of errors:

ORA-12154: TNS:could not resolve the connect identifier specified

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

I had assumed that as the test connection from ODBC Administrator had worked I would be able to connec to my database from viusal studio. Is there something wrong in my tnsnames.ora? The content or its directory location?

View 8 Replies View Related

Networking And Gateways :: Listener Could Not Find Available Handler For Requested Type Of Server

Jun 20, 2010

I have ora-12520. I run Oracle 11g on Red Hat 4 64 bit. Actually I have RAC but one node is down and I work only with up one (connection string point directly to listener of running node). I run test with not too big loading. select count(*) from v$sessions gets ~ 200 in maximum loading, but after half minutes I get this error in my logs. Each time, lsnrctl services show that all is right. It shows one service with one handler. I see nothing in alert.log. This is very strange, I know, and I'm sure that this is an actual alert.log because, I see there other events in actual time. Most important: I have SESSION parameter set to 600 and PROCESSES set to 400 so this must be enougha...

View 3 Replies View Related

Data Guard :: Can't Connect To Standby DB

Jan 5, 2011

I'm trying to prepare data guard operation on the virtual machines.

1. I have install Oracle database without start up database on the standby server.

2. I try to connect this db by sysdba, but failed!

Quote:
C:>sqlplus "/as sysdba"
SQL*Plus: Release 11.1.0.6.0 - Production on Wed Jan 5 20:03:33 2011

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

ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name:SQL*Plus: Release 11.1.0.6.0 - Production on Wed Jan 5 20:03:33 2011

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

ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name:

I'm using instruction below: [URL]

Why I can't login to database?

View 7 Replies View Related

TNS - Listener Does Not Currently Know Of Service?

Feb 27, 2013

I am new to Oracle DB. I have installed Oracle 10g in XP Service Pack2 and was able to login using SYS/SYSTEM users and also was able to create a new user XYZ...

Once I restarted my system, I am facing a strange problem while login. It is continuously throwing the error "tns: listener does not currently know of service requested in connect descriptor". I do not understand the reason. I have checked the services and all oracle related services are running.

However, when I tried to login with the same userid/password from command prompt using 'sqlplus' command, I am able to login ! There was no error this time.

View 2 Replies View Related

Create Another Listener Service In RAC 11gR2 Env?

Aug 30, 2011

I need to create another listener service in RAC 11gR2 env for a new application connecting to the database in 11gR2 env. I have an existing listener service listening on 2 RAC instances now.The new one needs to be created will have a new service_name, preferably using different port (other than 1521), listening on same same set of instances.

View 3 Replies View Related

Networking And Gateways :: ORA-12518 Tns - Listener Does Not Currently Know Of Service?

Jan 31, 2013

ORA-12518 Tns: Listener does not currently know of service

from application server using client 10g to connect our database.This problem happens only in application server and we tried from another server we can connect to database easily but problem only in application server.

this error since TNSNAMES and network are properly hosted since there no network disconnection betwwen database server and application server.

View 1 Replies View Related

Server Administration :: Listener Log - No Appropriate Service Handler Found?

May 22, 2012

On last Saturday we encountered error 'TNS-12519: TNS:no appropriate service handler found" in our listener log for some moment of time let say around 5mins and later it got all right itself.

View 3 Replies View Related

Automatic Storage Management :: How To Start CRS Listener Service / What Is It Used For

Apr 25, 2013

I am not using RAC (to my knowledge), but I installed grid so I can use ASM with my RDBMS.

Recently I noticed that the "CRS Listener" service was not started, when I try to start it then it immediately stops. It does not seem to affect the databases, they are still up and running. What is this service used for and how can I get it to start. I am using Oracle Enterprise Server 11.2.0.3 and Grid 11.2.0.3 on a Windows 2008 R2 64-bit server.

View 2 Replies View Related

TNS Listener Service Disappeared After Restart Windows 7 X64 Oracle 11g

Dec 22, 2012

I just finished my first course in SQL for Oracle 11g at my local community college. We used SQL*Plus for the coursework and for the next class I need to use SQL Developer. Initially, I installed the Developer and was unable to establish a test connection due to the listener not being installed. I fiigured out that I needed to use the Network Configuration Assistant to add and configure the listener. After doing so, I was able to connect using Developer. The issue, however, is that any time I restart my computer, the TNS Listener service disappears from the list of services in Task Manager and I have to delete and then add and configure the service again using Network Configuration Assistant. Obviously, the Listener still exists because I can delete it and then recreate it.

View 4 Replies View Related

Application Express Listener :: How To Upload File Using Restful Service

Feb 4, 2013

I want to upload file using restful service This is my code to send file to rest service

MultipartEntity reqEntity = new MultipartEntity(HttpMultipartMode.BROWSER_COMPATIBLE);
FileBody bin = new FileBody(f);
FormBodyPart bodypart = new FormBodyPart("file", bin);
reqEntity.addPart(bodypart);

[code]...

But how can i retrive at server side in restful service using plsql?

View 0 Replies View Related

Networking And Gateways :: TNS Listener Service Won't Start After Changing (Logon As) Setting

Mar 22, 2010

One of our requirements is to secure the listener and other Oracle services by running them as a local OS account rather than as LocalSystem on the server.

I created a local OS account (assume it's named oracleuser), assigned it to the User and ORA_DBA groups on the server, and then I went to the Local Policies and added oracleuser to "Deny log on locally" and "Log on as a service".

I opened up the Services utility and stopped the four Oracle services we have running (OracleMTSRecoveryService, xxx_home1iSQL*Plus, xxx_home1TNSListener, and OracleServiceMYDB). I changed the "Log on as" for each service to oracleuser with its password (copied and pasted so I know there are no typo's), and restarted the services.

All the services except the listener started up. Attempting to start the listener caused the following error:

"The xxx_home1TNSListener service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."

I tried rebooting the server and had the same result.For now just the listener service has been switched back to logging in as LocalSystem while the other services continue to use the local OS account and the database seems stable, but I do need to figure this out.

View 2 Replies View Related

Clusterware :: Unable To Connect Database Service?

Apr 29, 2013

We are getting problem while installing OID Infrastructure on one node.

metadata repository database: 10g R1 (10.1.0.2.0)
OID: 10g R1 (10.1.0.2.0)

We had installed in node 1 & now the partition is shifted to node2 ,But installation on OID infrasturcture, when we aretrying to connect repository database, it says, hostname:<PORT> service may not be avaialble, listener may not be up.unable to connect
orcl.test.com

whereas the service is running & listener is up. We copied inventory location and oraInst.loc and oratab file from node1 to node2, But still unable to connect metadata repository from infrastructure node.What are we missing here..

View 0 Replies View Related

XE :: Unable To Connect To XE Service When Running Cisco AnyConnect VPN

Jun 4, 2013

We have the Oracle 11g XE database installed on a Windows 7 laptop. The Oracle XE database runs fine when the laptop not connected to a network, when connected to our corporate lan, or when connected to a cable-modem. However, when running under the Cisco AnyConnect VPN client, we are unable to connect to the Oracle XE service.

I have tried to resolve this, but am stuck. I do not if this issues is caused by:
1. There is no IPv6 address listed for the AnyConnect VPN (from ipconfig /all)?
2. Something regarding split-tunnelling that must be configured on the VPN?
3. Can the Oracle XE database run under an SSL VPN?

Below is the output of when I try to connect the Oracle XE service via sqlplus.
**************************
The OracleXETNSListener service is starting.
The OracleXETNSListener service was started successfully.

The OracleServiceXE service is starting..............
The OracleServiceXE service was started successfully.

C:ProgramDataoraclexeapporacleproduct11.2.0serverin>sqlplus system/password@XE

SQL*Plus: Release 11.2.0.2.0 Production on Fri May 31 07:03:24 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR:
ORA-12546: TNS:permission denied

Enter user-name:
**************************
listeneralertlog,xml
<msg time='2013-05-31T07:03:24.950-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DEV-M-137GF'
host_addr='fe80::2884:a03d:5286:7996%21'>
<txt>31-MAY-2013 07:03:24 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:ProgramDataoraclexeapporacleproduct11.2.0serverinsqlplus.exe)(HOST=DEV-M-137GF)(USER=ptavolet))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.99.8.39)(PORT=56324)) * establish * XE * 12514
[code].........
**************************
listener racelistener.log file

Started with pid=3688
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC1ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DEV-M-137GF.paychex.com)(PORT=1521)))
[code]......
**************************
C:ProgramDataoraclexeapporacleproduct11.2.0serverin>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 31-MAY-2013 07:07:43

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
Start Date 31-MAY-2013 07:01:12
Uptime 0 days 0 hr. 6 min. 31 sec
[code].......

The command completed successfully
**************************
C:ProgramDataoraclexeapporacleproduct11.2.0serverin>lsnrctl service
LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 31-MAY-2013 07:08:13
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER

The command completed successfully

View 4 Replies View Related

Application Express :: Connect To Listener From LAN

Dec 11, 2012

I've just instaledl APEX on Oracle 11g, with APEX listener 1.1, working fine at localhost. But I can't reach it from others computers on LAN. I searched several threads about this and thought I should run

EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

But when I execute that, I got the message 'ORA-30952: illegal configuration of HTTP/HTTPS in xdbconfig.xml'.

View 6 Replies View Related

System Tablespace - File Contains Used Data Beyond Requested RESIZE Value

Oct 23, 2012

I'm trying to increase the size of my system tablespace. The tablespace contains one datafile size 900MB and it can increase to 2GB.

I'd like to change this to autoextend as I'm going to run csscan on the database.

When I do change the autoextend and unlimited part of the file I get: ORA-03297: file contains used data beyond requested RESIZE value

I've also tried to increase the datafile to 4GB but still the same. I can see that there is more then enough space on the filesystem.

Oracle Enterprise edt 10.2.0.5

View 8 Replies View Related

Networking And Gateways :: Can't Connect To Remote DB Listener

Jul 2, 2010

I have a database up and running (including listener) on machine A. From that machine, everything seems fine. However, when I try to connect to it from another machine (say, machine B) on the network, the connection cannot be established (exact message: connection to database failed: The Network adapter cannot establish the connection).

I can successfully ping machine A from machine B. The machine A db is a default install (ORCL).

Is it possible the DB listener is not configured properly to connect to remote clients? On machine B, I have oracle tools such as SQLPLUS, Oracle Net Manager, and Net Configuration Assistant.

View 31 Replies View Related

Connect From A Remote Client / Received Error Of No Listener

Dec 24, 2007

We installed Oracle 10g on one of our servers and configured the listener to host=localhost. Here's our listener.ora file:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
[code]...

After restarting the listener, we could connect using the connect identifier from the local server. However, when trying to connect from a remote client we received the error of "no listener". In the remote client the identifier is defined with host=ip_address. TNSping from the client to the host was successful.

When we changed listener.ora to host=up_address we could connect ONLY from the remote computer. Only after changing the host in tnsnames.ora file to the IP as well - we could connect from both the local server and the remote client.

I usually use host=localhost in the listener file (and the local tnsnames file) and never had this problem before.

View 1 Replies View Related

Backup & Recovery :: Restore Rman Backup On New Server As Different Name Sid / Service / Listener

Feb 13, 2012

I am attempting to use an rman backup form our live server to restore live data over an existing dev database with a different name. I cant use the duplicate command as the versions of oracle are different (10.2.0.4 EE on live, 10.2.0.5 SE on dev) So I copied the backup sets including an autobackup control file onto the dev server. I set the ORACLE_SID to the DEV version (SUN43DEV) and startup nomount and restore controlfile from the backup location. This works and restored the live controlfile. However, I then wanted to mount the database and catalog the backupsets before making a note of the last archivelog etc and restoring the backup with set newname options. But when I try to mount the database I am told that the database has a different name (SUN43 is not SUN43DEV). I read somewhere that I need to set the ORACLE_SID to the live value (SUN43) and restore as that, then use nid TO RESET THE DBID and DATABASE NAME. However, my tnsnames on DEV has no entry for the live database, and we do not have any service defined through ORADIM for the live instance on the dev server. Should I be creating an entry in DEV tnsnames that actually looks at the LIVE server? or do I need to create a service and tns entry etc for SUN43 on my DEV server pointing at the DEV server I have not seen any mention in instructions of creating a service or adding the entry to tnsnames, or indeed adding an entry to the listener for the original live sid. I am worried that if I actually point to the live server then the restore would be attempted on the live server not dev even though I am running it from Dev.

Also, do I need to drop the existing database on DEV before I restore or will RMAN just restore over the top of it?

Finally, if I try to add an entry to the LISTENER.ORA for the new sid, when I stop and start the listener, or reload, the entry is not recognised. I also noticed that the existing SUN43DEV entry is not in there either, yet I can still use that SID - I am assuming that is because the listener is not being used and the sid is recognised from the existence of the service in windows services instead?

View 2 Replies View Related

Data Guard :: Rolling Upgrade Physical Data Guard

Jul 5, 2011

We have physical data guard configured version (10.2.0.4). We are in need to upgrade primary & standby database to 11G R2. Can we perform rolling upgrade.

View 3 Replies View Related







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