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.
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 RelatedRecently we are planning to migrate oracle 10g to 11g. We are migrating PHASE WISE (Schema wise) as this is a 50TB of Production instance. We are using Oracle Golden gate for this purpose.
Is there is any way that we can migrate oracle jobs from 10g to 11g?
We have to migrate our database from current OS (AIX 5.3) to Solaris 10. We'll do it through expdp / impdp. Is there any other way to do it as well?
Also, we have dataguard configured at current setup. So is there any way we can take backup of existing database at DR & restore it at new server (Solaris) or we'll have to take a fresh backup from DC (after migration) & ship it to DR & create a new standby?
what jobs will be created when we upgrade to oracle 11.1 version ?
View 4 Replies View RelatedI have oracle 10g up and running on Solaris 10, from windows I would like to connect to sql plus through windows authentication, for that I have already made sure that remote_auth = true and have created user in oracle with OPS$. But still I cannot connect.
I have the same setup but with oracle on windows server, the os authentication from windows clients works just fine.
does oracle 10g on solaris 10 supports windows os authentication?
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]....
While creating the index we are getting the error "ORA-00603: ORACLE server session terminated by fatal error".
We have the space in tablespaces and also in the file systesm.
how to create a new database in oracle??
View 2 Replies View RelatedI tried to upgrade oracle 10.2.0.4 to 11.2.0.2 on the Solaris 10 server, but after 40 minutes it hangs bei oracle XML Database.
View 5 Replies View RelatedI have to move a database from 10.2.0.4(solaris 9) to a 11.2.0.2(Solaris 10) . 11g shell database is ready .Its a 400GB database.
View 7 Replies View RelatedI am trying to find a way to identify what are the user_jobs currently running. I have found 1 way which requires DBA User ID to execute (e.g. DBA_JOBS and DBA_JOBS_RUNNING) which I don't want.
I believe there is NO equivalent User table for DBA_JOBS_RUNNING table.
I have done my 20 mins search in this forum and unable to find.
I cannot run a Scheduler remote external job on Windows. Here's what I'm doing:
--Check that XDB isinstalled:
desc resource_view
--Check that MTS is running
sho parameters dispatcher
sho parameters shared_Server
--Setup an http listening port:
exec dbms_xdb.sethttpport(8080)
[code].....
This is the error:
orcl> select job_name, status, error#, actual_start_date, additional_info
2 from user_scheduler_job_run_details where job_name='TRYIT';
TRYIT
FAILED -1.074E+09
15-JUN-11 02.16.54.583000 EUROPE/LISBON
[code].....
I am certain that the communications and the credentials are correct, I've tried variants and get different errors. I think the problem is the job action. I've tried running batch files as well as OS commands, same result. THere is nothing useful in the core dump. Is there perhaps a Windows specific technique for running external jobs? Some way of nominating the batch file, or specifying a command interpreter?
When performing test recoveries of a database we often wish to prevent database jobs from running application processes such as (a) sending emails; or (b) logging events to a central logging database. In order to accomplish this, we set the job_queue_processes to zero before opening the database.
This means that no dbms_jobs run on the open instance, but it does not prevent dbms_scheduler jobs from running.How can we prevent any dbms_scheduler jobs from running?
I have looked at setting the MAX_JOB_SLAVE_PROCESSES attribute using DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE, but this cannot be set to zero.
This is on a vmware virtual server on Windows 2008R2 using ORACLE 11g R2 with patch set 6
I installed ORACLE (software only) and applied patch set 6 and tried to create a new database.
during the database creation I got an error as the system was adding the JVM that read:-
ORA-01927:cannot REVOKE privileges you did not grant.
I was given the options to ignore or abort
I chose to ignore the error and continue.
After the database creation completed I looked in the jserver log copied below and found two errors
I did not get the same error before installing patch set 6
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
No errors.
alter system flush shared_pool
drop role javauserpriv
[Code].....
our system admin is changing the time zone on solaris system, how can it effect my DB or as DBA what should i check before he do that and after he change the time zone. he is changing the time zone because of an issue with the DST (Daylightsaving time).
View 1 Replies View RelatedI had a task to reschedule database jobs to a different date as they were Running Statistics job running during business hours..
I used dbms_job.change procedure for the same
On Thursday i.e. 17th June i changed a job as follows
exec dbms_job.change(11, NULL, TRUNC(SYSDATE+2), 'TRUNC(SYSDATE+7)');
When i checked the status today querying user_jobsi found that the job was started today at 00:57 hrs.
I checked the alert logs as well but couldn't find any errors. How to proceed with the troubleshooting for this issue.
We have an Oracle 9i (9.2.0.7) two-node RAC database running on Solaris 5.8. Recently we have switched our production database from no archive log mode to archive log. We changed the parameter CLUSTER_DATABASE=FALSE on one of the instances before converting and reverted back.why this parameter needs to be changed to false?
View 2 Replies View Relatedfind the Execution time frequency of the database jobs?i need the Execution time like this..
Job A is Running on every monday 10:30 AM OR
Job A is Running on every MONTH OR
Job A is Running on every DAY 10:30 AM
My problem is only on Some Saturday's my Oracle server's Load average goes high (more than 300 ).
-- oracle version 11.2.0.1.0
-- runs on Sun solaris 10
-- Sun fire V 440
-- Sun storEdge 3315 connected to the server.
Same setup is working find with higher volumes without any problem but only on saturday's, that too not on all saturdays, some specific saturdays the load average goes high.
At the time nothing will be processed from the application side and the cpu utilisation goes high upto 95 %.
I am sending necessary information as follows.
vmstat 6 10
kthr memory page disk faults cpu
r b w swap free re mf pi po fr de sr s0 s1 s3 s4 in sy cs us sy id
3 0 0 28660024 6513408 285 212 2044 2 2 0 0 0 17 0 42 830 3469 1380 22 5 74
125 0 0 29027480 6156256 2 6 34 0 0 0 0 0 5 0 10 791 53770 30278 83 17 0
125 0 0 29027680 6157496 29 140 21 1 1 0 0 0 5 0 9 786 52756 30309 83 17 0
116 0 0 29031600 6159896 24 125 0 0 0 0 0 7 3 0 5 819 54081 31069 83 17 0
[code]....
How to find currently running scheduled jobs using query !?
View 3 Replies View RelatedFrom some day I have this error during export data pump:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31687: error creating worker process with worker id 1
ORA-31687: error creating worker process with worker id 1
ORA-31688: Worker process failed during startup.
This error is random, if I retry after few minutes the expdp work correctly.
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 ?
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]...
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 RelatedI 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.
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".
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.
I am currently running my production database server on win 2003 with oracle9i, I want to create a physical standby server, so I had created new server with same configuration. Need command to apply these datafiles and archives which are generating everyday in my primary database server.
View 1 Replies View RelatedI have a fresh server with no databases. The processes is to create database using a custom script cr_db, this invokes dbca saliently.
While creating a new database i faced the below error: -
Cleaning up failed steps
DBCA_PROGRESS : 4%
Creating and starting Oracle instance
DBCA_PROGRESS : 6%
DBCA_PROGRESS : 7%
DBCA_PROGRESS : 8%
ORA-01501: CREATE DATABASE failed
ORA-01101: database being created currently mounted by some other instance
ORA-01501: CREATE DATABASE failed
ORA-01101: database being created currently mounted by some other instance
DBCA_PROGRESS : 100%
There are no databases in the server : -
[oracle@lxx0019:/prd/dvp/ora/app/oracle/admin/LDD/diag/rdbms/ldd/LDD/trace]# ps -ef | grep pmon oracle 27784 10729 0 10:52 pts/3 00:00:00 grep pmon