# List current client connections lsof -i :1521 -P -n | grep ESTABLISHED
-- Database configuration EXEC DBMS_CONNECTION_POOL.CONFIGURE_POOL('SYS_DEFAULT_CONNECTION_POOL', MINSIZE=10, MAXSIZE=100); EXEC DBMS_CONNECTION_POOL.START_POOL(); linux oracle client
echo "/opt/oracle/instantclient_21_13" > /etc/ld.so.conf.d/oracle.conf ldconfig # List current client connections lsof -i :1521
export ORACLE_HOME=/opt/oracle/client export TNS_ADMIN=/opt/oracle/client/network/admin export PATH=$ORACLE_HOME/bin:$PATH echo "/opt/oracle/instantclient_21_13" >
PRODDB = (DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON) (ADDRESS = (PROTOCOL = TCP)(HOST = primary-host)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = standby-host)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = prodservice) (RETRY_COUNT = 3) (RETRY_DELAY = 5) ) )
cd $TNS_ADMIN vi tnsnames.ora
[1] Oracle Corporation. (2023). Oracle Database Net Services Administrator's Guide , 21c Edition. Redwood City, CA.
