Networking And Gateways :: ORA-12505 Error With SQL Developer

Jul 21, 2013

I installed oracle 11g successfully and was able to login with SQL plus.When I tried making a connection with the username and password via SQL developer I'm getting the ora-12505 error (picture is attached)

Printout of tnsname.ora:

# tnsnames.ora Network Configuration File: C:Oracle11gproduct11.2.0dbhome_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
ORACLE11G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle11g)
[code]....

getting sql developer connected with my oracle database?

View 13 Replies


ADVERTISEMENT

Networking And Gateways :: Connecting Developer 6.0 To 10G Database

Mar 19, 2010

Can currently connect to a 9.2.0.1 database using Oracle Developer 6.0 with the following connect string:

C:orantBINifrun60.EXE GMS ops$cannonc/cannonc@GMS3B.TEST.COM[/email]

I don't believe it is using the TNSNAMES.ora entry for this, because when I take it out of there it still connects. I create a 10.1.0.5 database and copied the tables,etc to there. But I'm having problem connecting, getting "ORA-12154:TNS Could not resolve service name". Tried the following:

C:orantBINifrun60.EXE GMS ops$cannonc/cannonc@NJZTEST[/email]
C:orantBINifrun60.EXE GMS ops$cannonc/cannonc@NJZTEST.TEST.COM[/email]

I did add the entry for the 10G database to TNSNAMES.ora:

NJZTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = njzainettest.test.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = njztest)
)
)

I new to this, but my guess is the other entry had the full path name..and this SERVICE_NAME does not. But then again I don't believe it looks at the TNSNAMES file. This NJZTEST is the 2nd instance on the NJZAINETTEST machine.

View 6 Replies View Related

Networking And Gateways :: Setting Up Connection Between Oracle Developer And Database?

Feb 6, 2011

setup the connection between oracle developer and database.

i found the file called tnsnames.ora however, i cant open it. i dont know if i need to choose a program to open it or download extension for it.

View 12 Replies View Related

Networking And Gateways :: Getting Error TNS / Operation Timed Out

Jun 26, 2012

One of our production database we are getting error "TNS:operation timed out" from unknown port in alert logfile. Need to check why TNS error is occurring to these unknown port as our listener is running on default 1521 port. Also to inform that host=192.191.118.24 itself is the same database hosting server IP.

TNS-12535: TNS:operation timed out
TNS-12535: TNS:operation timed out
ns secondary err 12606
ns secondary err 12606
nt main err 0

[code]......

View 3 Replies View Related

Networking And Gateways :: FRM-92102 / A Network Error Has Occurred

Sep 28, 2011

when i try to open a our application i got this error

"FRM-92102: A network error has occurred. The Forms Client has attempted to reestablish its connection to the Server 5 time(s) without success."

View 1 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 :: ORA-12560 Protocol Adapter Error

Feb 16, 2010

I am trying to connect via SQLPLUS to the standalone oracle database i have installed details as follows:

Host DT1089.myname.local
Database emrep.myname.local
Instance emrep
In EM database is up and running OK
Tnsnames is located at C:OracleHomesdb10gNETWORKADMIN

[code]...

I try to log on with command line

