Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to view Oracle job logs

mohitanchliaDec 17 2008 — edited Apr 22 2009
Oracle 10g:

I have following job:

procedure create_or_replace_job as
begin
begin
dbms_scheduler.drop_job(job_name => merge_job_name);
exception
when others then
/* ignore */
commit;
end;
dbms_scheduler.create_job(job_name => merge_job_name,
job_type => 'STORED_PROCEDURE',
job_action => merge_proc_name,
start_date => to_timestamp('01-Jan-1970 ' || merge_job_time,
'DD-Mon-RRRR HH24:MI:SS'),
repeat_interval => 'FREQ = DAILY; INTERVAL = 1');
commit;
end;
---

But I want to see when job ran and if there were any errors.

Comments

795934
Rolf_Gitt wrote:
I have a Sun 6140 SAN that is apparently having a NIC flapping problem (according to our network team) on the Controller B IP connection - which is causing network problems on the entire subnet. Controller A connection is working fine.
I don't have any direct experience, but a [previous thread|http://forums.sun.com/thread.jspa?forumID=831&threadID=5342251] pointed to the following Sun Alert which is the cause of the "flapping problem":
[Sun StorageTek 25x0 and 6140 Arrays may send wrong Network packets, causing the Sun StorageTek Common Array Manager (CAM) Host to Lose the Network Connection to the Array|http://sunsolve.sun.com/search/document.do?assetkey=1-66-240105-1]

Looks like a firmware upgrade will fix the flapping problem.
807557
hi Rolf_Gitt
So - my question is: Can I unplug the Controller B NIC for a few days without any significant consequences for end user data access or SAN control, assuming Controller A NIC works fine?
Yes you can unplug the ethernet from controller B without any significant consequences. Just remember that if you do a firmware upgrade to plug it back in again otherwise the process will fail.

David
807557
Thanks for pointing out the issue! That is most helpful.

I'll assign some "Duke stars" once I figure out how to do that!
797527
Rolf_Gitt wrote:
So - my question is: Can I unplug the Controller B NIC for a few days without any significant consequences for end user data access or SAN control, assuming Controller A NIC works fine?
Not without consequence. If you do that, you will trigger the following problems:

1. CAM will report alarms due to the communication lost with controller B.
2. If you engage us (Sun support), we won't be in position to assist you efficiently because the supportdata you will collect will miss the controller B information for one particular file.
3. F/W upgrade won't be possible while one controller only is attached to the network.

Therefore, instead of unplugging the controller B network interface, I would suggest you to contact your local Sun support team and work with them in order to narrow down this issue by using different methods.

Regards
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 20 2009
Added on Dec 17 2008
#general-database-discussions
20 comments
61,574 views