Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [sqlnet]

sqlnet is an Oracle configuration file. Use this tag only for questions that are about how to configure this file, or what particular options do to the Oracle configuration.

Sqlnet.ora is a text file that provides SQL*Net with basic configuration details like tracing options, default domain, encryption, etc. This file can be found in the ORACLE HOME\NETWORK\ADMIN directory.

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

server trace naming convention

I wanted to extract some information from the server trace file that is generated after I send a connect statement to the database. I wanted to know the naming convention for the server trace file. I could figure out that the name is in the below…
Shekhar Kanodia
  • 13
  • 4
1
vote
1 answer

SQL.EXPIRE_TIME in sqlnet.ora

I have set sql.expire_time parameter to 10 which recommends me to keep in my two node RAC database. At times, my application gets the error ORA-3135, therefore I suspect that this parameter could have some role to play here.. What exactly does this…
tesla747
  • 1,910
  • 10
  • 42
  • 77
0
votes
1 answer

How to see the client_registration strings of the connected Oracle-clients?

Because we run multiple instances of the same application on the dev-servers, I'm trying to add the sqlnet.client_registration-parameter to the sqlnet.ora-files used by each instance. This, I hope, would help us distinguish clients by the…
Mikhail T.
  • 166
  • 9
0
votes
1 answer

Oracle - Understanding Password Hash Versions

We ran into a problem, and so we're trying to understand all about the password versions. Here is what happened: We upgraded from 11g to 12c. Our sqlnet.ora had this parameter: SQLNET.ALLOWED_LOGON_VERSION = 8. Users were able to log in, using…
Landon Statis
  • 151
  • 2
  • 4
0
votes
1 answer

ORA-12631 using Database Links with Oracle DBMS 19c on Windows Server 2019

We had a set of long-time Oracle 12c Database installations (multiple instances on separate VMs) on Windows Server. Over the past year we transitioned to Oracle 19c on Windows Server 2019. We found that database links that worked in the 12c…
M Herbener
  • 213
  • 1
  • 8
0
votes
2 answers

Safe to use SQLNET.ALLOWED_LOGON_VERSION_SERVER in 11g sqlnet.ora file?

I have a mixed environment running both 11g and 12c databases on the same server. One of our databases was recently upgraded to 12c, and the older Oracle clients have started throwing ORA-28040 errors on connection attempts due to the use of older…
andba77
  • 569
  • 2
  • 6
  • 18
0
votes
1 answer

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 . Then I added a service name in my tnsnames.ora like…
Kurt Miller
  • 111
  • 1
  • 3
-1
votes
1 answer

How to use mariadb instead of sqlplus using sqlnet configuration files

currently I can access a database on a remote server using Oracle's instant client "sqlplus" The connection is dependent on a couple of configuration files in: $ORACLE_HOME/network/admin which are called sqlnet.ora and ldap.ora The ldap.ora file has…
aghsmith
  • 99
  • 1