KOTC Posted January 16, 2013 Author Report Posted January 16, 2013 [quote name='CBZ' timestamp='1358373122' post='1303119625'] asal endulo etikina rakapotam endo naku aite ardam aitale bhayya... [/quote] nuv dba_scheduler_jobs chustunam manam adi kadhu anukunta chudalisindii nuv chadivava na last post [color=#282828][font=helvetica, arial, sans-serif]andulo em ledhu bhayya kani dbms_job,dbms_scheduler undi kani adi query cheste [/font][/color] select * from dbms_job; [color=#282828][font=helvetica, arial, sans-serif]ORA-04044: procedure, function, package, or type is not allowed here[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]kani a view desc cheste matram[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]SQL> desc dbms_job;[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]FUNCTION BACKGROUND_PROCESS RETURNS BOOLEAN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]PROCEDURE BROKEN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]Argument Name Type In/Out Default?[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]------------------------------ ----------------------- ------ --------[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]JOB BINARY_INTEGER IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]BROKEN BOOLEAN IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]NEXT_DATE DATE IN DEFAULT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]PROCEDURE CHANGE[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]Argument Name Type In/Out Default?[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]------------------------------ ----------------------- ------ --------[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]JOB BINARY_INTEGER IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]WHAT VARCHAR2 IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]NEXT_DATE DATE IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]INTERVAL VARCHAR2 IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]INSTANCE BINARY_INTEGER IN DEFAULT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]FORCE BOOLEAN IN DEFAULT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]PROCEDURE INSTANCE[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]Argument Name Type In/Out Default?[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]------------------------------ ----------------------- ------ --------[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]JOB BINARY_INTEGER IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]INSTANCE BINARY_INTEGER IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]FORCE BOOLEAN IN DEFAULT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]PROCEDURE INTERVAL[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]Argument Name Type In/Out Default?[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]------------------------------ ----------------------- ------ --------[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]JOB BINARY_INTEGER IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]INTERVAL VARCHAR2 IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]PROCEDURE ISUBMIT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]Argument Name Type In/Out Default?[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]------------------------------ ----------------------- ------ --------[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]JOB BINARY_INTEGER IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]WHAT VARCHAR2 IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]NEXT_DATE DATE IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]INTERVAL VARCHAR2 IN DEFAULT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]NO_PARSE BOOLEAN IN DEFAULT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]FUNCTION IS_JOBQ RETURNS BOOLEAN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]PROCEDURE NEXT_DATE[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]Argument Name Type In/Out Default?[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]------------------------------ ----------------------- ------ --------[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]JOB BINARY_INTEGER IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]NEXT_DATE DATE IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]PROCEDURE REMOVE[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]Argument Name Type In/Out Default?[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]------------------------------ ----------------------- ------ --------[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]JOB BINARY_INTEGER IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]PROCEDURE RUN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]Argument Name Type In/Out Default?[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]------------------------------ ----------------------- ------ --------[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]JOB BINARY_INTEGER IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]FORCE BOOLEAN IN DEFAULT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]PROCEDURE SUBMIT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]Argument Name Type In/Out Default?[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]------------------------------ ----------------------- ------ --------[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]JOB BINARY_INTEGER OUT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]WHAT VARCHAR2 IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]NEXT_DATE DATE IN DEFAULT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]INTERVAL VARCHAR2 IN DEFAULT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]NO_PARSE BOOLEAN IN DEFAULT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]INSTANCE BINARY_INTEGER IN DEFAULT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]FORCE BOOLEAN IN DEFAULT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]PROCEDURE USER_EXPORT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]Argument Name Type In/Out Default?[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]------------------------------ ----------------------- ------ --------[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]JOB BINARY_INTEGER IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]MYCALL VARCHAR2 IN/OUT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]PROCEDURE USER_EXPORT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]Argument Name Type In/Out Default?[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]------------------------------ ----------------------- ------ --------[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]JOB BINARY_INTEGER IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]MYCALL VARCHAR2 IN/OUT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]MYINST VARCHAR2 IN/OUT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]PROCEDURE WHAT[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]Argument Name Type In/Out Default?[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]------------------------------ ----------------------- ------ --------[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]JOB BINARY_INTEGER IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]WHAT VARCHAR2 IN[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]em ardham avuthe ento[/font][/color]
KOTC Posted January 16, 2013 Author Report Posted January 16, 2013 [quote name='CBZ' timestamp='1358373821' post='1303119741'] nen setulu ettesina kaka.... [/quote] haha ok bhayya kani deniki difference telusa? dba_scheduler_job dbms_job
KOTC Posted January 16, 2013 Author Report Posted January 16, 2013 col STATUS format a9 col hrs format 999.99 select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,'mm/dd/yy hh24:mi') start_time, to_char(END_TIME,'mm/dd/yy hh24:mi') end_time, elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key; e script use chesi oct 29th roju job chudacha bhayya,,naku sql nill knowledge
peru_edaite_enti Posted January 16, 2013 Report Posted January 16, 2013 [quote name='KOTC' timestamp='1358374291' post='1303119810'] col STATUS format a9 col hrs format 999.99 select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,'mm/dd/yy hh24:mi') start_time, to_char(END_TIME,'mm/dd/yy hh24:mi') end_time, elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key; e script use chesi oct 29th roju job chudacha bhayya,,naku sql nill knowledge [/quote] same ide script rasi kodite maatram bochedu vottai bhayya.... because nuvvu oct 29th day na results query cheyatle... kani okasari kotti chdu.. enni records ottayo chudochu.. aina, maha aite rojuki okasari backup aina, 70 or 80 records ostai.... putty aite buffer increase chesi query run cheyi
KOTC Posted January 16, 2013 Author Report Posted January 16, 2013 [quote name='CBZ' timestamp='1358374476' post='1303119838'] same ide script rasi kodite maatram bochedu vottai bhayya.... because nuvvu oct 29th day na results query cheyatle... kani okasari kotti chdu.. enni records ottayo chudochu.. aina, maha aite rojuki okasari backup aina, 70 or 80 records ostai.... putty aite buffer increase chesi query run cheyi [/quote] toad undi kadha bhayya ravtam le e month e vastundi
Gachibowli_Diwakar Posted January 16, 2013 Report Posted January 16, 2013 asalu ye job nuvu schedule chesav ? procedure name aina gurthundha ? if so, dba_objects lo search cheyi aah procedure undho ledho asalu .. system defined name kanna .. adhe job ni nuvve oka name ichi schedule cheyi .. so that, e job run ayyaaka niku kanipisthundi kabatti..mi team-lead or colleagues ni adagochu .. name ichi schedule chesa i can see this, kani paathadhi kanipinchatledu .. do u guys have any idea ani..
KOTC Posted January 16, 2013 Author Report Posted January 16, 2013 [quote name='Silence..Please' timestamp='1358379506' post='1303120478'] asalu ye job nuvu schedule chesav ? procedure name aina gurthundha ? if so, dba_objects lo search cheyi aah procedure undho ledho asalu .. system defined name kanna .. adhe job ni nuvve oka name ichi schedule cheyi .. so that, e job run ayyaaka niku kanipisthundi kabatti..mi team-lead or colleagues ni adagochu .. name ichi schedule chesa i can see this, kani paathadhi kanipinchatledu .. do u guys have any idea ani.. [/quote] bhayya nuv edo cheptunav ardham avtam le kinda link chudu same problem a rman jobs chudali nenu OEM repository database loo https://forums.oracle.com/forums/thread.jspa?threadID=2167979&tstart=23
Gachibowli_Diwakar Posted January 16, 2013 Report Posted January 16, 2013 [quote name='KOTC' timestamp='1358379804' post='1303120503'] bhayya nuv edo cheptunav ardham avtam le kinda link chudu same problem a rman jobs chudali nenu OEM repository database loo [url="https://forums.oracle.com/forums/thread.jspa?threadID=2167979&tstart=23"]https://forums.oracl...67979&tstart=23[/url] [/quote] oh RMAN backups aah schedule chesindhi .. database backup aah leka archive log backup aah ? database host ki login ayi .. type below .. run ayithe backup sets chuupisthundi kadha.. that way around.. evarini aina adagochu.. atleast scheduled backup run aindi .. kani aah job kanipinchatledu ani .. aah list backup lo em kanipinchakapothe.. nuvu sarigga schedule cheyaledu aney .. rman target / list backup;
Gachibowli_Diwakar Posted January 16, 2013 Report Posted January 16, 2013 nenu bayataki velthunna.. kaasepaagi ostha malli select table_name from dict where table_name like '%BACKUP%' ; adhi type chesi .. backup related views anni chudu .. rman prompt lo ki vellakkarledu
KOTC Posted January 16, 2013 Author Report Posted January 16, 2013 [quote name='Silence..Please' timestamp='1358380057' post='1303120526'] oh RMAN backups aah schedule chesindhi .. database backup aah leka archive log backup aah ? database host ki login ayi .. type below .. run ayithe backup sets chuupisthundi kadha.. that way around.. evarini aina adagochu.. atleast scheduled backup run aindi .. kani aah job kanipinchatledu ani .. aah list backup lo em kanipinchakapothe.. nuvu sarigga schedule cheyaledu aney .. rman target / list backup; [/quote] thanks bhayya kani matter enti ante ikkada rman use chesi OEM lo job schedule chesaru so andulo a job skip ayindi leka evaru ayina delete chesaro teliyadhu.Adi kuda archive log full ayaka actual a job undali enduku ledhu ani investigate cheste OEM lo a job schedule lo ledhu.So a schedule jobs ni ela chudali OEM repository database lo annadi question? nuv chepina [color=#000000][font=tahoma, verdana, sans-serif][size=2]dba_scheduler_job_run_details[/size][/font][/color] chuste no luck..Inka ela ayina chudacha? a OEM job schedule chestam vatiki em ayina log files untaya,job skip ayindha ledha chudataniki.???
Gachibowli_Diwakar Posted January 16, 2013 Report Posted January 16, 2013 [quote name='KOTC' timestamp='1358380296' post='1303120550'] thanks bhayya kani matter enti ante ikkada rman use chesi OEM lo job schedule chesaru so andulo a job skip ayindi leka evaru ayina delete chesaro teliyadhu.Adi kuda archive log full ayaka actual a job undali enduku ledhu ani investigate cheste OEM lo a job schedule lo ledhu.So a schedule jobs ni ela chudali OEM repository database lo annadi question? nuv chepina [color=#000000][font=tahoma, verdana, sans-serif][size=2]dba_scheduler_job_run_details[/size][/font][/color] chuste no luck..Inka ela ayina chudacha? [/quote] hmm..grid lo ela chustharo naku no idea bhayya.. asalu nenu epudu ye jobs kuda through OEM schedule cheyaledu.. so idea ledu naku .. this might sound little silly... nuvu aah oem's grid database lo ki login ayi chusthunav kadha ? aah OEM monitor chesey database lo login ayi chuudakunda ? becos grid lo ne chudali ..schedule chesey jobs andhulo untaay ..
KOTC Posted January 16, 2013 Author Report Posted January 16, 2013 [quote name='Silence..Please' timestamp='1358380295' post='1303120549'] nenu bayataki velthunna.. kaasepaagi ostha malli select table_name from dict where table_name like '%BACKUP%' ; adhi type chesi .. backup related views anni chudu .. rman prompt lo ki vellakkarledu [/quote] Nuv chepinatu cheyachu kani ikkada oka rendu jobs biskit ayyai avi different databases vi. OEM repository database lo em ayina views untai ?? ani jobs chusukovachu ga akkada aithe ani
Gachibowli_Diwakar Posted January 16, 2013 Report Posted January 16, 2013 [quote name='KOTC' timestamp='1358380539' post='1303120577'] Nuv chepinatu cheyachu kani ikkada oka rendu jobs biskit ayyai avi different databases vi. OEM repository database lo em ayina views untai ?? ani jobs chusukovachu ga akkada aithe ani [/quote] idhi chudu https://forums.oracle.com/forums/thread.jspa?threadID=961469
KOTC Posted January 17, 2013 Author Report Posted January 17, 2013 [quote name='Silence..Please' timestamp='1358380679' post='1303120585'] idhi chudu [url="https://forums.oracle.com/forums/thread.jspa?threadID=961469"]https://forums.oracl...threadID=961469[/url] [/quote] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]DBA_SCHEDULER_RUNNING_JOBS, DBA_SCHEDULER_PROGRAMS, DBA_SCHEDULER_JOB_LOG, DBA_SCHEDULER_WINDOWS[/background][/size][/font][/color] pyna unna views check cheste owner ante sys, vastundi bhayya kani OEM sysman tho schedule chestam kadha jobs ikkada owner sys Oracle_ocm chupistundi sysman chupichtam ledhu more job_nam lo kuda manam OEM lo rman use chesi schedule chese job kuda chupivtam ledhu.
Recommended Posts