Skip to main content
The 2024 Developer Survey results are live! See the results

Questions tagged [tnsnames]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
79 views

listener issues in oracle 19c

These are my listener.ora and tnsnames.ora files listener.ora SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = dr_DGMGRL) (ORACLE_HOME = /u01/app/oracle/product/19.0.0/...
datascinalyst's user avatar
0 votes
0 answers
56 views

I am having trouble creating a listener in Oracle 19C

These are my active services: SQL> SELECT NAME FROM V$ACTIVE_SERVICES; NAME ---------------------------------------------------------------- pdb3 orcldb pdb2 pdb1 and this is my listener.ora ...
dbafix's user avatar
  • 62
0 votes
1 answer
972 views

TLS Connection Looking For Wallet in Default Location despite using MY_WALLET_DIRECTORY

I'm finding hints here and there that this is a known issue, but just wanted to ask here directly to confirm. I have a typical client-server TLS connection. We have multiple database instances server-...
Jeff Bauersfeld's user avatar
0 votes
3 answers
1k views

Why tnsnames doesn't failover to standby database correctly?

I have this tnsnames: JUPITER = (DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = OFF) (FAILOVER = ON) (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.mercurio.sp)(PORT = 1521)) (ADDRESS ...
Astora's user avatar
  • 791
-1 votes
1 answer
138 views

I have error in one machine from ORACLE cluster

I am using Oracle 10g Cluster. So, the listener on 1 Oracle machine hasn't been working for a week now. I get an error: ORA-12541: TNS:no listener When I want to start listener from oracle user, ...
Vasyl's user avatar
  • 1
0 votes
1 answer
5k views

Connection to Oracle DB 19c fails when listener is set to the host IP address

I am new to Oracle DB and need help in solving the following issue. I am using sqlplus (SQL*Plus: Version 21.1.0.0.0) to connect to the Oracle DB 19c. Statement: I am able to connect to the Oracle DB ...
Janmenjoy Roy's user avatar
4 votes
1 answer
32k views

Oracle 19c database instance doesn't register with listener

I have just installed an oracle 19c (19.3.0.0.0 to be exact) database on a centOS 8 virtual machine. The databases instances can all be started with sqlplus on the host machine. I have set up listener....
Achim Schmitz's user avatar
0 votes
1 answer
924 views

SSMS Linked Server -ORA-28009: connection as SYS should be as SYSDBA or SYSOPER (Microsoft SQL Server, Error: 7303)

How could I use "Linked Server" from SSMS IDE to connect the Oracle server database with "SYSDBA"? I've tried many methods as following to show you what I did right now: Oracle client connect to ...
Willie Cheng's user avatar
0 votes
1 answer
693 views

I want to delete connections in tnsnames.ora. I need to figure out which ones are currently in use, so that I don't delete them mistakenly

I'm using Oracle 12c in Debian 8 (on a vm) This question is for educational purposes only. I'm not using any production servers, so anything that you can tell me won't have consecuences To start with,...
Adrián Jaramillo's user avatar
0 votes
1 answer
1k views

How can I connect to an Oracle Autonomous Data Warehouse with a 3rd party IDE (DataGrip)?

I'm trying to connect to a Oracle Autonomous Data Warehouse database with Jetbrains DataGrip. Oracle provides me with a wallet file (a zip), with contains tnsnames.ora, a keystore, ojdbc.properties, ...
honeybees's user avatar
0 votes
2 answers
6k views

Modify TNSNAMES.ORA file to connect to an Oracle Database

I would like to modify TNSNAMES.ORA file to connect to an ORACLE Database and I noticed that on my PC there are 3 different files with name TNSNAMES.ORA files. Which of these three should I modify in ...
Error 1004's user avatar
0 votes
1 answer
2k views

How to get TNS connect strings (like tnsping) to check a dblink via a session?

I would like to know, if there is any chance to get the currently used TNS connect string, that will be used for a DB-Link from a db-server. I'm connected to a schema on a database located on any ...
D. Lohrsträter's user avatar
0 votes
1 answer
7k views

Getting TNS Name from connection string

I normally connect to my Oracle database at work using a connection string. Other then the obvious answer of asking the DBA what it is, using SQL Developer or some other tool can I find out what the ...
logixologist's user avatar
0 votes
1 answer
898 views

use SQLcl with EZconnect and multiple hostnames (ADDRESS_LIST=)

this is our classic tnsnames.ora test1= (DESCRIPTION= (CONNECT_TIMEOUT=4) (TRANSPORT_CONNECT_TIMEOUT=3) (ENABLE=BROKEN) (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=example1....
Sybil's user avatar
  • 2,548
1 vote
1 answer
158 views

Why is tnsping not reliable from ports 20, 21, 22? [closed]

I think it's not reliable because those ports are used for FTP, SSH and SFTP but I am not sure that's the correct response in respect for Oracle DBA
GettingStarted's user avatar
1 vote
1 answer
390 views

ORA-19815, ORA-01031 and ORA-12514 error

I have Linux RedHat Enteprise with Oracle 11g database and I've stumbled upon a circle of errors and I can not find a way out. First error in alert_XE.log: ORA-19815: WARNING: ...
MarkoA's user avatar
  • 11
1 vote
1 answer
2k views

TNS_ADMIN / TNSNAMES location failover

Is there a way to have multiple tnsnames.ora locations defined? We currently use a server path like TNS_ADMIN=\\192.168.1.100\infosys\oracle\tnsnames but are in a situation this week where that server ...
matt wilkie's user avatar
0 votes
1 answer
2k views

Error remote connection from Oracle 11g

I am trying to connect to my Oracle Database 11g from another computer connected in the same network. In the connection data I put the address of the server machine, but it does not allow me the ...
Ventur's user avatar
  • 111
0 votes
1 answer
877 views

Connect analysis services to oracle database

I am looking to connect analysis services to an oracle database, and when I hit Process in AS, it gives me a generic Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [...
soandos's user avatar
  • 157
0 votes
1 answer
3k views

Unable to connect to pluggable database using TNS but EZCONNECT is OK

I installed oracle 12c pn windows following the defaults settings... I end up with ORCL and ORCLPDB... I can connect to ORCLPDB using EZCONNECT via CONN system/password@//localhost:1521/ORCLPDB . ...
Kurt Miller's user avatar
0 votes
1 answer
1k views

Why I can tnsping Server P from Server A but cannot tnsping Server P from Server B?

Here is my situation: I can ping P from both server A and Server B. But I just can tnsping Server P from A but not from B. I checked the tnsnames.ora of A and B. They are identical. And I can tnsping ...
DBALUKE HUANG's user avatar
1 vote
1 answer
9k views

Unable to connect to pluggable database in Oracle 12c

I have oracle database Oracle Database 12c Enterprise Edition 12.2.0.1.0, and I created a pluggable database named DEVDB to use it in web application development, I created it using the Database ...
rainman's user avatar
  • 195
0 votes
1 answer
2k views

Connect Oracle Database 12c via SQL Developer when it is in restricted mode

I would like to connect to database 12c via SQL Developer(in same VM where db is hosted) when it is in restrict mode. Tried below approaches but nothing worked. Kindly help ! Added (UR=A) in tnsname....
Gaurav's user avatar
  • 1
2 votes
1 answer
4k views

When trying to configure data guard broker I'm getting Error: ORA - 12154 : TNS: could not resolve the connect identifier specified

I'm trying to setup data guard broker in my production instance. I have duplicated the primary database to standby database successfully. I've added primary database to data broker configuration and ...
Enthusiastic learner's user avatar
1 vote
0 answers
1k views

When trying to configure data guard broker I'm getting Error: ORA-16606: unable to find property ""

I'm trying to setup data guard broker in my production instance. I have duplicated the primary database to standby database successfully. I've added primary database to my configuration and when I'm ...
Enthusiastic learner's user avatar
2 votes
1 answer
449 views

Listener is not starting in my Standby database

I'm facing a serious issue in data guard installation. I'm setting oracle_sid and oracle_home and when I start the listener,error is showing as below: C:\Windows\system32>lsnrctl start LSNRCTL for ...
Enthusiastic learner's user avatar
0 votes
1 answer
13k views

ORA-12504: TNS:listener was not given

I created container orcl2 database with pluggable database pdborcl2. When I try to connect SQL> connect system@pdborcl2 I get this error: ORA-12504: TNS:listener was not given the ...
Bart Ch.'s user avatar
0 votes
1 answer
2k views

can not connect to oracle database with ip address

I am new to oracle database, I have installed Oracle 11.g on redhat 5.6, I have a database that I can connect to it using the following command: export ORACLE_SID=test sqlplus user/passwd but not ...
ayyoob imani's user avatar
1 vote
1 answer
9k views

Multiple service_name and hosts with same alias

I am currently working on a duplicated infrastructure like this : We have two data server, with two database on each. Server 1 Oracle instance 1 Oracle instance mirror 1 Server 2 Oracle ...
Aks's user avatar
  • 113
3 votes
6 answers
71k views

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

I have configured oracle 12c on Rhel 7. When I try to connect database using following command it gets connected with no issues: sqlplus system/Forest123@orcl I'm facing problem when I try to put ...
Abhaya Ghatkar's user avatar
0 votes
1 answer
3k views

TNS Issue with error

I have a Issue in Oracle I have made two database one for Demo and one for Dev for same mount point. When I connect with Demo this can be connected but when I try to connect with DEV its not able ...
suhail's user avatar
  • 1
1 vote
0 answers
2k views

Oracle Forms 11g R2 connect to Oracle 11g

Thank in advance! I have 64bit Windows 7 with installed Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit. I installed Oracle WebLogic 10.3.6 how it described here. But it's install ...
pisarik's user avatar
  • 111
2 votes
2 answers
871 views

Modify linked server definition (Oracle) in SQL Server 2012

I have created a linked Oracle server in SQL Server 2012 using Oracle Provider for OLE DB and TNSNAMES.ORA (the Oracle database is clustered and, as far as I know, no other connection method works ...
grahamj42's user avatar
  • 353
4 votes
3 answers
28k views

How can sqlplus knows where ORACLE_SID point?

As I understand, SID is unique value to identify an Oracle database instance. And I can set default database instance sqlplus use by changing ORACLE_SID environment variable. But how can sqlplus ...
SangminKim's user avatar
1 vote
2 answers
1k views

Oracle connection through visual studio

I installed oracle client 11.2.0 version in my machine and also installed Oracle data access providers for visual studio.I also installed Oracle Data Access 11.2.0.3.20. I am trying to connect to the ...
Triandh Velchuri's user avatar
6 votes
1 answer
7k views

Significance of ".WORLD" on end of Oracle connection

What is the significance of having ".WORLD" on the end of an Oracle connection name? I've found things to still connect without that suffix. I've also noticed that both the client tnsnames.ora file ...
JustBeingHelpful's user avatar
1 vote
0 answers
805 views

Fail to perfom static registration of nomount instance

I'm trying to make standby to database. I've insalled Oracle 11g database on virtual machine (host - oratest). Standby is on virtual machine too (standbysrv). When I'm trying to connect from source ...
kozlone's user avatar
  • 31
0 votes
1 answer
6k views

Cannot connect using tnsnames.ora but can connect by substituting its details

I'm setting up a minimal Oracle Instant Client on a non-Oracle Linux host from zip files (as per https://docs.oracle.com/database/121/SQPUG/apd.htm#SQPUG157) and have installed instantclient-...
Joe Creighton's user avatar
0 votes
1 answer
933 views

Oracle: converting a TNS entry with SID to instantclient?

How do I convert a TNS entry that has a SID to instantclient format? I'm able to connect with a TNS string but not with the equivalent (I thought!) instantclient string. $ ./sqlplus 'myname/mypass@(...
Mark Harrison's user avatar
107 votes
4 answers
991k views

How to use sqlplus to connect to an Oracle Database located on another host without modifying my own tnsnames.ora

I want to connect to an oracle database located on another host using sqlplus. This page suggested adding an item on my tnsnames to connect to that database local_SID = (DESCRIPTION = (ADDRESS = ...
Louis Rhys's user avatar
  • 1,265