Cannot drop Jobs because SYS.DBMS_INTERNAL_LOGSTDBY error

ORA-04063: package body “SYS.DBMS_INTERNAL_LOGSTDBY” has errors
ORA-06508: PL/SQL: could not find program unit being called: “SYS.DBMS_INTERNAL_LOGSTDBY”
ORA-06512: at “SYS.DBMS_IJOB”, line 522
ORA-06512: at “SYS.DBMS_JOB”, line 171
ORA-06512: at line 2

I check this package, i got this error “PL/SQL: ORA-00942: table or view does not exist” but i can’t find what table because this package body wrapped. So i want to find what table that in use in this package. Here the sql to find what table that used in SYS.DBMS_INTERNAL_LOGSTDBY (you must run in 2 server to find what table doesn’t exists) :

SELECT owner, object_type, object_name, object_id, status
FROM SYS.dba_objects
where object_name = ‘DBMS_INTERNAL_LOGSTDBY’;

OWNER OBJECT_TYPE        OBJECT_NAME                                 OBJECT_ID  STATUS
SYS        PACKAGE                   DBMS_INTERNAL_LOGSTDBY 4339               VALID
SYS        PACKAGE   BODY    DBMS_INTERNAL_LOGSTDBY 7300             INVALID

———————————————————————————————————–

SELECT B.*
FROM PUBLIC_DEPENDENCY A, SYS.DBA_OBJECTS B
WHERE A.OBJECT_ID = 7300 AND A.REFERENCED_OBJECT_ID = B.OBJECT_ID AND OBJECT_TYPE = ‘TABLE’
ORDER BY OWNER, OBJECT_NAME;

On my server i have 24 object_name, such as :

AUD$
AUDIT_ACTIONS
COL$
DUAL
FGA_LOG$
IND$
INDPART$
JOB$
OBJ$
TAB$
TS$
USER$
LOGMNR_DICTSTATE$
LOGMNR_LOG$
LOGMNR_SESSION$
LOGMNR_UID$
LOGSTDBY$APPLY_MILESTONE
LOGSTDBY$EVENTS
LOGSTDBY$HISTORY
LOGSTDBY$PARAMETERS
LOGSTDBY$SCN
LOGSTDBY$SKIP
LOGSTDBY$SKIP_SUPPORT
LOGSTDBY$SKIP_TRANSACTION
Now, try to find what table doesn’t exist, copy the script to create table from another server which have the table.  After there are no table miss, compile DBMS_INTERNAL_LOGSTDBY again.

Advertisements

‘javac’ is not recognized as an internal or external command

1. Go to http://java.sun.com and download the latest Version of Java SDK or any Jave SDK that your requirement and install on your system.

2. Accept all of the defaults and suggestions, but make sure that the location where Java will be installed is at the top level of your C: drive.
Click on “Finish.” You should have a directory (folder) named C:\j2sdk1.5.0_04, with subfolders C:\j2sdk1.5.0_04\bin and C:\j2sdk1.5.0_04\lib

3. Modify your system variable called “PATH” (so that programs can find where Java is located).
To do this for Windows 2000 or XP, either right-click on the My Computer icon or select “System” on the control panel.
When the window titled “System Properties” appears, choose the tab at the top named “Advanced.”
Then, click on “Environment Variables.”
In the bottom window that shows system variables, select “Path” and then click on “Edit…” Add C:\j2sdk1.5.0_04\bin as the first item in the list.
Note that all items are separated by a semicolon, with no spaces around the semicolon. You should end up with a path variable that looks something like
C:\j2sdk1.5.0_04\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\system32\Wbem

For Windows 98 or ME, open the file AUTOEXEC.BAT in Notepad. You should find a line in this file that begins
SET PATH=…
Modify this line to add C:\j2sdk1.5.0_04\bin; immediately after the equals sign.

4. Modify or create a system variable called “CLASSPATH,” as follows.
In the lower “System Variables” pane choose “New…”
and type in Variable Name “CLASSPATH” and value (note that it begins with dot semicolon).;C:\j2sdk1.5.0_04\lib

5. To test Java to see if everything is installed properly, open a command window (a DOS window)
and type the command “javac” The result should be information about the Usage of javac and its options.
If you get a result that “‘javac’ is not recognized as an internal or external command, operable program or batch file” then there is a problem
and Java will not work correctly.