Oracle Cheats Sheet
Oracle Cheats Sheet Managing Server Switch to oracle user # root # su oracle Start DB oracle$sqlplus /nolog SQL> conn sys/password as SYSDBA #to start database SQL> startup #to shutdown database immediately SQL> shutdown immediate SQL> exit Start Listner #oracle$LSNRCTL >start - to start >status - to check current status >stop Start Enterprise Manager Url: http://iPAdress:5500/em oracle$$ORACLE_HOME/bin/./emctl start dbconsole Start iSqlplus Url: http://iPAdress:5560/isqlplus oracle$$ORACLE_HOME/bin/./isqlplusctl start http://localhost:5560/isqlplus use "system" as user name and password given during installation How to connect to a remote Oracle server using Oracle Client: C:\Documents and Settings\User.Domain>sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Sat Oct 25 13:13:36 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: userName/password@iP...