Server Administration :: Job Not Running On Defined Schedule

Jul 24, 2012

I migrate schema with data from oracle 10gR2(Windows) to oracle RAC 11gR2 (Linux).My JOBS are created but they are not running on defined schedule. but they run manually successful.

----script of my job are as below --------

BEGIN
SYS.DBMS_SCHEDULER.DROP_JOB
(job_name => 'JHON.TAX_IT);
END;
/
[code]...

View 6 Replies


ADVERTISEMENT

SQL & PL/SQL :: Scheduled Job Not Running As Per Schedule

Aug 30, 2011

I have set up two scheduled jobs in oracle 11g for executiong a procedure in specific time intervals. One as Hourly and other as minutely.But the scheduled jobs are not running as per schedule. i.e the minutely job is not running every minute. But If i see the run logs for some period it would have run every minute, and suddenly it will not execute and give a gap of 30 mins or 1 hour and then run again.

P.s. The job priority is set as 3. and except for these two jobs there are no other jobs set. But this is an important job which needs to be run every minute.

JOB_QUEUE_PROCESSES is set to 1000, which is max. And there are only 3 scheduled jobs in the whole DB.
BEGIN
SYS.DBMS_SCHEDULER.CREATE_JOB
(
job_name => 'LOGTBLPURGE'

[code]....

View 2 Replies View Related

Server Administration :: How To Know Currently Running Databases In Single Server

Jul 30, 2010

I have installed three database in MY Linux server. I have started Instance for all database and started database also .

No I want to check my databases status or currently running database How can I know . Or which Dynamic View or Database dictionary I should use ?

View 2 Replies View Related

Server Administration :: Dba_jobs Stopped Running

Feb 19, 2011

I have a dba_job that is scheduled to run every hour and for the past couple of weeke it is behaving strangely. It fails running every alternate hour. I have checked the alert log whenever it fails but nothing is reported in the alert log. The job is not broken.

View 4 Replies View Related

Server Administration :: Why Oracle Scheduler Is Not Running

May 14, 2013

Why Oracle shceduler is not running.What could be the cause.

CREATE TABLE dept1 AS SELECT * FROM dept;
CREATE OR REPLACE
procedure update_record(p_deptno number)is
BEGIN
insert into dept1 values(p_deptno,'xxx','xxx');
end;

[code]....

View 15 Replies View Related

Server Administration :: ORA-01034 While Running Dbca

May 27, 2011

I hv created a database VAHAN with SID VAHAN , now I want to create another database in it with name SARATHI SID SARATHI.VAHAN db is running perfectly but everytime i tried to create the db with dbca it shows error "ORA-01034: ORACLE not avaiable."

I ran dbstart,lsnrctl start - getting same error..i dbshut the db and use startup nomount - getting same error.

View 3 Replies View Related

Server Administration :: DBMS Scheduler Jobs Are Not Running

Jan 12, 2011

I have scheduled few jobs (scheduled for each day) which has not run today, which was running successfully till yesterday. When I query dba_scheduler_jobs, i could see last_run_date as yesterday's date 6am and next_run_date is still showing today's date and time (it should show tomorrow's date/time).

View 3 Replies View Related

Server Administration :: Running DBCA In Silent Mode

Jan 27, 2012

I'm trying to run dbca in silent mode and works perfect, this is how the code look like:

dbca -silent -createDatabase -templateName Transaction_Processing.dbc -gdbName test.mydomain -sid test
-sysPassword passoracle -systemPassword passoracle -emConfiguration LOCAL -dbsnmpPassword passoracle
-sysmanPassword passoracle -characterSet WE8ISO8859P1
-initParams "open_cursors=500"

The problem is when I specify more than one initialization parameter in -initParams. If I try something like

-initParams "open_cursors=500, parallel_max_server=0"

Then I get this error Exception in thread "main".

View 3 Replies View Related

Server Administration :: Session Inactive But Running Queries?

Mar 4, 2010

I am using 10.2.0.4 oracle database on Solaris 10. We are running some Peoplesoft upgrade on one of the database from last 6-7 hours. The status of the session is INACTIVE from couple of hours. And the sql_id is null for these sessions.

select sid,serial#,STATUS,to_char(logon_time,'DD-MON_YY HH24:MI:SS') from v$session where username like '%&usern%' ORDER BY 4 DESC;
533 2234 INACTIVE 04-MAR_10 01:59:02
525 5919 ACTIVE 04-MAR_10 01:54:50
534 4186 INACTIVE 04-MAR_10 01:05:15
520 2320 INACTIVE 04-MAR_10 00:29:44

[code].....

While when i see the current sql from the v$active_session_history, it keep on changing after every 10-15 minutes. Using below query to find the sql_text for the session from v$active_session_history.

select sql_id, sql_text
from v$sql
where sql_id in (
select sql_id
from v$active_session_history
where session_id=511

[code].....

We have not faced issue like this during Peoplesoft upgrade. what could be the reason that the status is not changing while the base sqls keep on changing after every 10 minutes.

View 8 Replies View Related

Server Administration :: Running Out Of Space For Archive File System

Apr 2, 2012

In normal days size of archives generated in a day is 14-15GB. But since yesterday morning, almost 150GB of archives have been generated and are still getting generated(200MB every 1-2 minutes).

There was a sudden reboot of server yesterday morning. At that time there was heavy load of transactions on database. Can it be a reason that smon is still doing recovery? (I am not sure on this). Also, Undo tablespace is increased from 18 GB to 50 GB since yesterday (autoextend on).

Now we are running out of space for archive file system (can't delete them also until they are transferred to DR) Size of redo log is 200MB. This database supports around 2500 users.

performance wise I don't see any hit. Also wait events are normal. (only few db file sequential read) finding the query/session which are causing this much huge amount of archives?

View 7 Replies View Related

Server Administration :: Creating / Running Jobs In Oracle 9i For Solaris

Sep 5, 2005

How to

1) to define a job in oracle9i for solaris
2) to schedule this job

Remember i have prior experience deploying jobs at windows platform but when i try it on (9i for ) solaris, the script does not work as it does not accept a submit job request.

View 4 Replies View Related

Windows :: How To Schedule Backup On 2008 Server

Jun 27, 2010

On windows 2008, need to schedule task for database backup.

View 4 Replies View Related

Running Rootpre.sh On Server?

Aug 6, 2012

We are about to upgrade Os from IBM AIX 5.3 to IBM AIX 6.1 .

My Plan is :

1.Shutdon Database .
2.Os upgradation from IBM AIX 5.3 to IBM AIX 6.1 (IBM Admin)
3.Run "rootpre.sh" and find system requirements .
4.Install required filesets for AIX 6.1
5.Verify all system requirements .
6.Startup database .
----------------------------------------------

I want to know that , is it required to run "rootpre.sh" after OS migration ?.Cos we run this script if we go for fresh Oracle Software Installation .my case software is already installed .

View 1 Replies View Related

See If PMON Or SMON Running On Windows Server?

Feb 27, 2013

On windows server how can we see if the PMON or SMON is running? Is there a way, as we can see on linux using?

View 6 Replies View Related

DBCA Not Running On HPUX Itanium Server

Jan 30, 2013

I have installed oracle software on HPUX IA server.After installation, I am trying to create the database using database template through DBCA.After setting database name , password, database file location and sga size on DBCA, DBCA not initializing the database creation after clicking "Finish" button and does not give any error though.I have tried multiple times but not able to create db using specific template using DBCA.

View 10 Replies View Related

SQL & PL/SQL :: How To Schedule A Job From 8 Am To 8 Pm

Aug 30, 2013

I want to create a scheduler which should run from 8 am to 8 pm and every half an hour.How to do that. I tried dbms_scheduler because my procedure accepts two parameters.

DBMS_SCHEDULER.CREATE_SCHEDULE (
schedule_name => 'in_program_schedule',
start_date => trunc(sysdate)+(1/3),-- it is not taking
repeat_interval => 'freq=minutely; interval=30; bysecond=0;',
END_DATE => trunc(sysdate)+(5/6),-- it is not taking
comments => 'Repeats every half an hour');

View 8 Replies View Related

Server Utilities :: Running Export Utility Online

May 26, 2010

Just want to confirm if I can run the export (command line) even if the database is up (online)? Are there any risks/impact while doing so?

View 7 Replies View Related

Server Utilities :: Running Exp And Imp Command On 11.2.0.1.0 Production Version

Jul 25, 2012

I ran "exp" command to take a back of Oracle Db based on user and later imported(using "imp" command) the dump into another db. Its seen that some the tables are not exported during exp command run. Can I use exp command on Oracle 11.2 version?

or should I always be using expdp command?

View 3 Replies View Related

Efficient Way To Connect SQL Server From Oracle Which Is Running On HP-UNIX

Mar 8, 2011

I am trying to Push the data from Oracle which is running in HP-UNIX to SQL Server. But don't know the efficient way to connect the SQL server from oracle which is running on HP-UNIX.I have heard about oracle Heterogeneous Connectivity but don't know exactly how to implement it in Unix environment.

View 1 Replies View Related

SQL & PL/SQL :: How To Schedule Job To Run Every Sunday At 12 Pm IST

Jun 11, 2013

I want to schedule a job which will run evry Sunday at 12 P.M IST.I have written the below script.

BEGIN
SYS.DBMS_SCHEDULER.CREATE_JOB
(
job_name => 'SERVICE_SAL_FS.SAL_MESSAGE_BUFFER_PURGE_JOB'
,start_date => SYSTIMESTAMP

[code]...

But the server in US.

SELECT sysdate from Dual;
6/11/2013 3:58:58 AM
--But the time in India is 02:28 PM

How to convert the timezone to IST. how to schedule the job to run evry Sunday at 12 P.M IST.

View 4 Replies View Related

SQL & PL/SQL :: How To Schedule Jobs

Dec 19, 2011

I want to run a procedure every day at 9 AM ,so how can i schedule it.

View 3 Replies View Related

How To Schedule A Job Chain

Mar 26, 2013

i want to schedule a job chain. I 've created 4 chain steps. The first perform an action and the second must be executed only if the first completed successfully.
The third must be executed only if the second ends successfully, etc.

The Chain_rule_2 is
CHAIN_STEP_1 Completed and CHAIN_STEP_1 SUCCEEDED
The chain_rule_3 is
CHAIN_STEP_2 Completed and CHAIN_STEP_2 SUCCEEDED
...
But the job is actually running because there isn't an end steps (I suppose). End step must be done if all steps works fine or if only one failed.

View 3 Replies View Related

SQL & PL/SQL :: Schedule A Job Using DBMS_SCHEDULER?

Jan 31, 2013

I am trying to schedule a job using DBMS_SCHEDULER.

The job has to start on SATURDAY 12:00 midnight and should run every on SATURDAY 12:00 midnight.

Even if I create the job on MONDAY first it should start on coming sunday and following sundays.

But I am getting the below error.

ORA-27452: BEGIN APPS_GLOBAL.POPULATE_TARGET144('APPS_XX','APPS_BE',5959); end; is an invalid name for a database object.
ORA-06512: at "SYS.DBMS_ISCHED", line 124
ORA-06512: at "SYS.DBMS_SCHEDULER", line 271
ORA-06512: at line 2

The Job script is

BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'TEST_RAM',
job_type => 'STORED_PROCEDURE',
job_action => 'BEGIN APPS_GLOBAL.POPULATE_TARGET144(''APPS_XX'',''APPS_BE'',5959); END;',

[code]......

View 6 Replies View Related

Cons Of Running 8 Production Database Instance On One Windows Server

Dec 3, 2010

We are planning to consolidate our Oracle Production DB into one server. We are basically a windows shop. Is it feasible to run 8 production Oracle DB in one windows server. All the DB are not really transaction intensive DB. 2 DB in the size of 300GB and others all DB falls under average size of 40GB.

I can take care of the HD slicing so Oracle does not enter into IO bottleneck. We are planning to go for external NAS or SAN for storage.

My main concern is on processor usage. The processor we are thinking about is Intel Xeon Quad Core x 2nos. Will there be a processor bottleneck or is there way in Oracle to assign processor usage(I belive there is no much tweaking options here)

View 6 Replies View Related

Windows :: ORA-12154 - Running 32 Bit Oracle Software On Server 2008 64 Bit

Oct 6, 2011

There is an issue with the 32 bit Oracle client on 64 bit windows where it cannot connect to the database throwing the error ORA-12154: TNS:could not resolve the connect identifier specified.

Since all the 32 applications will have the path C:Program Files (x86) on 64 bit windows, The PATH variable doesn't recognise (). This issue was there in the previous versions of Oracle Client. But the bug has been fixed in Oracle 10.2.0.3 32 bit client. Still the user is facing the same issue.

Oracle Client: 10.2.0.3 32 bit
Windows OS: Windows server 2008 R2 64 bit

I have referred document [ID 334528.1] from the metalink(which states that the bug is fixed in 10.2.0.3 client).

View 4 Replies View Related

Server Utilities :: Why Duplicated Rows When A PK Is Present Running Sqlldr

Dec 10, 2010

Why duplicated rows when a PK is present running Sqlldr?

View 1 Replies View Related

How To Create Central Inventory For Oracle 11g Running On Windows Server

Dec 26, 2012

--- Current Oracle Inventory pointing to the location of C:program FilesOracleInventory.

We are plannig to creat a central inventory for all Oralcle installations into to C:oraagentorainventory.

View 3 Replies View Related

SQL & PL/SQL :: Schedule Procedure On Oracle 10g?

Apr 11, 2012

If I have a sql file containg 'EXECUTE Proc_Test' i.e or any other procedure then to call that sql file what I will mention in the job_type.

OR

If the sql file contains a procedure and I want to call that file through scheduler then what I need to mention in the job type.

View 1 Replies View Related

SQL & PL/SQL :: Time Interval In Schedule Job

Jul 17, 2012

How to set time interval in schedule job i need five minutes interval..

View 5 Replies View Related

SQL & PL/SQL :: Create A Schedule Using Dbms_scheduler

Mar 13, 2011

I have create a schedule using dbms_scheduler and the problem is its not running on exact time that is start time , i even changed the attribute as following but its not.Its running using dbms_scheduler.run_job(veh_insp) when run directly.The schedule is as follows.

BEGIN
DBMS_SCHEDULER.SET_ATTRIBUTE(
name => 'INTERVAL_DAILY_2000',
attribute => 'start_date',
value => TRUNC(SYSDATE)+9.50/24);
END;

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved