Sunday, September 15, 2013

Oracle start and login remotly

login as: root
root@192.168.1.104's password:
Last login: Mon Sep  9 07:07:22 2013 from 192.168.1.103
[root@localhost ~]# ls
anaconda-ks.cfg  Documents  install.log         Music     Public     t -x
Desktop          Downloads  install.log.syslog  Pictures  Templates  Videos
[root@localhost ~]# /etc/init.d/oracle-xe start
Starting Oracle Net Listener.
Starting Oracle Database 11g Express Edition instance.

[root@localhost ~]# sqlplus system
-bash: sqlplus: command not found
[root@localhost ~]# echo $ORACLE_HOME

[root@localhost ~]# /u01/app/oracle/product/11.2.0/xe
-bash: /u01/app/oracle/product/11.2.0/xe: is a directory
[root@localhost ~]# . /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
[root@localhost ~]# /u01/app/oracle/product/11.2.0/xe
-bash: /u01/app/oracle/product/11.2.0/xe: is a directory
[root@localhost ~]# echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/xe
[root@localhost ~]# sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Sun Sep 15 11:33:03 2013

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

Enter user-name: sakib
Enter password:

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

SQL>