Remote SSH connection to Linux to configure Oracle sqlplus Environment Variables

Run the sqlplus command in SSH Secure Shell. If the SQL plus command cannot be found, the Oracle environment variable is not configured. The configuration method is as follows: Find the. bash_profile file (Note: This configuration environment variable method is only valid for the current user, available cd ~ Command to enter the root directory)Set oracle environment variables: PATH = $ PATH: $ HOME/bin: $ ORACLE_BASE: $ ORACLE_HOMEexport PATHexport ORACLE_BASE =/app/oracleExport ORACLE_HOME = $ ORACLE_BASE/product/10.2/db_1Export PATH = $ ORACLE_HOME/bin: $ PATH save and exit. Run source. bash_profile
Run again:Sqlplus user/password @ SERVICE_NAME will connect to the specified database. If you want to log on to the dba, enter the password after sys as sysdba.You can.