[root@localhost ~]# su - oracle[oracle@localhost ~]$ sqlplus / sysdba;*Plus: Release 11.2.0.3.0 Production Fri Jul 13 22:22:59 2018Copyright (c) 1982, 2011, Oracle. rights reserved.Connected :Oracle 11g Enterprise Edition Release 11.2.0.3.0 - Production the Partitioning, OLAP, Data Mining Application Testing optionsSYS@orcl> instance_name ,status v$instance;INSTANCE_NAME STATUS---------------- ------------orcl SYS@orcl> quitDisconnected Oracle 11g Enterprise Edition Release 11.2.0.3.0 - Production the Partitioning, OLAP, Data Mining Application Testing options[oracle@localhost ~]$ logout[root@localhost ~]# who am iroot pts/10 2018-07-13 22:22 (192.168.242.1)[root@localhost ~]# useradd oracleexternal[root@localhost ~]# passwd oracleexternalChanging password oracleexternal.New UNIX password:Retype new UNIX password:passwd: authentication tokens updated successfully.[root@localhost ~]# su - oracleexternal[oracleexternal@localhost ~]$ cat .bash_profile# .bash_profile# the aliases functions [ -f ~/.bashrc ]; . ~/.bashrcfi# specific environment startup programsPATH=$PATH:$HOME/binexport PATH[oracleexternal@localhost ~]$ vi .bash_profile# .bash_profile# the aliases functions [ -f ~/.bashrc ]; . ~/.bashrcfi# specific environment startup programsPATH=$PATH:$HOME/binexport PATHexport ORACLE_SID=orclexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export PATH=$PATH:$ORACLE_HOME/binexport ORACLE_TERM=xtermexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/libexport CLASSPATH=$ORACLE_HOME/JRE:ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib~~~~~~".bash_profile" 20L, 479C written[oracleexternal@localhost ~]$ cat .bash_profile# .bash_profile# the aliases functions [ -f ~/.bashrc ]; . ~/.bashrcfi# specific environment startup programsPATH=$PATH:$HOME/binexport PATHexport ORACLE_SID=orclexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export PATH=$PATH:$ORACLE_HOME/binexport ORACLE_TERM=xtermexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/libexport CLASSPATH=$ORACLE_HOME/JRE:ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib[oracleexternal@localhost ~]$ source .bash_profile[oracleexternal@localhost ~]$ su - oraclePassword:[oracle@localhost ~]$ rlwrap sqlplus / sysdba;*Plus: Release 11.2.0.3.0 Production Fri Jul 13 22:25:45 2018Copyright (c) 1982, 2011, Oracle. rights reserved.Connected :Oracle 11g Enterprise Edition Release 11.2.0.3.0 - Production the Partitioning, OLAP, Data Mining Application Testing optionsSYS@orcl> show parameter osNAME TYPE ------------------------------------ ----------- ------------------------------db_lost_write_protect string diagnostic_dest string /u01/app/oracleoptimizer_index_cost_adj 100os_authent_prefix string ops$os_roles boolean remote_os_authent boolean remote_os_roles boolean timed_os_statistics 0SYS@orcl> ops$oracleexternal identified externally; created.SYS@orcl> ops$oracleexternal; succeeded.SYS@orcl> quitDisconnected Oracle 11g Enterprise Edition Release 11.2.0.3.0 - Production the Partitioning, OLAP, Data Mining Application Testing options[oracle@localhost ~]$ logout[oracleexternal@localhost ~]$ who am[oracleexternal@localhost ~]$ whoamioracleexternal[oracleexternal@localhost ~]$ sqlplus /*Plus: Release 11.2.0.3.0 Production Fri Jul 13 22:27:16 2018Copyright (c) 1982, 2011, Oracle. rights reserved.Connected :Oracle 11g Enterprise Edition Release 11.2.0.3.0 - Production the Partitioning, OLAP, Data Mining Application Testing optionsOPS$ORACLEEXTERNAL@orcl>OPS$ORACLEEXTERNAL@orcl> ;22:29:13 OPS$ORACLEEXTERNAL@orcl>