Rdbms Admin Catalog Sql

Rdbms Admin Catalog Sql Login
@$oracle_home/rdbms/admin/catalog.sql
Rdbms Admin Catalog Sql Mysql

Our rman catalog database is 11.2.0.3 right now, do I need to upgrade the database to 12.1.0.2 first, and then upgrade the catalog to 12.1.0.2? The version of the RMAN catalog database does not need to match that of the recovery catalog. Therefore you can upgrade the RMAN catalog without upgrading the RMAN database. This is true of any version of the database, not only 12c. Jun 17, 2020 catalog and catproc scripts. Hi Tom, Could u please tell me what would be the Impact on a live database if catalog.sql and catproc.sql are run?Thanks in advance.Thanks & Regds Ashok.E.

CATPROC Oracle Database Packages and Types INVALID After upgrade

Posted by ssgottik on 17/06/2015

STEP 01:

For validating the catproc the following steps needs to be executed:

Step 01 a –
SQL> shutdown immediate;

Step 01 b –
SQL> startup upgrade;

Step 01 c –

conn / as sysdba
spool catalogproc.out
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/utlrp.sql
@?/rdbms/admin/utlrp.sql
@?/rdbms/admin/utlrp.sql
Column comp_id format a10
Column comp_name format a35
Column version format a12
Column status format a10
select comp_id, comp_name, version, status from dba_registry;
SELECT OWNER,OBJECT_NAME,OBJECT_TYPE,STATUS FROM DBA_OBJECTS WHERE STATUS<>’VALID’ ORDER BY OWNER,OBJECT_NAME,OBJECT_TYPE,STATUS;
spool off

Step 01 d –
SQL> shutdown immediate;
SQL> startup;

STEP 02:

If step 01 doesn’t works :

Reference note:782735.1

Execute the following script repeatedly while connected as SYS AS SYSDBA and perform the indicated operation until it returns ‘CATPROC can be validated now’.

REM ***************
REM CHECKVALID.SQL
REM ***************
set serveroutput on;
declare
start_time date;
end_time date;
object_name varchar(100);
object_id char(10);
begin
SELECT date_loading, date_loaded into start_time, end_time FROM registry$ WHERE
cid = ‘CATPROC’;
SELECT obj#,name into object_id,object_name
FROM obj$
WHERE status > 1 AND
(ctime BETWEEN start_time AND end_time OR
mtime BETWEEN start_time AND end_time OR
stime BETWEEN start_time AND end_time) AND
ROWNUM <=1;
dbms_output.put_line(‘Please compile Invalid object ‘||object_name||’
Object_id ‘||object_id );
EXCEPTION
WHEN NO_DATA_FOUND THEN
dbms_output.put_line(‘CATPROC can be validated now’ );
end;
/

Once all of the dependent objects have been recompiled, validate CATPROC by executing the following command:
execute DBMS_REGISTRY_SYS.VALIDATE_CATPROC;

In my case even after running this CATPROC did not become VALID . So when I ran the below query

column object_name format a25

SQL > select object_name, object_type, owner from dba_objects
where object_name like ‘%PLAN_TABLE%’;

OBJECT_NAME OBJECT_TYPE OWNER
—————————— ——————- ——————————
PLAN_TABLE TABLE SYS
PLAN_TABLE SYNONYM PUBLIC
TOAD_PLAN_TABLE TABLE DORIS
BMC_SQLEX_PLAN_TABLE_S02 TABLE SYSTEM
PLAN_TABLE TABLE SYSTEM
SQL_PLAN_TABLE_TYPE TYPE SYS
SQL_PLAN_TABLE_TYPE SYNONYM PUBLIC
PLAN_TABLE$ TABLE SYS
TOAD_PLAN_TABLE SYNONYM PUBLIC

This issue is caused by existence of :
– table SYS.PLAN_TABLE$
– public synonym PLAN_TABLE for the SYS.PLAN_TABLE$.
– and possibly (not always present) table SYS.PLAN_TABLE

In order to prevent the issue from occurring it is necessary to drop before starting the upgrade process. :
– the SYS owned table PLAN_TABLE$
– the public synonym PLAN_TABLE
– the SYS owned table PLAN_TABLE if it exists

As the SYS user, drop the PLAN_TABLE$, the public synonym PLAN_TABLE and if it exists
the table PLAN_TABLE in SYS schema (SYS.PLAN_TABLE is not always there) :

