Hot answers tagged

4 votes
Accepted

Significance of ".WORLD" on end of Oracle connection

.WORLD is a type of domain. You need it in tnsnames.ora if this is configured in your sqlnet.ora file (names.default_domain parameter). If this is not present in sqlnet.ora and you have it in tnsnames....
user avatar
  • 392
3 votes

SQL.EXPIRE_TIME in sqlnet.ora

That is for DCD (Dead Connection Detection). Dead Connection Detection SQLNET.EXPIRE_TIME If a client suddenly "disappears", e.g it's powered off, or loses network, the connection still remains ...
user avatar
  • 37.9k
2 votes

Oracle - Understanding Password Hash Versions

First, note that the SEC_CASE_SENSITIVE_LOGON parameter has been deprecated, and that Oracle is planning to force case-sensitive passwords in coming releases. SQLNET.ALLOWED_LOGON_VERSION determines ...
user avatar
  • 2,145
1 vote
Accepted

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

The parameter exists in 11g as well. This is the 11g documentation: SQLNET.ALLOWED_LOGON_VERSION Allowed Values 12 for the critical patch updates CPUOct2012 and later Oracle Database 11g ...
user avatar
  • 37.9k
1 vote

Unable to connect to pluggable database using TNS but EZCONNECT is OK

The problem is the TNS name which contains a leading whitespace. For example: [Whitespace]ORCLPDB = (DESCRIPTION = ... As we know, the @ in connection string should immediately followed by the ...
user avatar
  • 8,396
1 vote
Accepted

server trace naming convention

PID is the internal (to the database) ID of database processes. The SPID column contains the OS process ID, that is what you are looking for.
user avatar
  • 37.9k

Only top scored, non community-wiki answers of a minimum length are eligible