My Oracle Notes
Posted by Pontus Ullgren on Saturday, 10 January 2009Here are some quick memos about Oracle. They are mostly here to be a place where I can refresh my memory.
== Start a Oracle databse instance ==
* Setup paths and SID
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=mysid
* Start TNS Listner
* Startup the instance
$ sqlplus "/ as sysdba" SQL*Plus: Release 9.2.0.8.0 - Production on Mon Dec 3 11:51:25 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to an idle instance. SQL> startup