Remote SSH connection to Linux to configure Oracle sqlplus Environment Variables

Execute the sqlplus command in SSHSecureShell. If the SQL plus command cannot be found, the oracle environment variable is not configured. The configuration method is as follows: Find. ba under the root directory of the current user

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. ba under the root directory of the current user

If you cannot find the sqlplus command in SSH Secure Shell, even if 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 as follows:

PATH = $ PATH: $ HOME/bin: $ ORACLE_BASE: $ ORACLE_HOME

Export PATH

Export ORACLE_BASE =/app/oracle

Export ORACLE_HOME = $ ORACLE_BASE/product/10.2/db_1

Export 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.