Here is the command to connect to Oracle XE 11.2 (Express Edition) in SQL/Plus editor:

SQL> connect system/system@XE
Connected.
SQL>

In Command line you can use this command:

1. Change to ‘oracle’ user : su – oracle

2. Set Environment variables:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export PATH=$ORACLE_HOME/bin:$PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin

3. Then issue following command at shell prompt:

[localhost@m114116 ~]$ sqlplus system/system@XE

SQL*Plus: Release 11.2.0.2.0 Production on Mon Nov 7 07:11:04 2016

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 – 64bit Production

SQL>

Note that here my password is ‘system’ which can differ from your installation.

Advertisements