Create Start and Stop Batch Oracle 10g Windows

Posted on

Cara membuat start dan stop batch oracle 10g Windows [Create Start and Stop Batch Oracle 10g Windows] – kali saya hadir lagi dengan bahasan yang seputar oracle DBMS , yaitu cara membuat file *.bat yang digunakan untuk membuat start dan stop services oracle.
karena banyak kawan saya yang mengeluh setelah install oracle proses startup PC/laptop nya terasa lama dan berat. nah kali ini salah satu trik dengan membuat services manual yang bisa dijalankan di desktop depan. daripada lama langsung ke TKP… yaaaaaaa ee…

first step : open services – click windows+R > search services
second step : open notepad or notepad++, copy this syntax “start oracle”

@echo OFF
ECHO Oracle sedang proses memulai oracleDB
NET start OracleDBConsoleorcl
NET start OracleOraDb10g_home1iSQL*Plus
NET start OracleOraDb10g_home1TNSListener
NET start OracleServiceORCL
if ERRORLEVEL 1 goto error
exit
:error
echo There was a problem
pause

note : services-name view on service

third step : save as to desktop > name start_oracle.bat > type file : all files

fourth step : copy this syntax “stop oracle” to notepad

@echo OFF
ECHO sedang proses offline oracleDB
NET stop OracleDBConsoleorcl
NET stop OracleOraDb10g_home1iSQL*Plus
NET stop OracleOraDb10g_home1TNSListener
NET stop OracleServiceORCL
if ERRORLEVEL 1 goto error
exit
:error
echo There was a problem
pause

return to third step and change name “stop_oracle.bat”
fifth step : change type ” automatic” to “manual”

finish step : restart your PC/Laptop

!note : for run file batch , always Run as Administrator

download file start and stop oracle batch [ pass rar : fieyanh.blogspot.com ]

selamat mencoba………….

Gravatar Image
Suka jalan-jalan, naik sepeda, bermain code-code asal tidak suka mengkode cinta. Hubungi email : andhika.na@gmail.com jika anda butuh website untuk personal maupun bisnis.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.