If you receive the following error while attempting to drop the plan table:

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01008: not all variables bound
ORA-06512: at line 21

ensure that the cursor_sharing parameter is set to EXACT.

This can be done at the session level using ‘alter system set cursor_sharing=exact scope=memory;’
SQL> drop table plan_table$;

Table dropped.

SQL> drop public synonym plan_table;

Synonym dropped.

if SYS.PLAN_TABLE exists :

drop table plan_table;

SQL> column object_name format a25
SQL> select object_name, object_type, owner
2 from dba_objects
3 where object_name like ‘%PLAN_TABLE%’;

OBJECT_NAME OBJECT_TYPE OWNER
————————- ——————- ——————————
SQL_PLAN_TABLE_TYPE TYPE SYS
SQL_PLAN_TABLE_TYPE SYNONYM PUBLIC
EXF$PLAN_TABLE TABLE EXFSYS

Then re-create the PLAN_TABLE
$ sqlplus ‘/ as sysdba’
SQL> @?/rdbms/admin/catplan.sql — creates a public plan table as a global temporary table accessible from any schema
SQL> @?/rdbms/admin/dbmsxpln.sql — reload dbms_xplan spec
SQL> @?/rdbms/admin/prvtxpln.plb — reload dbms_xplan implementation
SQL> @?/rdbms/admin/prvtspa.plb — reload dbms_sqlpa (Note use prvtspao.plb if prvtspa.plb is not present).
SQL> column object_name format a25
SQL> select object_name, object_type, owner
2 from dba_objects
3 where object_name like ‘%PLAN_TABLE%’;

OBJECT_NAME OBJECT_TYPE OWNER
————————- ——————- ——————————
SQL_PLAN_TABLE_TYPE TYPE SYS
SQL_PLAN_TABLE_TYPE SYNONYM PUBLIC
PLAN_TABLE SYNONYM PUBLIC
EXF$PLAN_TABLE TABLE EXFSYS
PLAN_TABLE$ TABLE SYS

After setting up 9i DB manually when i ran this script all went well with few errors , i am wondering these errors are ignoreable ....
@/vobs/oracle/rdbms/admin/catproc.sql
Grant succeeded.
drop package body sys.diana
ERROR at line 1:
ORA-04043: object DIANA does not exist
drop package sys.diana
ERROR at line 1:
ORA-04043: object DIANA does not exist
Package created.
Package body created.
drop package body sys.diutil
ERROR at line 1:
ORA-04043: object DIUTIL does not exist
drop package sys.diutil
ERROR at line 1:
ORA-04043: object DIUTIL does not exist
Package created.
ERROR at line 1:
ORA-04043: object PSTUBT does not exist
Procedure created.
Grant succeeded.
drop procedure sys.pstub
ERROR at line 1:
ERROR at line 1:
ORA-04043: object SUBPTXT2 does not exist
Procedure created.
drop procedure sys.subptxt
ERROR at line 1:
ORA-04043: object SUBPTXT does not exist
ERROR at line 1:
ORA-04043: object DBMS_XPLAN_TYPE_TABLE does not exist
drop type dbms_xplan_type
ERROR at line 1:
ORA-04043: object DBMS_XPLAN_TYPE does not exist
Type created.
ERROR at line 1:
ORA-00942: table or view does not exist
DROP TABLE ODCI_WARNINGS$
ERROR at line 1:
ORA-00942: table or view does not exist
Type created.
Table truncated.
drop sequence dbms_lock_id
ERROR at line 1:
ORA-02289: sequence does not exist
Sequence created.
drop table SYSTEM.AQ$_Internet_Agent_Privs
ERROR at line 1:
ORA-00942: table or view does not exist
drop table SYSTEM.AQ$_Internet_Agents
ERROR at line 1:
ORA-00942: table or view does not exist
Table created.
DROP SYNONYM def$_tran
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist
DROP SYNONYM def$_call
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist
DROP SYNONYM def$_defaultdest
ERROR at line 1:
DROP TYPE SYS.ExplainMVMessage FORCE
ERROR at line 1:
ORA-04043: object EXPLAINMVMESSAGE does not exist
Type created.
drop view sys.transport_set_violations
ERROR at line 1:
ORA-00942: table or view does not exist
PL/SQL procedure successfully completed.
drop table sys.transts_error$
ERROR at line 1:
ORA-00942: table or view does not exist
drop operator XMLSequence
ERROR at line 1:
ORA-29807: specified operator does not exist
drop function XMLSequenceFromXMLType
ERROR at line 1:
ORA-04043: object XMLSEQUENCEFROMXMLTYPE does not exist
drop function XMLSequenceFromRefCursor
ERROR at line 1:
drop function XMLSequenceFromRefCursor2
ERROR at line 1:
ORA-04043: object XMLSEQUENCEFROMREFCURSOR2 does not exist
drop type XMLSeq_Imp_t
ERROR at line 1:
ORA-04043: object XMLSEQ_IMP_T does not exist
drop type XMLSeqCur_Imp_t
ERROR at line 1:
ORA-04043: object KU$_IND_PART_T does not exist
drop type ku$_ind_part_list_t force
ERROR at line 1:
ORA-04043: object KU$_IND_PART_LIST_T does not exist
drop type ku$_piot_part_t force
ERROR at line 1:
Grant succeeded.
Synonym created.
Grant succeeded.
Package altered.
Package altered.
PL/SQL procedure successfully completed.

