Questions tagged [tnsnames]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
3 answers
44 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 ...
user avatar
  • 506
-1 votes
1 answer
48 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, ...
user avatar
  • 1
0 votes
1 answer
845 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 ...
user avatar
3 votes
1 answer
11k 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....
user avatar
0 votes
1 answer
388 views

ORA-12518 and then TNS-12560, TNS-00534 and 64-bit Windows Error: 10022: Unknow Error when trying to connect to a cdb or a pdb (Oracle 12cR1)

I am seeking for help for a problem I try to resolve for a whole week. As the title say, I try to connect to a pdb or cdb and specifically using the @ statement. I created my instance named 'test', ...
user avatar
  • 1
0 votes
1 answer
480 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 ...
user avatar
0 votes
1 answer
365 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,...
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, ...
user avatar
0 votes
2 answers
3k 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 ...
user avatar
0 votes
1 answer
661 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 ...
user avatar
0 votes
1 answer
4k 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 ...
user avatar
0 votes
1 answer
552 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....
user avatar
  • 2,178
1 vote
1 answer
63 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
user avatar
1 vote
1 answer
295 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: ...
user avatar
  • 11
1 vote
1 answer
1k 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 ...
user avatar
0 votes
1 answer
1k 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 ...
user avatar
  • 111
0 votes
1 answer
689 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: [...
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 . ...
user avatar
0 votes
1 answer
752 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 ...
user avatar
1 vote
1 answer
7k 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 ...
user avatar
  • 175
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....
user avatar
  • 1
2 votes
1 answer
3k 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 ...
user avatar
1 vote
0 answers
796 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 ...
user avatar
2 votes
1 answer
321 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 ...
user avatar
0 votes
1 answer
12k 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 ...
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 ...
user avatar
0 votes
1 answer
6k 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 ...
user avatar
  • 103
3 votes
6 answers
67k 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 ...
user avatar
0 votes
1 answer
2k 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 ...
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 ...
user avatar
  • 111
2 votes
2 answers
779 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 ...
user avatar
  • 337
3 votes
3 answers
26k 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 ...
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 ...
user avatar
6 votes
1 answer
5k 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 ...
user avatar
  • 1,995
1 vote
0 answers
633 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 ...
user avatar
  • 31
0 votes
1 answer
5k 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-...
user avatar
0 votes
1 answer
804 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@(...
user avatar