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!

Leave a Reply

Your email address will not be published. Required fields are marked *