Starting oracle listener
$ lsnrctl startStart the database
$ dbstartStarting oracle Enterprise manager
$ emctl start dbconsole
Shutting down the database
$ dbshut
Stopping the listener
$ lsnrctl stop
Stopping oracle Enterprise manager
$ emctl stop dbconsole
Starts sqlplus without logging in to a database
# su oracle
$ sqlplus /nolog
Logging into default oracle db
$ sqlplus system/oracle11@pfdb
The automatic startup and shutdown of the Oracle database can be achieved with the files dbstart and dbshut both provided by Oracle. These files rely on the existance of the file /etc/oratab to work
$ cat /etc/oratab
orcl:/u01/app/oracle/product/10.2.0/db_1:Y
The first field is the name of my database (orcl), the second one is my home directory
(/u01/app/oracle/product/10.2.0/db_1), and the third indicates to the dbstart utility whether the database should, or should not be brough up at the system boot time with "Y" or "N" parameters respectively. As root user, we'll change last field of this line from "N" to "Y" to let dbstart utility start this database when it runs.
Terima kasih telah membaca artikel tentang Oracle DB startup Scripts di blog Tutorial Opensource and Linux jika anda ingin menyebar luaskan artikel ini di mohon untuk mencantumkan link sebagai Sumbernya, dan bila artikel ini bermanfaat silakan bookmark halaman ini di web browser anda, dengan cara menekan Ctrl + D pada tombol keyboard anda.