# Create OS user matching database schema useradd scott # Configure external naming in sqlnet.ora SQLNET.AUTHENTICATION_SERVICES = (BEQ, TCPS) # Connect without password sqlplus /@PRODDB
Three deployment strategies exist: | Method | Use Case | Pros | Cons | |--------|----------|------|------| | RPM (Oracle Linux Yum) | Managed environments | Automatic dependency resolution | Requires subscription | | ZIP (Instant Client) | Air-gapped systems | Portable, no root required | Manual lib linking | | Docker | Microservices | Isolation, version pinning | Overhead for persistent connections | linux oracle client
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) ) ) For performance troubleshooting: # Create OS user matching database schema useradd