Install Oracle 11g on Linux

Thursday, October 30 2008 at 16:30, posted by Norman

1. install oracle 11g:
Here is a great instruction on how to install Oracle 11g on Fedora 9.
2. management:
2.1 to login as sys adminstrator:

$ sqlplus "/ AS SYSDBA"

2.2 create new user:

CREATE USER "user_name" PROFILE "DEFAULT" IDENTIFIED BY "*******" DEFAULT TABLESPACE "NZENG" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK 
GRANT "CONNECT" TO "NZENG"
GRANT CREATE SESSION TO "NZENG" (needed for any user)

3. manage system with enterprise manager:

$ORACLE_HOME/bin/ emctl start dbconsole

In Firefox: f9.localdomain:1158/em
server->security
4. run oralce

dbora start
	sqlpluse uid/pwd@db