You have to provide the ‘Log on as a batch job’ privilege: 1. Go to control panel/administrative tools a. click on “local security policy” b. click on “local policies” c. click on “user rights assignments” d. double click on “log on as a batch job” e. click on “add” and add the user that was … Continue reading
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
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
Example Oracle job schedule : BEGIN DBMS_SCHEDULER.CREATE_JOB( job_name => ‘bt_auto_schedule’, job_type => ‘STORED_PROCEDURE’, job_action => ‘bt_job’,–procedure name start_date => TO_TIMESTAMP_TZ(’30-DEC-2008 00:00:00′,’DD-MM-YYYY HH24:MI:SS’), repeat_interval => ‘FREQ = DAILY; INTERVAL = 1’); END; / BEGIN dbms_scheduler.enable(‘bt_auto_schedule’); END; / — List all existing jobs: SELECT * FROM all_scheduler_jobs; — Disable temporary a job: BEGIN dbms_scheduler.disable(‘populate_nodes’, TRUE); END; / … Continue reading
Installing Oracle 10g database software : Insert Oracle CD , the autorun window opens automatically. If you are installing from network or hard disk, click setup.exe in the installation folder. The Oracle Universal Installer (OUI) will run and display the Select Installation Method Window. Choose Basic Installation: Select this option to quickly install Oracle Database … Continue reading
A. Installing IIS (IIS 6.0) _____________________ This topic describes 3 methods for installing IIS: • Using the Configure Your Server Wizard. • Using Add or Remove Programs from Control Panel. • Using unattended setup. This topic also lists the directories created on install, describes the IIS initial configuration backup, and briefly describes IIS optional components. … Continue reading
The syntax for the FOR Loop is: FOR loop_counter IN [REVERSE] lowest_number..highest_number LOOP {.statements.} END LOOP; You would use a FOR Loop when you want to execute the loop body a fixed number of times. Let’s take a look at an example. FOR Lcntr IN 1..20 LOOP LCalc := Lcntr * 31; END … Continue reading
**USING ROWNUM Oracle has a system attribute ROWNUM for each record returned. A query that only returns the first 20 records would look like the one in the example. ROWNUM starts counting with 1. // mysql select col from tbl limit 20; // Oracle select col from tbl where rownum<=20; // Microsoft SQL select top … Continue reading