@$oracle_home/rdbms/admin/catalog.sql

These errors are ignorable, Oracle just trying to drop the package before creating them. If this is the first time you run catproc.sql, the errors are expected.

Similar Messages

Hi All,
We are in process of CU&UC during the unicode process , we have exported the DB and during Import during create database phase we are facing this problem..
Please suggest.....
@@/oracle/RSS/102_64/rdbms/admin/catproc.sql
exit;
Executed with error.
Thanks,
Subhash.G
Some more errors:
Below error from sapinst.log for reference .
INFO 2007-11-03 06:19:35 Removing file /tmp/sapinst_instdir/NW04S/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/ora_query3_tmp0_1.sql. INFO 2007-11-03 06:19:35 Creating file /tmp/sapinst_instdir/NW04S/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/ora_query3_tmp0_1.sql. ERROR 2007-11-03 06:43:42 CJS-00084 SQL statement or script failed.
DIAGNOSIS: Error message: ORA-955 for defaultdest ERROR 2007-11-03 06:43:45 MUT-03025 Caught ESAPinstException in Modulecall: ESAPinstException: error text undefined. ERROR 2007-11-03 06:43:47 FCO-00011 The step runCatprocSql with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbBuild|ind|ind|ind|ind|5|0|runCatprocSql was executed with status ERROR . INFO 2007-11-03 06:53:37 An error occured and the user decide to stop.n Current step '|NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbBuild|ind|ind|ind|ind|5|0|runCatprocSql'
Error from ora_sql.log
@@/oracle/RSS/102_64/rdbms/admin/catproc.sql exit; Executed with error.
Thanks
After I make database changes I have to run utlrp.sql to compile all the invalid objects. I know how to do it from the host. But now I'm running this release from the OEM as sql jobs.
Is there any equivalent of @?/rdbms/sadmin/utlrp.sql running from OEM?
error msg:
DOC> 2. Query showing UTL_RECOMP jobs that are running
DOC> SELECT job_name FROM dba_scheduler_running_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#
utl_recomp.recomp_parallel(threads);
ERROR at line 4:
ORA-06550: line 4, column 4:
PLS-00201: identifier 'UTL_RECOMP.RECOMP_PARALLEL' must be declared
ORA-06550: line 4, column 4:
PL/SQL: Statement ignored
Elapsed: 00:00:00.01
SELECT dbms_registry_sys.time_stamp('utlrp_end') as timestamp from dual
ERROR at line 1:
ORA-00904: 'DBMS_REGISTRY_SYS'.'TIME_STAMP': invalid identifier
Elapsed: 00:00:00.00
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.01
DOC> The following query reports the number of objects that have compiled
DOC> with errors (objects that compile with errors have status set to 3 in
DOC> obj$). If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#
select COUNT(*) 'OBJECTS WITH ERRORS' from obj$ where status = 3
ERROR at line 1:
ORA-00942: table or view does not exist
Hi,
How can you create job in OEM to use EXEC UTL_RECOMP.recomp_serial(); inorder to compile all db objects.
I tried few things but all resulting in error.
I am creating OEM job as SQL script and where it ask for SQL script I am giving below code:
1.
WHENEVER SQLERROR EXIT FAILURE;
EXEC UTL_RECOMP.recomp_serial;Error:
SQL> SQL> SQL> SQL> SQL> BEGIN utl_recomp.recomp_serial ; END;
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'UTL_RECOMP.RECOMP_SERIAL' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
2.when trying with using utlrp.sql:
WHENEVER SQLERROR EXIT FAILURE;
@?/rdbms/admin/utlrp.sql;Error:
SQL> SQL> SQL> SQL> SQL> SELECT dbms_registry_sys.time_stamp('utlrp_bgn') as timestamp from dual
ERROR at line 1:
ORA-00904: 'DBMS_REGISTRY_SYS'.'TIME_STAMP': invalid identifier
I can run utlrp.sql without any error manually from sql prompt as sys user.
I am login into OEM as SYSTEM user and also with user who has privilege for backup.
thanks,
Ello,
I create a base manually
when I execute the command
sqlplus /nolog
connect /as sysdba
@Oracle_expressapporacleproduct11.2.0serverrdbmsadmincatalog.sql
a the end I have the error
Comment created.
Comment created.
Grant succeeded.
DOC>######################################################################
DOC>######################################################################
DOC> The following PL/SQL block will cause an ORA-20000 error and
DOC> terminate the current SQLPLUS session if the user is not SYS.
DOC> Disconnect and reconnect with AS SYSDBA.
DOC>######################################################################
DOC>######################################################################
DOC>#
DECLARE
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible
Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
Somebody have an idea for resolve my issue please ??
Thank
TRy this may help u
CLASSY DBA: ORA-06553: PLS-213: package STANDARD not accessible
jdk1.6
oracle jdc driver - ojdbc14.jar
when oracle throw exception I get somethin like this:
[02 Jul 2010 20:10:36.145] com.mycompany.myproject.db.OracleStrategy.insertM2Document(OracleStrategy.java:147) ERROR:
? ??????? ??????????? ???????? IN ??? OUT:: 62
java.sql.SQLException: ? ??????? ??????????? ???????? IN ??? OUT:: 62
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1729)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3365)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
at com.mycompany.myproject.db.OracleStrategy.insertToDB(OracleStrategy.java:50)
at com.mycompany.myproject.db.OracleStrategy.insertM2Document(OracleStrategy.java:139)
at com.mycompany.myproject.db.DBManagerContext.insertM2Document(DBManagerContext.java:129)
at com.mycompany.myproject.util.M2EIManager.importToOutM2PackDocuments(M2EIManager.java:154)
at com.mycompany.myproject.views.OutgoingTabView.actionPerformed(OutgoingTabView.java:104)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
what is this symbols ??????. Why oracle don't get clear error message?
The wrong character set encoding. Either by reading from the db or by displaying the error.
Dears,
The application runs SQLs against Oracle via oracle client(actually the app is IBM Cognos which shows report and the data is from oracle database). So, for a report which fails to run, I want to check the sql and the error message for this failed sql statement. Where is the message stored, client or server and How to get it?
I know there is a view v$log used to check the sqls ran in database but here I mean the failed sqls....
Thanks,
Ricky Ru
969543 wrote:
The application only presents the application error message.. And it is not helpful for me to get the root cause..The application uses the Oracle Call Interface to communicate with the database server. OCI calls return a result code to the client. The client is expected to call OCIErrorGet() to get the full error text.
If the client does not do this, or obfuscate the server error, or suppress the server error? Crappy client. The lack of the client to play its role as client, correctly within the documented client-server architecture, is solely the client's problem. Not the server.
For DB2, I could use db2diag to check the log. why oracle can not do this? any thoughts?Because Oracle is not stupid? Why on sweet mother earth waste server resources to track client application errors, on behalf of clients? How does this make ANY sense!?
Oracle server's handles 1000's of SQL executions per second. Just where is it to find sufficient space to log application errors (not database system errors) at that rate? How do you justify that overhead? Using the argument that the application is poorly designed or written? Come on!
Hi,
I want to return a relevant Error Message whenever an SQL Exception occurs. For e.g. If a unique Constraint exists i want to return a relevant message like 'A record already exists.' Can i do the same?
Maybe a good feature to have in the next version of Oracle, if it doesnt exist :)
Regards,
As 3360 points out, you cannot do this at the sql level (and a good thing too), but if you encapsulate all of your DML logic into packages (which is generally a good thing to do), then you can return wehat ever you want as an error message.
SQL> CREATE TABLE t (id NUMBER PRIMARY KEY, descr VARCHAR2(10));
Table created.
SQL> CREATE PACKAGE t_pkg AS
2 PROCEDURE ins_t (p_id IN NUMBER,
3 p_descr IN VARCHAR2);
4 PROCEDURE upd_t (p_id IN NUMBER,
5 p_descr IN VARCHAR2);
6 PROCEDURE del_t (p_id IN NUMBER);
7 END;
8 /
Package created.
SQL> l
1 CREATE PACKAGE BODY t_pkg AS
2 null_id EXCEPTION;
3 no_record EXCEPTION;
4 PRAGMA EXCEPTION_INIT (null_id, -1400);
5
6 PROCEDURE ins_t (p_id IN NUMBER,
7 p_descr IN VARCHAR2) IS
8 BEGIN
9 INSERT INTO t VALUES(p_id, p_descr);
10 EXCEPTION
11 WHEN dup_val_on_index THEN
12 RAISE_APPLICATION_ERROR (-20001, 'what do u think u r trying to do!!!');
13 WHEN null_id THEN
14 RAISE_APPLICATION_ERROR (-20002, 'gimme a break I need an ID');
15 WHEN OTHERS THEN
16 RAISE_APPLICATION_ERROR (-20003, 'now I'm really confused');
17 END;
18
19 PROCEDURE upd_t (p_id IN NUMBER,
20 p_descr IN VARCHAR2) IS
21 BEGIN
22 UPDATE t
23 SET descr = p_descr
24 WHERE id = p_id;
25 IF sql%ROWCOUNT = 0 THEN
26 RAISE no_record;
27 END IF;
28 EXCEPTION
29 WHEN no_record THEN
30 RAISE_APPLICATION_ERROR (-20004, 'It's not there so I'm not doing it');
31 WHEN OTHERS THEN
32 RAISE_APPLICATION_ERROR (-20003, 'now I'm really confused');
33 END;
34
35 PROCEDURE del_t (p_id IN NUMBER) IS
36 BEGIN
37 DELETE FROM t
38 WHERE id = p_id;
39 IF sql%ROWCOUNT = 0 THEN
40 RAISE no_record;
41 END IF;
42 EXCEPTION
43 WHEN no_record THEN
44 RAISE_APPLICATION_ERROR (-20004, 'It's not there so I'm not doing it');
45 WHEN OTHERS THEN
46 RAISE_APPLICATION_ERROR (-20003, 'now I'm really confused');
47 END;
48 END;
49 /
Package body created.
SQL> exec t_pkg.ins_t(1, 'One');
PL/SQL procedure successfully completed.
SQL> exec t_pkg.ins_t(1, 'One');
BEGIN t_pkg.ins_t(1, 'One'); END;
ERROR at line 1:
ORA-20001: what do u think u r trying to do!!!
ORA-06512: at 'OPS$ORACLE.T_PKG', line 12
ORA-06512: at line 1
SQL> exec t_pkg.upd_t(2, 'Two');
BEGIN t_pkg.upd_t(2, 'Two'); END;
ERROR at line 1:
ORA-20004: It's not there so I'm not doing it
ORA-06512: at 'OPS$ORACLE.T_PKG', line 30
ORA-06512: at line 1
SQL> exec t_pkg.upd_t(1, 'Way too long for the field');
BEGIN t_pkg.upd_t(1, 'Way too long for the field'); END;
ERROR at line 1:
ORA-20003: now I'm really confused
ORA-06512: at 'OPS$ORACLE.T_PKG', line 32
ORA-06512: at line 1TTFN
John
P.S. 3360, thanks for the IM error message, I just might use it.
HI,
I TYPE THE FOLLOWING QUERY FOR THE ORDER_INFO VIEW
INSERT INTO orders
(id, orderdate, status, c_id)
VALUES(1, TO_DATE('18-JUN-2006', 'DD-MON-YYYY'), 'B', 1);
ORACLE RETURNED THE ERROR MESSAGES AS FOLLOWS:
ERROR AT LINE 1:
ORA-00001: unique constraint (HANDSONXE05.ORDERS_PK) violated
Normally, primary keys will be generated by a sequence, in which case your INSERT statement would use <<sequence name>>.nextval for the ID column. Otherwise, you would have to use an ID that hadn't been used before in the table.
Justin
Hi All,
We have an oracle report server (or service) in Oracle application server 10gR2 running in Red Hat Enterprise Linux 4.5. And it was working fine.
But recently it gives some error message in the terminal like below.
java.lang.Exception
at com.sun.corba.se.internal.iiop.IIOPConnection.cleanUp(IIOPConnection.java:903)
at com.sun.corba.se.internal.iiop.ConnectionTable.cleanUp(ConnectionTable.java:303)
at com.sun.corba.se.internal.iiop.ConnectionTable.checkConnectionTable(ConnectionTable.java:320)
at com.sun.corba.se.internal.iiop.ListenerThread.run(ListenerThread.java:75)
java.lang.Exception
at com.sun.corba.se.internal.iiop.IIOPConnection.cleanUp(IIOPConnection.java:903)
at com.sun.corba.se.internal.iiop.ConnectionTable.cleanUp(ConnectionTable.java:303)
at com.sun.corba.se.internal.iiop.ConnectionTable.checkConnectionTable(ConnectionTable.java:320)
at com.sun.corba.se.internal.iiop.ListenerThread.run(ListenerThread.java:75)
java.lang.Exception
at com.sun.corba.se.internal.iiop.IIOPConnection.cleanUp(IIOPConnection.java:903)
at com.sun.corba.se.internal.iiop.ConnectionTable.cleanUp(ConnectionTable.java:303)
at com.sun.corba.se.internal.iiop.ConnectionTable.checkConnectionTable(ConnectionTable.java:320)
at com.sun.corba.se.internal.iiop.ListenerThread.run(ListenerThread.java:75)
java.lang.Exception
at com.sun.corba.se.internal.iiop.IIOPConnection.cleanUp(IIOPConnection.java:903)
at com.sun.corba.se.internal.iiop.ConnectionTable.cleanUp(ConnectionTable.java:303)
at com.sun.corba.se.internal.iiop.ConnectionTable.checkConnectionTable(ConnectionTable.java:320)
at com.sun.corba.se.internal.iiop.ListenerThread.run(ListenerThread.java:75)
java.lang.Exception
at com.sun.corba.se.internal.iiop.IIOPConnection.cleanUp(IIOPConnection.java:903)
at com.sun.corba.se.internal.iiop.ConnectionTable.cleanUp(ConnectionTable.java:303)
at com.sun.corba.se.internal.iiop.ConnectionTable.checkConnectionTable(ConnectionTable.java:320)
at com.sun.corba.se.internal.iiop.ListenerThread.run(ListenerThread.java:75)
When I restart the report server it works fine for a while and the error message appears again.
Dear Experts,Please response early.
Please check at http://<server>/dev60html/runrep.htm for follwings :
01. your test.rdf must be in report60 folder
02. your db must contain scott user
03. connect string must be tested and give the same inplace of test
04. your webhost may contain a dot, please check this should be the same as yours
hope this will help
bye !
When on a message board, and I try to post a comment, this Error Message comes up:
AN ERROR OCCURED WITH THE SQL SERVER. This is not a problem with the
IPS Community Suite, but rather with your SQL server. Please contact your host and copy the
message shown.
What is causing this? Thank you
Hi gingerlee003,
If I understand correctly, you are log on a website or a system. The error message occurs when you trying to post a comment on it.
This issue may occur if the website is not available or under maintenance. The problem seems to be on the website's end, not yours. Either the database is down and their 'data' is not retrievable at the moment or the webmaster coded something wrong.
Once their database is back up and running you will be able to see the website again. You can do is wait a bit and try again or contact the webmaster to check for the issue. If you want to troubleshoot this issue, please refer to the log file.By default, the
error log is located at Program FilesMicrosoft SQL ServerMSSQL.nMSSQLLOGERRORLOG and
ERRORLOG.n files.
If there are any other questions, please feel free to ask.
Thanks,
Katherine Xiong
Katherine Xiong
TechNet Community Support
Dear Expert,
I have issue when running recompile db by using below statement in Oracle RAC db.
SELECT dbms_registry.time_stamp('utlrp_bgn') as timestamp from dual
ERROR at line 1:
ORA-00904: 'DBMS_REGISTRY'.'TIME_STAMP': invalid identifier
Regard
Liang
timestamp not found below
SQL> desc dbms_registry
PROCEDURE CHECK_SERVER_INSTANCE
FUNCTION COMP_NAME RETURNS VARCHAR2
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
PROCEDURE DELETE_PROGRESS_ACTION
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
ACTION VARCHAR2 IN
PROCEDURE DOWNGRADED
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
OLD_VERSION VARCHAR2 IN
PROCEDURE DOWNGRADING
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
OLD_NAME VARCHAR2 IN DEFAULT
OLD_PROC VARCHAR2 IN DEFAULT
OLD_SCHEMA VARCHAR2 IN DEFAULT
OLD_PARENT VARCHAR2 IN DEFAULT
FUNCTION GET_DEPENDENT_COMPS RETURNS COMP_DEPEND_LIST_T
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
FUNCTION GET_DEPENDENT_COMPS_REC RETURNS TABLE OF RECORD
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
FUNCTION GET_PROGRESS_STEP RETURNS NUMBER
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
ACTION VARCHAR2 IN
FUNCTION GET_PROGRESS_VALUE RETURNS VARCHAR2
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
ACTION VARCHAR2 IN
FUNCTION GET_REQUIRED_COMPS RETURNS COMP_DEPEND_LIST_T
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
FUNCTION GET_REQUIRED_COMPS_REC RETURNS TABLE OF RECORD
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
PROCEDURE INVALID
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
FUNCTION IS_COMPONENT RETURNS BOOLEAN
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
FUNCTION IS_IN_REGISTRY RETURNS BOOLEAN
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
FUNCTION IS_LOADED RETURNS NUMBER
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
VERSION VARCHAR2 IN DEFAULT
FUNCTION IS_STARTUP_REQUIRED RETURNS NUMBER
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
FUNCTION IS_VALID RETURNS NUMBER
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
VERSION VARCHAR2 IN DEFAULT
PROCEDURE LOADED
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
COMP_VERSION VARCHAR2 IN DEFAULT
COMP_BANNER VARCHAR2 IN DEFAULT
PROCEDURE LOADING
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
COMP_NAME VARCHAR2 IN
COMP_PROC VARCHAR2 IN DEFAULT
COMP_SCHEMA VARCHAR2 IN DEFAULT
COMP_PARENT VARCHAR2 IN DEFAULT
PROCEDURE LOADING
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
COMP_NAME VARCHAR2 IN
COMP_PROC VARCHAR2 IN
COMP_SCHEMA VARCHAR2 IN
COMP_SCHEMAS SCHEMA_LIST_T IN
COMP_PARENT VARCHAR2 IN DEFAULT
FUNCTION NOTHING_SCRIPT RETURNS VARCHAR2
FUNCTION PREV_VERSION RETURNS VARCHAR2
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
PROCEDURE REMOVED
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
PROCEDURE REMOVING
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
PROCEDURE RESET_VERSION
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
FUNCTION SCHEMA RETURNS VARCHAR2
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
FUNCTION SCHEMA_LIST RETURNS SCHEMA_LIST_T
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
FUNCTION SCHEMA_LIST_STRING RETURNS VARCHAR2
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
FUNCTION SCRIPT RETURNS VARCHAR2
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
SCRIPT_NAME VARCHAR2 IN
FUNCTION SCRIPT_PATH RETURNS VARCHAR2
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
FUNCTION SCRIPT_PREFIX RETURNS VARCHAR2
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
FUNCTION SESSION_NAMESPACE RETURNS VARCHAR2
PROCEDURE SET_COMP_NAMESPACE
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
NAMESPACE VARCHAR2 IN
PROCEDURE SET_PROGRESS_ACTION
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
ACTION VARCHAR2 IN
VALUE VARCHAR2 IN DEFAULT
STEP NUMBER IN DEFAULT
PROCEDURE SET_PROGRESS_STEP
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
ACTION VARCHAR2 IN
STEP NUMBER IN
PROCEDURE SET_PROGRESS_VALUE
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
ACTION VARCHAR2 IN
VALUE VARCHAR2 IN
PROCEDURE SET_REQUIRED_COMPS
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
COMP_DEPEND_LIST COMP_DEPEND_LIST_T IN
PROCEDURE SET_REQUIRED_COMPS
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
COMP_DEPEND_LIST TABLE OF RECORD IN
PROCEDURE SET_SESSION_NAMESPACE
Argument Name Type In/Out Default?
NAMESPACE VARCHAR2 IN
PROCEDURE STARTUP_COMPLETE
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
PROCEDURE STARTUP_REQUIRED
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
FUNCTION STATUS RETURNS VARCHAR2
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
FUNCTION STATUS_NAME RETURNS VARCHAR2
Argument Name Type In/Out Default?
STATUS NUMBER IN
FUNCTION SUBCOMPONENTS RETURNS TABLE OF VARCHAR2(30)
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
COMP_OPTION NUMBER IN DEFAULT
PROCEDURE UPDATE_SCHEMA_LIST
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
COMP_SCHEMAS SCHEMA_LIST_T IN
PROCEDURE UPGRADED
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
NEW_VERSION VARCHAR2 IN DEFAULT
NEW_BANNER VARCHAR2 IN DEFAULT
PROCEDURE UPGRADING
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
NEW_NAME VARCHAR2 IN DEFAULT
NEW_PROC VARCHAR2 IN DEFAULT
NEW_SCHEMA VARCHAR2 IN DEFAULT
NEW_PARENT VARCHAR2 IN DEFAULT
PROCEDURE UPGRADING
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
NEW_NAME VARCHAR2 IN
NEW_PROC VARCHAR2 IN
NEW_SCHEMA VARCHAR2 IN
NEW_SCHEMAS SCHEMA_LIST_T IN
NEW_PARENT VARCHAR2 IN DEFAULT
PROCEDURE VALID
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
FUNCTION VERSION RETURNS VARCHAR2
Argument Name Type In/Out Default?
COMP_ID VARCHAR2 IN
SQL>
Hi there,
I have a multi block application. I have a check constraint in the database which checks for value > 0 and not null.
Now in the form if i try to insert/update a null into the column, i get FRM-40735 Onerror raised unhandled exception. When i click on Display error it shows the constraint violated. I want to show the constraint when user clicks on save button i.e commits form.
In the on error trigger, both block and form level i have
DECLARE
lv_errcod NUMBER := ERROR_CODE;
lv_errtyp VARCHAR2(300) := ERROR_TYPE;
lv_errtxt VARCHAR2(800) := ERROR_TEXT;
BEGIN
if lv_errcod = 40509 or 40508 then
message(' bad update');
else
Message(lv_errtyp||'-'||to_char(lv_errcod)||': '||lv_errtxt);
Raise form_trigger_failure;
end if;
END;
I dunno why i get unhandled exception.
Any help is appreciated.
Thanks
I'm not sure what your question is but if it's how to get the same error as
display error, then put in:
display_error in an on_error trigger on the block(s):
for example on_error trigger:
declare
errnum number := ERROR_CODE;
errtxt varchar2(80) := ERROR_TEXT;
errtype varchar2(3) := ERROR_TYPE;
field_name varchar2(30);
begin
field_name := substr(:system.trigger_field,instr(:system.trigger_field,'.') + 1);
mess( 'ERROR ' || field_name || ': ' ||errtxt);
display_error;
raise form_trigger_failure;
end;
**** mess is a routine I include for which you need to define an alert of style NOTE.
PROCEDURE mess (mymess varchar2) is
alert_value number;
BEGIN
set_alert_property('DATA_ALERT',ALERT_MESSAGE_TEXT,
mymess);
synchronize;
bell;
alert_value := SHOW_ALERT('DATA_ALERT');
END;
Hi,
What's in your point of view the best books about Oracle 9i ?
Covering administration & PL/SQL as well(on Windows platform).
Thanks for your advices.
Regards.
jeff
Hi
It seems u are new and going to study Oracle.From your query its clear that u are looking DBA track.My sugession better go for Oracle DBA course materials which is published by Oracle university itself.This is simple and its covering most of the topics with beautiful presentation.
SQL
Fundamentals 1
Fundamentals 11
Performance turning
Plsql
You will get this from Oracle's authorised training centers.
cheers
Antony
I get an error saying, ' a non value for j_servPort' It list the folder Apacheports.ini to where it can't create. I am installing the 'Transaction Processing' Database Configuration Environment
Thanks,
Jay
Hi,
are you sure that the Oracle software you downloaded is complete? Is it possible that some part(s) is missing? If you can, try downloading the software again (including the md5sums) and compare them with your downloaded files before beginning.
HTH
Martin
On our new install when I try to start the DB with either dbstart or sqlplus I get the following error:
SQLPlus : error while loading shared libraries
/usr/opt/oracle/product/9.2.0/libclntsh.so.9.0 ; invalid ELF header.
We have Oracle 9 on RH linux 8
Any ideas?
Thanks
this indicates a corrupted ORACLE client library. please reinstall or contact customer service.