berbagisolusi
Archive for
Backup Oracle Pump using batch DOS command
create file (example : exportday.bat) write file with this script: @echo off echo Start export Data …. sqlplus system/oracle10g@live @export.sql echo Create DMP File …. ExportDayLog.bat echo Export finished exit then create file export.sql. with SQL script: set heading off spool ExportDayLog.bat select ‘exp system/oracle10g@live full=yes file=backup_’||to_char(sysdate,’ddmmrrrrhh24miss’) from dual; spool off exit File result will … Continue reading
Starting the Oracle Enterprise Manager Console
Before starting OEM Oracle web version starting OEM service : 1. Run > type “cmd” > 2. c:\> emctl start dbconsole 3. Open your browser and type on address : http://<host>:1158/em/console/aboutApplication ___________________________________________________________________ Starting the Oracle Enterprise Manager Console To access the Oracle Enterprise Manager Console from a client browser, the dbconsole process needs to be … Continue reading
Getting URL Page in Asp Classic
Place this script on top your page : prot = “http” https = lcase(request.ServerVariables(“HTTPS”)) if https <> “off” then prot = “https” domainname = Request.ServerVariables(“SERVER_NAME”) filename = Request.ServerVariables(“SCRIPT_NAME”) querystring = Request.ServerVariables(“QUERY_STRING”) response.write prot & “://” & domainname & filename & “?” & querystring
Oracle, TNS Listener Error in Windows
If you have those problem, follow this intruction : Solution A. Set Database and restart listener – open cmd command ( start menu > run > type “cmd” <enter>) – C:\> set ORACLE_SID=YOUR_ORACLE_DB – C:\>lsnrctl stop – C:\>lsnrctl start – open windows service and starting Service[YOUR_ORACLE_SERVICE] start menu > run > type “services.msc” <enter> Solution … Continue reading
Musing and Motivation
SIKAP Semakin lama saya hidup, semakin saya sadar Akan pengaruh sikap dalam kehidupan Sikap lebih penting daripada ilmu, daripada uang, daripada kesempatan, daripada kegagalan, daripada keberhasilan, daripada apapun yang mungkin dikatakan atau dilakukan seseorang. Sikap lebih penting daripada penampilan, karunia, atau keahlian. Hal yang paling menakjubkan adalah Kita memiliki pilihan untuk menghasilkan sikap yang kita … Continue reading
Web Statistic
berbagisolusi 