Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [tnsnames]

40 questions
109
votes
4 answers

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 = (PROTOCOL= TCP)(Host= hostname.network)(Port=…
Louis Rhys
  • 1,285
  • 4
  • 11
  • 8
6
votes
1 answer

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 and the server tnsnames.ora file must both have…
JustBeingHelpful
  • 2,116
  • 18
  • 45
  • 61
4
votes
1 answer

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.ora and tnsnames.ora based on an existing…
Achim Schmitz
  • 141
  • 1
  • 1
  • 5
4
votes
3 answers

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 know where the SID point? I have thought tnsnames.ora…
SangminKim
  • 359
  • 2
  • 7
  • 15
3
votes
6 answers

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 the connection string with hostname and port as…
Abhaya Ghatkar
  • 133
  • 1
  • 1
  • 5
2
votes
1 answer

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 when I'm trying to add standby database following…
Kenny
  • 377
  • 3
  • 8
  • 24
2
votes
1 answer

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 64-bit Windows: Version 11.2.0.4.0 - Production on…
Kenny
  • 377
  • 3
  • 8
  • 24
2
votes
2 answers

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 with clustered servers). This works fine. Now the…
grahamj42
  • 353
  • 2
  • 9
1
vote
1 answer

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

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
  • 176
  • 1
  • 9
1
vote
1 answer

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: db_recovery_file_dest_size of 10737418240 bytes is 100.00% used, and has…
MarkoA
  • 11
  • 1
1
vote
1 answer

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 had to be taken offline for a couple days. I've…
matt wilkie
  • 111
  • 5
1
vote
1 answer

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 Configuration Assistant, during the creation process I…
rainman
  • 205
  • 1
  • 4
  • 13
1
vote
0 answers

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 trying to add standby database following error is…
Kenny
  • 377
  • 3
  • 8
  • 24
1
vote
1 answer

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 instance 2 Oracle instance mirror 2 I cannot change…
Aks
  • 113
  • 1
  • 1
  • 4
1
vote
0 answers

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 32bit jdk1.6 with it, I couldn't uncheck it and I…
pisarik
  • 111
  • 4
1
2 3