Starting OUI In Xwindows

Installing a Oracle database in Solaris 10 I get the following error;


Starting Oracle Universal Installer…

Checking Temp space: must be greater than 180 MB. Actual 19275 MB Passed
Checking swap space: must be greater than 150 MB. Actual 22670 MB Passed
Checking monitor: must be configured to display at least 256 colors
>>> Could not execute auto check for display colors using command /usr/openwin/bin/xdpyinfo.
Check if the DISPLAY variable is set. Failed <<<<

Some requirement checks failed. You must fulfill these requirements before

continuing with the installation,

Continue? (y/n) [n]


The problem is that the display environment variable is not set. In my case I access with Putty and from Microsoft Windows, so I use an Xwindows client that does this function, I use Xming. The problem is that today I have the blues and I forgot to start the Xming. Running right back and launch the runInstaller everything works fine.


HTH – Antonio NAVARRO.

How to Determine If SPFILE Was Used for Starting Database

Many times we need to know, or be certain whether the database was started using the parameters from a init.ora or spfile file. We can see easily through the spfile parameter. If it do not return any value or null, it used an init.ora, if instead returned value it used an spfile, as in the example
below, in this case a systematic OpenVMS;

 SAPCONSOLIDATION> show parameter spfile

NAME          TYPE        VALUE
_____________ ___________ ______________________________
spfile        string      disk$orasapt102:[orasaptes.dbs]



How To Check If JVM Is Installed

We can verify this with the query below, which must return JAVAVM and CATJAVA in COMP_ID column;


 BDW*ANTO> SELECT comp_id, comp_name FROM dba_registry
  2  ;

COMP_ID                        COMP_NAME
______________________________ ______________________________________
CATPROC                        Oracle Database Packages and Types
CATALOG                        Oracle Database Catalog Views
XDB                            Oracle XML Database
JAVAVM                         JServer JAVA Virtual Machine
CATJAVA                        Oracle Database Java Packages
XML                            Oracle XDK
EXF                            Oracle Expression Filter




Verify Whether XML DB Is Installed

Many times the question of whether a feature of the Oracle database is installed comes to us. In this case to see if the XML DB is installed can run the following command from a sqlplus;

sqlplus> xquery 1



If it is installed, it return something similar to

Result Sequence


Otherwise will return an error.




ORA-19114 And PLS-00201 Errors

Executing the next command;


WOWT> xquery 1
2 /


I get the following error;


ORA-19114: error during parsing the XQuery expression:
ORA-06550: line 1, column 13:
PLS-00201: identifier ‘SYS.DBMS_XQUERYINT’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


You need install the INITXQRY.SQL package to solve the problem. From SYS user at sqlplus prompt;


SQL> @?ORACLE_HOME/rdbms/admin/initxqry.sql


If you execute the next query, it return two rows;


 WOWT> select * from dba_objects where object_name ='DBMS_XQUERYINT';

OWNER                OBJECT_NAME                              SUBOBJECT_NAME                 
____________________ ________________________________________ ______________________________ 
SYS                  DBMS_XQUERYINT                           ø                              
SYS                  DBMS_XQUERYINT                           ø                              





ORA-19114 And ORA-29540 Errors

When I’m trying to test DB XML running the following command;

2 /

I receive the following error.

ORA-19114: error during parsing the XQuery expression:
ORA-29540: class oracle/xquery/OXQServer does not exist

You must install initxml.sql package, you must run as sys user the following procedure;

sql> @$?/xdk/admin/initxml.sql