How to Start Database Oracle, Listener, and Enterprise Manager via Console

Mohon maaf jika ini adalah materi yang mendasar. Tetapi karena banyak yang masih menanyakan kepada saya perihal ini. Mending saya tulis saja deh. Berikut ini adalah cara manual via console bagaimana caranya untuk menaikkan database server dan juga enterprise manager-nya berikut juga listener-nya. Untuk lebih detail dapat merujuk ke dokumentasi Oracle-nya juga.

Terima Kasih.

 

Doddi-Priyambodos-MacBook-Pro:~ doddi$ ssh root@10.14.152.137 (sebaiknya langsung login menggunakan user oracle)
root@10.14.152.137’s password:
Last login: Tue May 22 14:08:27 2012 from 172.16.96.5
[root@db2 ~]# su – oracle
[oracle@db2 ~]$ ps -ax | grep oracle
Warning: bad syntax, perhaps a bogus ‘-‘? See /usr/share/doc/procps-3.2.7/FAQ
13437 ? Rl 8923:38 /oracle/oracle10g/jdk/bin/servertool
13446 ? Rl 8863:10 /oracle/oracle10g/jdk/bin/servertool
13455 ? Rl 8869:12 /oracle/oracle10g/jdk/bin/servertool
13464 ? Rl 8885:57 /oracle/oracle10g/jdk/bin/servertool
14565 pts/1 S 0:00 su – oracle
14595 pts/1 S+ 0:00 grep oracle
[oracle@db2 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 – Production on Thu May 31 12:17:35 2012

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

SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 8589934592 bytes
Fixed Size 2034520 bytes
Variable Size 2986345640 bytes
Database Buffers 5553258496 bytes
Redo Buffers 48295936 bytes
Database mounted.
Database opened.
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@db2 ~]$ emctl start dbconsole
TZ set to Asia/Jakarta
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://db2.batubara.icon:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control …………………….. started.
——————————————————————
Logs are generated in directory /oracle/oracle10g/db2.batubara.icon_phonix/sysman/log
[oracle@db2 ~]$

[oracle@db2 ~]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 31-MAY-2012 13:01:35

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /oracle/oracle10g/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 10.2.0.1.0 – Production
System parameter file is /oracle/oracle10g/network/admin/listener.ora
Log messages written to /oracle/oracle10g/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db2.batubara.icon)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db2.batubara.icon)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 – Production
Start Date 31-MAY-2012 13:01:37
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/oracle10g/network/admin/listener.ora
Listener Log File /oracle/oracle10g/network/log/listener.log
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db2.batubara.icon)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary…
Service “PLSExtProc” has 1 instance(s).
Instance “PLSExtProc”, status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully
[oracle@db2 ~]$

You’re DONE!

Silahkan Download Oracle Virtual Box Templates

Jika anda tidak mau repot untuk melakukan Instalasi produk-produk dari ORACLE, maka anda dapat langsung mengambil VirtualBox Template-nya saja. Secara otomatis sudah ter-install produk2 yang anda inginkan. Sangat cocok untuk environment Development, saya belum tau apakah cocok untuk Production (belum mencoba).

Bisa langsung di download disini =  http://www.oracle.com/technetwork/community/developer-vm/index.html

Nama VM = Database App Development VM 
Oracle Linux 5
Oracle Database 11g Release 2 Enterprise Edition
Oracle TimesTen In-Memory Database Cache
Oracle XML DB
Oracle SQL Developer
Oracle SQL Developer Data Modeler
Oracle Application Express 4.1
Oracle JDeveloper
Video chats with engineers and experts
Downloads and Instructions

Nama VM = Enterprise Java Development VM 
Oracle Linux 5, JDK 1.6 +
Oracle WebLogic Server 12.1.1
Oracle Coherence 3.7
Oracle TopLink 12.1.1
Hudson 2.2
Subversion 1.4.2
Maven 3.0.1
NetBeans IDE 7.1 RC2
Oracle Enterprise Pack for Eclipse 12.1.1 / Eclipse 3.7
Easter Egg: Bonus introductory labs for Coherence 3.7
Downloads and Instructions

Nama VM = Oracle VM Manager 3.0 VM 
Oracle Linux 5 update 7 with the Unbreakable Enterprise Kernel (2.6.32)
Oracle VM Manager 3.0.3 demo installation
Oracle WebLogic Server 10.3
Oracle Database 11g Express Edition
Download and Instructions

Nama VM = Solaris 11 Admin VM 
Oracle Solaris 11 11/11
Downloads and Instructions
Oracle WebCenter Portal Framework 11g Hands-on VM
Oracle Linux 5
Oracle XE Universal Database 10.2.0.1
Oracle WebLogic Server 10.3.4.0
Oracle WebCenter Portal Framework 11gR1 PS3 (11.1.1.4.0)
Oracle JDeveloper 11.1.1.4
Oracle WebCenter Extension for JDeveloper (11.1.1.4.0)
Downloads and Instructions

Nama VM = Oracle Tuxedo Web Application Server Demo V 
Oracle Linux 5.6
Oracle Tuxedo 11gR1 PS1 1 1(1.1.1.2.0)
Oracle SALT 11gR1 (11.1.1.2.2)
Oracle TSAM 11gR1 (11.1.1.2.0)
Oracle Database XE 10.2
PHP 5.3.6, xDebug extension
Apache HTTP Server 2.2.17
NetBeans PHP IDE 7.0 Beta
JDK 1.6 +
Downloads and Instructions

Nama VM = Oracle Business Intelligence Enterprise Edition Plus VM 
Oracle Database 11g Release 2
Oracle TimesTen
Essbase Server
Access Provisioning Services
OBIEE 11.1.1.5 with BI Composer configured SampleApp 10722
Oracle JDev
Oracle SQL Developer
Oracle Internet Directory
Downloads and Instructions

Nama VM = SOA & BPM Development VM 
Oracle Linux 5
Oracle Database XE 10.2
Oracle WebLogic Server 10.3.3.0
Oracle SOA Suite 11g R1 PS2
Oracle BPM Suite 11g R1 PS2 (with bundle patch #1)
Oracle BAM 11g R1 PS2
Oracle B2B 11g R1 PS2
Oracle JDeveloper 11.1.1.3
Downloads and Instructions

Nama VM = Enterprise PHP Development VM
(Provided and supported by Zend)
Oracle Linux 5.7
Zend Server 5.5
Oracle Database XE 11.2
Downloads and Instructions

Nama VM = Oracle Developer Days VB template for workshops
http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html

Oracle Linux 5
Oracle Database 11g Release 2 Enterprise Edition
Oracle TimesTen In-Memory Database Cache
Oracle XML DB
Oracle SQL Developer
Oracle SQL Developer Data Modeler
Oracle Application Express
Oracle JDeveloper
Hands-On-Labs (accessed via the Toolbar Menu in Firefox)