Linux Oracle Client !!top!! May 2026

-- Database configuration EXEC DBMS_CONNECTION_POOL.CONFIGURE_POOL('SYS_DEFAULT_CONNECTION_POOL', MINSIZE=10, MAXSIZE=100); EXEC DBMS_CONNECTION_POOL.START_POOL(); -- Client connection string sqlplus user/pass@//host:1521/prodservice:POOLED

# Create OS user matching database schema useradd scott # Configure external naming in sqlnet.ora SQLNET.AUTHENTICATION_SERVICES = (BEQ, TCPS) # Connect without password sqlplus /@PRODDB linux oracle client

| Symptom | Root Cause | Resolution | |---------|------------|------------| | ORA-12170: TNS timeout | Firewall blocking port 1521 | Verify iptables rules: iptables -L -n | | ORA-12545: Host not found | DNS resolution failure | Use IP addresses in tnsnames.ora or set /etc/hosts | | ORA-28040: No matching auth | Protocol version mismatch | Set SQLNET.ALLOWED_LOGON_VERSION=8 in sqlnet.ora | | Library link error | Missing libaio or libnsl | yum install libaio libnsl | -- Database configuration EXEC DBMS_CONNECTION_POOL