Oracle Application Server Release 2 URL’s

Description:
You can use the below URL to get Oracle Application Server Release 2 Component Pages.

To get Enterprise Manager Console welcome page:
http://Host Address:5500/em
(Username: sys Password: SysPassword)

To get Infrastructure and Business Intelligence Home welcome Page:
http://Host Address:1810
(User name: ias_admin Password: Provided password at the time of Installation)

To get Discoverer Plus Welcome Page:
http://Host Address:7778/discoverer/plus

To get Discoverer Viewer Welcome Page:
http://Host Address:7778/discoverer/viewer

To get Oracle Application Server Portal welcome Page:
http://Host Address:7778/pls/portal (For Portal)
(Single Sign On Username: orcladmin Password: Provided password at the time of Installation)

Note: If the above port did not match, you can check portlist.ini file to get the entire Port list.

PROCEDURE TO START ORACLE APPLICATION SERVER 10g RELEASE 2 (SUN SOLARIS)

Steps to Start Oracle Application Server Infrastructure Home:

Step 1: Listener Control Start up:
$lsnrctl start

Step 2: Application Server Database Start up:
$sqlplus “/as sysdba”
SQL> startup
“Database opened”
SQL>exit

Step 3: Enterprise Manager Control - DB Console for Application Server
Database startup:
$emctl start dbconsole

Step 4: Enterprise Manager control – IAS Console Start up
$emctl start iasconsole

Steps to Start Oracle Application Server Business Intelligence and Forms Home:

Step 1: Set Environment Variable PATH for BI and Forms Home as,
$PATH=/usr/bin:/user/orainfra/BI/bin
$export PATH
$emctl start iasconsole
$exit

How do I check USB drive connected to Solaris x86?

Step 1: Login as root
Step 2: Type cfgadm command to see USB detected or not
#cfgadm

ORA-00904: "DBMS_JAVA"."LONGNAME": invalid identifier

Error Description:

I noticed the below error during expor schema using exp utility

ORA-00904: "DBMS_JAVA"."LONGNAME": invalid identifier

Solution I tried:

Step 1: Login as SYSDBA
Step 2: Execute $ORACLE_HOME/javavm/install/initdbj.sql
Step 3: Re-run export

ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR

Error Description:

I noticed the below error during export schema using exp utility:

EXP-00056: ORACLE error 932 encountered
ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR
EXP-00000: Export terminated unsuccessfully

Solution I tried:

Step 1: Log in as SYSDBA
Step 2: Execute $ORACLE_HOME/rdbms/admin/catmetx.sql
Step 3: Execute $ORACLE_HOME/rdbms/admin/utlrp.sql

PLS-00201: identifier 'SYS.LT_EXPORT_PKG' must be declared

Error Description:

I have noticed the below error during export schema using exp utility:

Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'SYS.LT_EXPORT_PKG' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
EXP-00000: Export terminated unsuccessfully

Solution I tried:

Step 1: Login as SYSDBA
Step 2: GRANT EXECUTE ON sys.lt_export_pkg TO PUBLIC;
Step 3: Re-Run export

Error accessing package DBMS_APPLICATION_INFO

Noticed the below error when I try to connect the database through client.

ERROR:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_OUTPUT.DISABLE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

ERROR:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_APPLICATION_INFO.SET_MODULE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


Error accessing package DBMS_APPLICATION_INFO
SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.

Solution I tried:

I executed the below files after logging in as SYSDBA

SQL>@$ORACLE_HOME/rdbms/admin/dbmsotpt.sql
SQL>@$ORACLE_HOME/rdbms/admin/dbmsapin.sql