Skip to content

Archive for

Jan 14

desc dba_views does not exist in database open stage

While you issued this dba_*  dictionary views on database mount

SQL> alter database mount;

Database altered.

SQL> desc dba_views;
ERROR:
ORA-04043: object dba_views does not exist

After database opened

SQL> alter database open;

Database altered.

SQL> desc dba_views;
ERROR:
ORA-04043: object dba_views does not exist

Don’t issue this command on database mount stage

Restart the database normal

or

SQL> alter system flush shared_pool;

System altered.

SQL> desc dba_views;
Name Null? Type
—————————————– ——– —————————-

OWNER NOT NULL VARCHAR2(30)
VIEW_NAME NOT NULL VARCHAR2(30)
TEXT_LENGTH NUMBER
TEXT LONG
TYPE_TEXT_LENGTH NUMBER
TYPE_TEXT VARCHAR2(4000)
OID_TEXT_LENGTH NUMBER
OID_TEXT VARCHAR2(4000)
VIEW_TYPE_OWNER VARCHAR2(30)
VIEW_TYPE VARCHAR2(30)
SUPERVIEW_NAME VARCHAR2(30)
EDITIONING_VIEW VARCHAR2(1)
READ_ONLY VARCHAR2(1)

Jan 14

8 Comments

ORA-29701: unable to connect to Cluster Synchronization Service

I try to restart asm service, it shows below error

C:\app\mazar\product\11.2.0\grid\BIN>sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 14 11:14:10 2014

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service

C:\app\mazar\product\11.2.0\grid\BIN>crsctl start resource ora.cssd
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Start failed, or completed with errors.

Enable HAS

C:\app\mazar\product\11.2.0\grid\BIN>crsctl enable has
CRS-4622: Oracle High Availability Services autostart is enabled.

C:\app\mazar\product\11.2.0\grid\BIN>crsctl start has
CRS-4123: Oracle High Availability Services has been started.

C:\app\mazar\product\11.2.0\grid\BIN>crs_stat -t
Name Type Target State Host
————————————————————
ora.DATA.dg ora….up.type ONLINE ONLINE trai…6-pc
ora….ER.lsnr ora….er.type ONLINE ONLINE trai…6-pc
ora.asm ora.asm.type ONLINE ONLINE trai…6-pc
ora.asmdb.db ora….se.type ONLINE ONLINE trai…6-pc
ora.cssd ora.cssd.type ONLINE ONLINE trai…6-pc

C:\app\mazar\product\11.2.0\grid\BIN>sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 14 11:22:54 2014

Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Automatic Storage Management option

SQL> select status from v$instance;

STATUS
————
STARTED

Jan 14

How do i check versions of *.fmb?

 

[appltrng@ebsdev ~]$ strings -a /u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/forms/US/GLXCORUN.fmb | grep Header
FDRCSID(‘$Header: APPSTAND.fmb 115.33 2002/04/04 11:13:40 pkm ship $’);
$Header: APPSTAND.fmb 115.33 2002/04/04 11:13:40 pkm ship $
FDRCSID(‘$Header: GLXCORUN.fmb 120.34.12010000.1 2008/07/28 05:17 appldev ship $’);
$Header: GLXCORUN.fmb 120.34.12010000.1 2008/07/28 05:17 appldev ship $
[appltrng@ebsdev ~]$ adident Header /u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/forms/US/GLXCORUN.fmb
/u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/forms/US/GLXCORUN.fmb:
$Header APPSTAND.fmb 115.33 2002/04/04 11:13:40 pkm ship $
$Header APPSTAND.fmb 115.33 2002/04/04 11:13:40 pkm ship $
$Header GLXCORUN.fmb 120.34.12010000.1 2008/07/28 05:17 appldev ship $
$Header GLXCORUN.fmb 120.34.12010000.1 2008/07/28 05:17 appldev ship $

Jan 14

1 Comment

Is any email configuration required for Oracle Alert manager?

Yes. If once you email configured on workflow notification mailer, It will automatically send alert mail to you .No need to configure in oracle alert manager mail server options.

So please check it, Whether workflow notification mailer running or not.