C:> sqlplus system/***** @ emrep
**** = password for user system

but get the following error:

ORA-12560 Protocol Adapter error

View 7 Replies View Related

Networking And Gateways :: Listener Error - Failed To Start

Sep 23, 2011

after creating database i try to start listener i have copied listener.ora and edit according to db created i have folling issues.

LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 23-SEP-2011 15:02:05

Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.

Starting /u01/app/oracle/product/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
System parameter file is /u01/app/oracle/product/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.1.17.43)(PORT=1521)))
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
NL-00305: the specified path name does not exist

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

View 16 Replies View Related

Networking And Gateways :: Fatal NI Connect Error 12638

Aug 10, 2008

I'm getting this information in sqlnet.log file lying at D:oracleoradatadatabase

Fatal NI connect error 12638, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oraclemaninder)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')) (CONNECT_DATA=(SID=maninder)(CID=(PROGRAM=d:oracleora92inORACLE.EXE)(HOST=SAI-E6C10175EE4)(USER=OraUser))))
[code]...

View 5 Replies View Related

Networking And Gateways :: ORA-12170 / TNS / Connect Timeout Error

Jan 10, 2012

I installed my Oracle 10g R2 software in redhat linux installed in VMWare player in my laptop.

I am trying to connect to database from my laptop which has windows 7 installed

My goal is to connect to database installed in linux vmware from my laptop having windows7 OS..

I have installed Oracle instant client on windows 7,trying to make a connection to database but its giving me the following error when i tried...

sqlplus sqlplus scott/tiger@(description=(address_list=(
address=(protocol=TCP)(host=192.168.1.7)(port=1521)))(connect_data=(service_name=subhani)))..

ora-12170:TNS Connect TimeOut Error..

View 11 Replies View Related

Networking And Gateways :: NL-00280 - Error Creating Log Stream?

Dec 10, 2012

we are doing a fresh install of oracle10g on a ubuntu 64bit os.Our previous installation on ubuntu 32bit os was successful.On our installation on the new server we came upon this:

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
NL-00280: error creating log stream /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
NL-00278: cannot open log file
SNL-00016: snlfohd: error opening file
Linux Error: 13: Permission denied

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

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

Used parameter files:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/sqlnet.ora
Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=202.92.129.77)(PORT=1521)))
TNS-12541: TNS:no listener

since i'm new to server administration thingy,

View 14 Replies View Related

Networking And Gateways :: ORA-12560 / TNS / Protocol Adapter Error

Jan 9, 2012

I installed local database on my laptop that pc is inside a domain when i remove the network cable and connect using the sid defined in the tnsnames sys/sys@ora10g as sysdba it gives me that errors

ORA-12560: TNS:protocol adapter error

to resolve this problem i should connect like that sys/sys as sysdba without the sid but i don't want to connect in this way because i have work must be done from home on that local database so i don't want to connect with network sys/sys@ora10g as sysdba and without network sys/sys as sysdba.

i want to be always connect sys/sys@ora10g as sysdba.

View 14 Replies View Related

Networking And Gateways :: ERROR ORA-01034 ORACLE Not Available - Not Started?

Jul 30, 2002

ERROR : ORA-01034 ORACLE not avaiable.....

All Services are running (Start)....but Local Database is not opening ?

How i can got my data in Local DATABASE ?

View 39 Replies View Related

Networking And Gateways :: Getting ORA-12560 - TNS - Protocol Adapter Error?

Oct 30, 2012

Getting error ORA-12560: TNS:protocol adapter error

My database is PACKS and user ID is PACKS .

Below tnsnames.ora

# tnsnames.ora Network Configuration File: C:DevSuiteHome_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.

STOREDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mst009.stc.corp)(PORT = 1521))
(CONNECT_DATA =

[code]...

View 9 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 :: Unable To Connect To ORACLE ODA 11g - JDBC Connection Error

Aug 21, 2013

I am not able to connect to ORACLE ODA 11g. but using sqlplus its getting connected with below credential.

URL------------------- jdbc:oracle:thin:sacblmdbuser/sacblmdbuser@10.66.12.229:1521:OVPINHA
Oracle JDBC driver loaded ok.
Unable to create connection
java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186647296)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

View 2 Replies View Related

Networking And Gateways :: ORA-12560 - TNS - Protocol Adapter Error In Windows Server 2003

Nov 4, 2010

I installed Oracle 10g (10.1) in Windows Server 2003 and i am able to connect to oracle using using SQL net. But when I tried to connect this using SQL Net from Windows XP, I am getting ORA-12560: TNS:protocol adapter error. But when I tried to connect as SYSDBA user, I am able to login in SQL plus. But for a normal user, not able to log in.

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

Networking And Gateways :: How To Set Oracle Gateways 11g For Mssql

Feb 21, 2010

I want connect mssql in oracle by orale Gateways 11g

my environment:
windows Wista
oracle 11.1.0.7.0
Oracle Database Gateways 11.1.0.7.0
SQL SEVER2008

these soft in one computer.

my steps :

1. set initdg4mssql.ora
2.set listener.ora
3. set tnsnames.ora
4.start lsnrctl
5.use SYSTEM/ORACLE@DZCDB

logined. create dblink and test.

but it's error. i want to know where is the error.

View 1 Replies View Related

Networking And Gateways :: TNS Could Not Found

Jun 26, 2013

I am working on people-soft, currently i am installing it but i found this error

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

/*---------------------------------------------*/
this is listener.ora
# listener.ora Network Configuration File: C:oracleproduct10.2.0db
etworkadminlistener.ora
# Generated by Oracle configuration tools.

HRCS9 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = umhs-86cd1970f)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

SID_LIST_HRCS9 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oracleproduct10.2.0db)
(PROGRAM = extproc)
)
)

/*---------------------------------------------*/
tnsnames.ora
# tnsnames.ora Network Configuration File: C:oracleproduct10.2.0db
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.

HRCS9 =
(DESCRIPTION =

(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = umhs-86cd1970f)(PORT = 1521))

)

