I have a job running under HUMADM user and would like disable or drop it.I do not have the login credentials of HUMADM user but can log into the database as system/sys user.
When I run the below commands as sys/system user it says humadmjob must be a job or it is not running.This is because it is looking for the job under sys/system user.
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'
A procedure in a package uses a database link. The database link is defined without a username and a password. The user that uses the database link is supposed to be present in the opposite database as wel.
When the procedure is started in SQL*Plus or TOAD it runs perfect. But the procedure has to run in a scheduled job. And that doesn't work. The procedure fails because of: ORA-01017 invalid username/password. The user that is used to run the scheduled job is the right one.
I have created a materialized view log on table testing_mview_rev in 11g:
SQL> CREATE MATERIALIZED VIEW LOG ON testing_mview_rev WITH ROWID;
Materialized view log created.
And a MV on it in 10g:
SQL> create materialized view testing_mview_1_rev REFRESH Force start with (sysdate) next (sysdate+1/1440) with rowid as select * from testing_mview_rev@S58_TO_S56; Materialized view created.
Now this is suppose to automatically refresh itself every minute but refresh is failing. However manual refresh is working fine.
what I have missed here. is there any other way to schedule the MV to run every minute?
am facing an issue with scheduled jobs. The below script will create a scheduled job to insert a record for every 2 mins into the table "job_table".
--Table script CREATE TABLE job_table (now DATE); --Stored procedure run by scheduled job CREATE OR REPLACE PROCEDURE test1 IS BEGIN
[code]...
The scheduled job does not require any special grant privillege as the PUBLIC has access to run it. Anyhow the same set of instruction working for my friend on his machine but not on my environment.
BEGIN dbms_scheduler.create_schedule( schedule_name => 'INTERVAL_EVERY_1_MINUTES', start_date => trunc(sysdate)+18/24, repeat_interval => 'freq=MINUTELY;interval=1', comments => 'Runtime: Every day all 1 minutes'); END;-- program code BEGIN
[code]....
all above three code compiled successfully . but it is not running automatically and not run every 1 minute.
I try to run this manuall by using following code
BEGIN dbms_scheduler.run_job('JOB_FEED_UK_DATA',TRUE); END;
It works fine..
create or replace PROCEDURE LOAD_CUSTOMERS_UK IS BEGIN Insert into CUSTOMERS_UK (ID, NAME, CITY) VALUES (1,'SMITH','LONDON'); Insert into CUSTOMERS_UK (ID, NAME, CITY) VALUES (2,'JONES','LONDON'); Insert into CUSTOMERS_UK (ID, NAME, CITY) VALUES (3,'BROWN','BRIGHTON');
We are using one application. This application is having 2types of jobs. Under each job again there are each 5 sub jobs. All the jobs are scheduled jobs. Now the requirement is The main 2 jobs we are going to run on some specified days( for this we need to mention on what days we want to run.once we gave those day the next steps will start).
for example 1 main job is scheduled on Monday ( we need to schedule it on monday-- we need to write a program for this) under this every sub job will run.these sub jobs are dependent jobs.if sub job completed successfully it should send an email to the distributed mail group which says like " <Job_name> completed successfully" if it fails also it needs to send an email to the distributed group. for each sub job it should send either success/falure mail to the distriuted mail group.
once after completing all the sub jobs successfully it should send a mail to the distributed mail group saying that The main job got completed successfully.these two main jobs will run paralelly but the the second main job will run after 30 mins of 1st job starts.
in the second job also will work as same as job1 process.it should also send mails to the distributed mail groups.The jobs are already scheduled.No need to scheduled the jobs.need to write a pl/sql program like it will check all the jobs and respected sub jobs if any thing got completed/failed it should send an email to the distributed mail group automatically. For that it should monitor all the jobs..that's the requirement.
I have already scheduled all the jobs. now want to write a script for the above requiement.
i have batch file name exptab,to export all table in database
for example @echo off exp scott/tigger tables=emp file=C:impemp.dmp LOG =C:implog1 batch file working fine when i click on it,
I need to use the Scheduled Tasks in windows 2003 so when the computer startup batch file will run automatically i follow all the step but its not working i try the same story with windows xp still problem exist .
As I was observing the space issues on my db server. I found that there is lots of Trm and Trc file which is being created very much frequently. Due to this its consuming lots of space even the size of each files is not more than 1Mb.
For cleaning I am deleting all the trm and trc files mannully using DEL command Os level. How can i schedule the purging of trm and trc files.
Yesterday, there were performance issue at server. So today, when i am generating report for that particular period, found snapshot id sequence is serially but with skipped hourly timed. Instead of generating report at 15:30, it generated at 16:30.
Enter value for num_days: 2
Listing the last 2 days of Completed Snapshots Snap Instance DB Name Snap Id Snap Started Level ------------ ------------ --------- ------------------ ----- tagidev TAGIDEV 2857 10 Sep 2013 00:30 1 2858 10 Sep 2013 01:30 1 2859 10 Sep 2013 02:30 1 2860 10 Sep 2013 03:30 1 2861 10 Sep 2013 04:30 1 2862 10 Sep 2013 05:31 1
[code]....
Below are the details at alert log -
Tue Sep 10 14:28:20 2013 Thread 1 cannot allocate new log, sequence 7029 Checkpoint not complete Current log# 2 seq# 7028 mem# 0: E:APPORACLEORADATATAGIDEVREDO02.LOG Thread 1 advanced to log sequence 7029 (LGWR switch)
[code]....
1) why snap didn't started at 15:30?
2) since database just started at the scheduled time of AWR snap time. But generated at 16:32 instead of 16:30, though last services "SMCO" is started at 16:42. How it snap id generated for this particular time?
3) what does "kewastUnPackStats(): bad magic 1 (0x000000001B3CE48D, 0)" mean?
I copied a sqlplus scheduled job procedure. Procedure successfully created .I fount it here [How to Schedule RMAN Daily Backup? [URL]
The procedure is successfully created. Now, doing the following operations:
1) running that job 2) checking whether that job is running or not 3) listing all other jobs 4) unschedule a scheduled job 5) delete a job 6) edit a job
There is a readonly user on our reporting server. Developers want to use global temporary tables with this user. I don't want the user to have permissions other than readonly.I can grant the user CREATE TABLE privilege and did not grant quota on any permanent tablespace, therefore user would not be unable to create permanent tables but still should be able to create global temporary tables.
Question is would a user with such permissions still be able to utilize temp tables as part of a scheduled job?
I am trying to get a working script that could just go and mark all dba_jobs to BROKEN ==> TRUE "execute dbms_job.broken(jobno,true)" using a pl/sql script
I have the working structure of the script except for the fact that the goal is not achieved. I came to know that the ALTER SESSION SET CURRENT_SCHEMA does not take effect when used with the DBMS_JOB API.
Is there an alternative I can get this working.
CODE<--------- part of the script : START
FOR l_job_users IN job_users LOOP execute immediate 'alter session set current_schema='||l_job_users.LOG_USER; DBMS_OUTPUT.PUT_LINE(current_user); FOR l_jobs IN jobs(l_job_users.LOG_USER) LOOP [code].....
In PL/SQL Plus, i can enable/disable auditing when i connect as sysdba by using these command:
SQL> ALTER SYSTEM SET audit_trail=db SCOPE=SPFILE SQL> shutdown SQL> startup
I've done it successfully with PL/SQL Plus command line. But in PHP, how can i do that?How to execute "shutdown" and "startup" from PHP? I've found this code for connect to oracle as sysdba:
How to Disable Function key F4 in forms 6i for example in forms i want that no body copy full row with F4 Key pls guide me where to apply key F4 trigger in forms.
How to disable a user's sql login? To ellaborate, I want a user to login through a certain application only with his userid on database level & not through "sqlplus username@dbname".
Is it possible? If no, then what can be done to achieve below.
I have a userid which has all the update, delete privileges on it. That id needs to be configured in the application alongwith the password. So in order to avoid misuse of that id I want to block its sql access.
I am not sure whether this can be achieved or not.
I have a Radio Box Item field in Form, It contain Three Radio Buttons.
During the User Login Some of the users Not Require to Touch Any of the Three Radio. Thus i Require to Disable that Radio Button to That User. How to Disable the Particular Radio Button.
I'm trying to disable the new write flash cache feature that came with the latest Exadata patch on our Quarter RAC X2-2 The procedure i'm trying to follow is as described below:
1. CellCLI> alter cell flashcache all flush 2. CellCLI> drop flashcache 3. CellCLI> alter cell shutdown services cellsrv 4. CellCLI> alter cell flashCacheMode=Writethrough 5. CellCLI> alter cell startup services cellsrv
My problem is that when i'm running 1. i receive a syntax error.The only doc i could find describing how to go back from WriteBack mode is[URL]...
the software i use in oracle 10g is for calculating the pensionary benefits. Those who retire voluntary or on superannuation gets pension, commutation and gratuity.
for those death cases only family pension and gratuity is eligible.
my problem is when i give the pension case as family pension the commutation tab also gets visible and it allows the users to enter values for commutation even though they are not eligible.
i would like to know if i can disable the commutation tab once i enter the pension case as family pension.
The DBA granted the RESOURCE role for my user USER1:
GRANT RESOURCE TO USER1; The USER1 logged and activated the role RESOURCE. CONN USER1/USER1 SET ROLE RESOURCE;
... it has some privileges in database ( UNLIMITED TABLESPACE for example that grant to him create table in any tablespace).
Now I created a new tablespace, but the user1 cannot use this new tablespace.So I will to revoke the RESOURCE for the USER1:REVOKE RESOURCE TO USER1;
It seems ok, but the user USER1 can still create tables in the new tablespace.I repared that UNLIMITED TABLESPACE still active, and the REVOKE RESOURCE just will have effect in the next LOGON of the USER1.
How can I REVOKE the ROLE and disable all the privileges from it immediately?
There are 4 nodes in a RAC environment A,B,C,D..For instance i want to disable all the services for node D temporarily and hand over the Node D to the system admin guys and after the maintainance is done I want to restart the services again on node D..
