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


ADVERTISEMENT

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

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

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

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

Client Tools :: Column ROWID Doesn't Display?

Feb 13, 2012

the table is a view. But the column ROWID doesn't display in Toad. He just ignores that.

View 3 Replies View Related

Client Tools :: Able To Connect From SQL-Assistant BUT Unable To Connect From SQL Developer

Jul 7, 2012

I have been troubling with this issue for the last two weeks...tried so much, but could not able to resolve....

sqlplus username/password@IPAddress:port/ServiceName

I am able to connect to DATABASE from SQLAssistant only when I provide string like ABOVE........If I dont mention the SERVICE, m unable to connect to DB.Now the biggest issue is with SQL Developer.....m not at all able to connect to DB using SQL Developer.

View 3 Replies View Related

Client Tools :: Connect Oracle Developer 6i Without Connect String

Aug 17, 2010

I have installed oracle developer 6i. in sqlplus i want to put my username and password but nothing in the connect string field.

View 1 Replies View Related

Client Tools :: ORA-01041 / Internal Error / Hostdef Extension Doesn't Exist

Apr 19, 2012

i want to mount the database through sql> startup mount exclusive; for flashback the database, then sqlplus shows 2 errors---

"ORA-24324: service handle not initialized" and
"ORA-01041: internal error. hostdef extension doesn't exist"

how to sort out these errors.i am using 11.2.0.1.0 on widows server2008.

View 6 Replies View Related

Client Tools :: Cannot Connect Using JDBC Oracle Thin Client With (New Method)?

Feb 21, 2013

The problem is that this connection errors when I try to connect using my SQuirreL client. My developers want to connecting using the SID or the SERVICE_NAME and by using the "New Method" syntax, not the "Old Method" syntax. According to the documentation the "New Method" syntax works with the SERVICE_NAME or the SID. The "Old Method" only works with the SID.

# Host name is vmwwin7634.na.SAS.com
# SID is sting2
# SERVICE_NAME is sting2.na.sas.com

PROBLEM using SID errors ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2
THIS WORKS using SERVICE_NAME ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com

I am using SQuirreL Client version 3.4.0

# Here is the tnsnames.ora entry on the server.
STING2 =
(DESCRIPTION =

[code]...

# In this documentation it says, "On new syntax SERVICE may be a oracle service name or a SID."You can find this on the orafax wiki under JDBC#Thin_driver.

# I was able to connect with the "old method" using the SID only, SERVICE_NAME errors jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2.na.sas.com
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2 (this works)

# "New Method"
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com (this works)
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2 (this errors)
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")

View 10 Replies View Related

Client Tools :: How To Connect From Client To Oracle Database In Unix

Dec 11, 2012

I have new virtual UNIX machine and I installed oracle client on /usr/lib/oracle. Also I have a oracle database and I am able to connect to this database from my desktop sql developer.

So now I am trying to connect from new UNIX machine. Where I created tnsnames.ora file under /usr/lib/oracle/network/admin and before connecting did export the following

export TNS_ADMIN=/usr/lib/oracle/network/admin
export ORACLE_HOME=/usr/lib/oracle/
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$HOME/bin:/sbin:$ORACLE_HOME/bin
export ORACLE_SID=VFIODSD1

when I try

# sqlplus
username :xxxxxxx
password : xxxxxxx

ORA-12545: Connect failed because target host or object does not exist. Not sure what I missed here. using same tns file I am able to connect from sql developer on windows.

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

Database Access Error - Listener Refused Connection With ORA-12505 - TNS?

Jul 29, 2013

I am using oracle 11g client library on Linux 64bit machine and trying to connect to oracle database using jdbc thin driver.The url format what I am trying to use is:

jdbc:oracle:thin:@IP address:port:service_nameWhen service_name = orcl :

I am able to connect with the above syntax. But when the service_name is having . e.g service_name = orcl.177.39.45, with the above format I get the above error.

 If I change the URL syntax to following, it works

jdbc:oracle:thin:@IP address:port/service_name  

But both seems to be valid syntax.So I would like to undestand the reason behind the same. When service_name is having ".", why ":"  does not work and "/"  works and when the service_name is without " ." , 1st format works. Is there any specific reason behind same? 

View 6 Replies View Related

Client Tools :: Listener Configuration?

Sep 5, 2012

i have added a new listner on new port on my window 7 system for oracle version 11.2.0.1 and registered some test databases to this new listner , then i am able to access my databases through the toad because i have changed port number in tns entry, but not able to login by sqlplus. is i am missing something? should i have to restart the system or restart the all databases?

View 1 Replies View Related

Client Tools :: How To Connect To Oracle 7 Using Client

Dec 15, 2011

I have Oracle 7 database on Server1. I need to connect this using Oracle client from windows XP.

I have downloaded Oracle client 3.0 and when I am trying to connect it saying "Unable to connect: Unsupported Oracle version".

View 8 Replies View Related

Client Tools :: ORA-12504 / TNS Listener Was Not Given SID In CONNECT_DATA

Sep 25, 2013

i am getting below error.

[Prime@localhost Prime]$ java -classpath /home/Oracle/Middleware/wlserver_10.3/server/lib/weblogic.jar utils.dbping ORACLE_THIN system systesm 10.66.12.70:1521
Error encountered:
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12504, TNS:listener was not given the SID in CONNECT_DATA
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:538)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)

[code]....

View 2 Replies View Related

Client Tools :: How To Connect To Sql Plus

Nov 18, 2010

I have to connect to sql*plus to get explain plan.When I conect in Toad, the credentials are as:-
User/schema :- TestDb
Password :- TestDb

Under direct tab:-
Host :- 172.17.252.96 Port :- 1521

Service Name :- xe

I am not able to connect to sql*plus using:-

Username :- TestDb
Password :- TestDb
Host String :- 172.17.252.96

Not sure how to login when I have IP address

I also tried login as:-

Username :- TestDb
Password :- TestDb
Host String :- xe

View 5 Replies View Related

Client Tools :: Cannot Connect To Isql Plus?

Feb 28, 2010

I am using oracle 10 g on my pc .i have no issues while working on it but whenever i am not connected to the internet its says failed to connect.As most of the time i am not connected to the internet the isql plus browser would show the same error but the moment i connect to the inet,it works.

Is it that 10g isql plus wont work while not connected to internet ?

View 3 Replies View Related

Client Tools :: Connect From Oracle 9i To Sql Developer?

Aug 30, 2011

how i can add new connection to sql developer i had made a database name abb how i will connect that to sql developer.

View 12 Replies View Related

Client Tools :: TOAD 8.6 And Oracle 10g - Cannot Connect?

Feb 22, 2012

I have TOAD 8.6 installed and hoping to use with Oracle 10g databases. I have SQL Navigator also - it works fine. However TOAD does not. Open up TOAD and see the TNS dropdown, select a database and try to log in - click on Connect and the little SQL hour glass comes on, goes off - there is no error, no message and no connection. I have tried several databases and again, SQLPlus, SQL Navigator are both working fine.

View 2 Replies View Related

Client Tools :: Unable To Connect To Database?

Oct 4, 2013

I am getting error in my database....

SQL> conn scott/tiger;
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

I tried shutdown and startup

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 4 22:31:06 2013

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

SQL> connect /as sysdba
Connected.
SQL> shutdown;
ORA-01507: database not mounted

[code]....

ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL>

View 1 Replies View Related

Client Tools :: Unable To Connect To Oracle From Toad

Jul 28, 2010

I installed Oracle 10g XE and Toad 10.5 in my home system.I am able to connect to Oracle from Oracle XE homepage and XE SQL command line but when I try to connect to Oracle from toad 10.5 I am getting the error 'TNS: could not resolve the connect identifier specified (XE)'.From toad I tried direct and TNS options but it did not work. My tns ora file looks like below.

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Anu-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

TNS_ADMIN variable has correct parameter and Toad is directing the correct TNS file. I tried changing hostname with my system's ip but still I am unable to connect to Oracle from Toad.

View 18 Replies View Related

Client Tools :: Error When Trying To Connect Sybase Through SQL Developer

Nov 17, 2012

I am getting bellow error message when trying to connect Sybase through Sql developer: status:failure-test failed:IO Error:The network adapter

View 1 Replies View Related

Client Tools :: UNIX User In Group Dba But Cannot Connect As SYS?

Jun 4, 2012

> id -a
uid=56088(appadm) gid=50120(dba) groups=50120(dba)
> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 4 09:26:23 2012

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

ERROR:
ORA-12545: Connect failed because target host or object does not exist

Enter user-name: ^C

our UNIX user in group "dba" but can't connect as SYS

why?

View 9 Replies View Related

Client Tools :: Connect Database On Unix And Windows

Jun 24, 2013

How I can connect database on unix OS and windows what is the deference.

View 7 Replies View Related

Client Tools :: Connect To Mssql Express 2008

Jan 29, 2011

I have installed and loaded a mssql express database on my pc for migration testing. When I test a connection from sql developer 3 receive "Failure -Test failed Cannot connect to Microsoft SQL Server on localhost. I am using windows authentication and SQL Server authentication and the default port 1433.

View 5 Replies View Related

Client Tools :: ORA-12154 / TNS - Could Not Resolve Connect Identifier Specified

Nov 21, 2012

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.

View 10 Replies View Related

Client Tools :: Connect With Database Through Toad - It Throws Error?

Apr 23, 2012

there is a problem , related to toad. when i try to connect with my database through toad then it throws an error-"Can't initialize OCI. Error -1", how to sort out of this problem. and i am using toad 9.2.7.1 on widows server2008.

View 9 Replies View Related







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