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.

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

Oracle - Dispatchers parameter overwrite shared_servers and max_dispatchers?

I'm not understanding how to use these parameters. For example, when I set dispatchers parameter with (PROTOCOL=TCP) (dispatchers = 4) don't matter if shared_servers parameters is 0, the oracle ...
-1
votes
1answer
53 views

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 ...
0
votes
2answers
2k views

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 ...
0
votes
1answer
1k 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 . ...
1
vote
1answer
102 views

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 ...
1
vote
1answer
10k views

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 ...
3
votes
1answer
3k 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 ...