Questions tagged [tnsnames]
The tnsnames tag has no usage guidance.
39
questions
0
votes
0
answers
42
views
I am having trouble creating a listner in Oracle 19C. Some help will be appreciated
These are my active services:
SQL> SELECT NAME FROM V$ACTIVE_SERVICES;
NAME
----------------------------------------------------------------
pdb3
orcldb
pdb2
pdb1
and this is my listener.ora ...
- 54
0
votes
1
answer
607
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-...
- 183
0
votes
3
answers
834
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 ...
- 630
-1
votes
1
answer
106
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, ...
- 1
0
votes
1
answer
3k
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 ...
3
votes
1
answer
23k
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....
- 131
0
votes
1
answer
811
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 ...
- 271
0
votes
1
answer
607
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,...
- 127
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, ...
0
votes
2
answers
5k
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 ...
- 127
0
votes
1
answer
1k
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 ...
- 180
0
votes
1
answer
6k
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 ...
- 115
0
votes
1
answer
812
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....
- 2,448
1
vote
1
answer
143
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
- 176
1
vote
1
answer
365
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: ...
- 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 ...
- 111
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 ...
- 111
0
votes
1
answer
821
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: [...
- 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 . ...
- 111
0
votes
1
answer
993
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 ...
- 429
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 ...
- 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....
- 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 ...
1
vote
0
answers
964
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 ...
2
votes
1
answer
397
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 ...
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 ...
- 37
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 ...
- 103
1
vote
1
answer
8k
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 ...
- 113
3
votes
6
answers
69k
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 ...
- 133
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 ...
- 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 ...
- 111
2
votes
2
answers
837
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 ...
- 345
3
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 ...
- 329
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 ...
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 ...
- 2,072
1
vote
0
answers
760
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 ...
- 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-...
- 133
0
votes
1
answer
921
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@(...
- 819
104
votes
4
answers
958k
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 = ...
- 1,235