(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
/*----------------------------------------------------*/
sqlnet.ora
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)
/*--------------------------------------------------------*/

View 1 Replies View Related

Networking And Gateways :: Can Same DB Run On Different Hosts

Oct 8, 2012

I have one production server with oracle 11g R2 DB. I have to change Server Hardware and thats why I have to install oracle 11g R2 DB on New hardware and test it. I had installed DB with software only option and copied the cold backup of production server. The hostname and ip address of both the servers are different. I had change the "db_domain" parameter into init.ora with the hostname.Now my question is that can the same db runs on the same network with different hosts. Change of "db_domain" parameter into the init.ora is enough or i have to follow some other procedure.

View 12 Replies View Related

Networking And Gateways :: Two Different Listeners In Same Server

Jan 24, 2005

I´m working with Oracle 9.2.0 / HP-UX and I need to configure two different listeners for the same server using different IP address.

View 12 Replies View Related

Networking And Gateways :: Database Link From 11g To 10g?

Jul 5, 2012

I am trying to create a database link from the 11g database to the 10g database using:

create database link ORCL10R2 connect to <username10g> identified by <password10g> using <db10g>;

It Returns

Database link created.

select sysdate from dual@ORCL10R2 returns error:
ERROR at line 1:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

what changes I need to make to tnsnames and listener at both servers.

View 8 Replies View Related

Networking And Gateways :: How To Change Listerner.ora Name

Dec 12, 2011

How to change listerner.ora name ? I want to have something like that application.ora instead of listener.ora.

View 9 Replies View Related

Networking And Gateways :: Cannot Connect To Database

Nov 2, 2011

I installed Oracle Express on my Windows 2003 Enterprise server. And right off the bat I cannot connect to it via command line. I have googled and read many sites, but am still getting the same error, no matter what I do. I am newbie again (was a DBA in 1990...when I used to have the same error and fix it in seconds...not sure why this problem still lingers in Oracle) so most likely I am overlooking something. Below are my tnsnames.ora and liserner.ora files

tnsnames.ora
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myservername.domainname.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
[code]....

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

View 19 Replies View Related

Networking And Gateways :: Restart Server And Nothing Changes

Mar 28, 2011

My client get the error Ora-12514 when he tries to connect to the db.Well;

1) we restart the services: "OracleServiceOrcl" and listener but nothing changes
2) We restart the server and nothing changes
3) We checked the dump and he was done on March,26th. No db export yesterday. Is there any link with the clock change of this week-end (location of the server: France)?
4) The lsnrctl services listener command run successfully but it doesn't mention the instance ORCL.

View 12 Replies View Related

Networking And Gateways :: License Required To Use OID 11g

Apr 11, 2012

Im planning to install OID. I will use it for Oracle Net name resolution and Enterprise User Security.

How is this product licensed? Is it included in a enterprise rdbms license?

View 2 Replies View Related

Networking And Gateways :: MS Access To Oracle DB

Jul 13, 2010

I have an Access DB which I'm using to connect to an Oracle DB at work. There are several Oracle DB's that I can connect to using Access but this one I'm not able to connect to. I get the Oracle error ORA-25153 Temporary Table Space is empty.

I don't have the ability to make changes to the Oracle DB only to read and query.

View 1 Replies View Related

Networking And Gateways :: ORA-03114 And ORA-03135?

Jul 5, 2012

When I run the below query, the session got the below errors exactly after 1 hour. I checked profile, resource limit, and sqlnet.expire_time. The SQLNET.EXPIRE_TIME value is 10. Except expire time there is time limit in profile and resource. I dont know how this session is losting connection exactly after 1 hour. What could be the issue here and what else need to check it?

14:34:09 SQL> << DELETE query >>
ERROR:
ORA-03114: not connected to ORACLE
DELETE FROM amsoftinstall

[code]...

SQL> select * from V$RESOURCE_LIMIT;

RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE
------------------------------ ------------------- --------------- ---------------------------------------- -------------------------
-------
processes 37 49 150 150
sessions 44 56 170 170

[code]...

SQL> select * from USER_RESOURCE_LIMITS;

RESOURCE_NAME LIMIT
-------------------------------- ----------------------------------------
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED

[code]...

View 1 Replies View Related

Networking And Gateways :: TNS-12542 / Address Already In Use

Aug 23, 2007

I'd got this error, TNS-12542, address already in used on my multithreaded application.

After finding some documents about this error, it happen because other application used same port as my listener. But i'd assured that only my listener, but it didn't happen in the first running process, but after some processes (hundreds of processes).

View 4 Replies View Related







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