Tuesday, July 11, 2017

After linux patch oracle Report was not working in R12 .1 application

Error : emsg:was terminated by signal 11
Enter Password:

Program was terminated by signal 11
Concurrent Manager encountered an error while running Oracle*Report



 solution :Report Server will not Start After Linux Kernel OS Updates (Doc ID 2280616.1)

Friday, June 16, 2017

OID configuration issue

I was running config.sh from $MW_HOME/Oracle_IDM1/bin, Bootstrap complete 100% and configure oracle Identity management components was stuck @14%.

I look at the log oidctl.log. $MW_HOME/asinst_1/diagnostics/log/OID/oid1/oidctl.log


[2017-06-16T12:06:50.410657-04:00] [OID] [NOTIFICATION:16] [] [] [host:xxxxxxx [pid: 17936] [tid: 0] OIDCTL:: WARNING: Connected to incorrect OID base schema version, (version=OID 11.1.1.5.0
).

My oid version is 11.1.1.9.0.

solution is the below

SQL> select owner,version,status from schema_version_registry;

OWNER                          VERSION                        STATUS
------------------------------ ------------------------------ -----------
DEV_MDS                        11.1.1.7.0                     VALID
ODS                            11.1.1.7.0                     VALID
DEV_ORASDPM                    11.1.1.7.0                     VALID
DEV_SOAINFRA                   11.1.1.7.0                     VALID


SQL> select attrval from ods.ds_attrstore where entryid= 1 and attrname = 'orcldirectoryversion';

ATTRVAL
--------------------------------------------------------------------------------
OID 11.1.1.5.0

SQL> update ods.ds_attrstore set attrval='OID 11.1.1.9.0' where entryid= 1 and attrname = 'orcldirectoryversion';

1 row updated.

SQL> commit;

Commit complete.


 $rm -rf user_projects
$rm -rf asinst_1

I restarted my configuration, It completed 100%.


Thursday, June 15, 2017

String X.500 AttributeType

String  X.500 AttributeType
------------------------------
CN      commonName
L       localityName
ST      stateOrProvinceName
O       organizationName
OU      organizationalUnitName
C       countryName
STREET  streetAddress
DC      domainComponent
UID     userid

Friday, June 2, 2017

XATRANS views are not Installed. OIM RCU



  Error:  XATRANS Views are not installed on this Database. This is required by the OIM Schema
  Action: Install view XAVIEWS as SYS user on this Database.

          Refer to the Oracle Database Release Documentation for installation details.

Cd $ORACLE_HOME/javavm/install
Sqlplus ‘/as sysdba’

SQL> sta initxa.sql

PL/SQL procedure successfully completed.


JVMRMACTION
--------------------------------
FULL_REMOVAL


PL/SQL procedure successfully completed.


Package created.


Package body created.


Synonym created.


Grant succeeded.

SQL>exit
Cd $ORACLE_HOME/rdbms/admin/
Sqlplus ‘/as sysdba’

SQL> sta xaview.sql

SQL> sta xaview.sql
DROP VIEW v$xatrans$
*
ERROR at line 1:
ORA-00942: table or view does not exist


DROP VIEW v$pending_xatrans$
*
ERROR at line 1:
ORA-00942: table or view does not exist



View created.


View created.

SQL>

Friday, May 26, 2017

How to Install ORDS 3.0.9.348.07.16

Things to check first.

1. check you init.ora file has an entry remote_login_passwordfie.
2. loin into sql and check your param at sql prompt show param remote_login.
3. create orapwSID file, It should locate ORACLE_HOME/dbs
4. select * from v$pwfile_users. you will get one row selected.
5 . Refer ORACLE TEST Data Services Install and config Guide E56293-11

/uo1/scratch/ords
webserver$/u01/product/jdk80121/bin/java -jar test_ebs.war install advanced
This Oracle REST Data Services instance has not yet been configured.
Please complete the following prompts

Enter the location to store configuration data:/u01/scratch/ords/config
Enter the name of the database server [localhost]:servername
Enter the database listen port [1521]:0000
Enter 1 to specify the database service name, or 2 to specify the database SID [1]:2
Enter the database SID [xe]:SID
Enter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step [1]:
Enter the database password for ORDS_PUBLIC_USER:
Confirm password:
Please login with SYSDBA privileges to verify Oracle REST Data Services schema.

Enter the username with SYSDBA privileges to verify the installation [SYS]:
Enter the database password for SYS:
Confirm password:
Enter the default tablespace for ORDS_METADATA [SYSAUX]:    
Enter the temporary tablespace for ORDS_METADATA [TEMP]:
Enter the default tablespace for ORDS_PUBLIC_USER [SYSAUX]:
Enter the temporary tablespace for ORDS_PUBLIC_USER [TEMP]:
Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:
Enter the PL/SQL Gateway database user name [APEX_PUBLIC_USER]:XXX_ORDS
Enter the database password for XXX_ORDS:
Confirm password:
Enter 1 to specify passwords for Application Express RESTful Services database users (APEX_LISTENER, APEX_REST_PUBLIC_USER) or 2 to skip this step [1]:2
May 26, 2017 12:51:26 PM 
INFO: Updated configurations: defaults, apex, apex_pu
Installing Oracle REST Data Services version 3.0.9.348.07.16
... Log file written to /apps2/scratch/ords/logs/ords_install_core_2017-05-26_125126_00397.log
... Verified database prerequisites
... Created Oracle REST Data Services schema
... Created Oracle REST Data Services proxy user
... Granted privileges to Oracle REST Data Services
... Created Oracle REST Data Services database objects
... Log file written to /u01/scratch/ords/logs/ords_install_datamodel_2017-05-26_125148_00039.log
Completed installation for Oracle REST Data Services version 3.0.9.348.07.16. Elapsed time: 00:00:23.509

Enter 1 if you wish to start in standalone mode or 2 to exit [1]:2
$
Verify your configuration directory
$/u01/product/jdk80121/bin/java -jar test_ebs.war configdir      
May 26, 2017 12:55:07 PM 
INFO: The config.dir value is /u01/scratch/ords/config

Depoly war file in weblogic




Wednesday, May 24, 2017

ORA-28040


In sqlnet.ora 

SQLNET.allowed_logon_version=10

It cause an error ORA-28040


Enter user-name:
ERROR:

ORA-28040: No matching authentication protocol

Thursday, May 18, 2017

How to extract Private key from wallet

openssl pkcs12 -in /home/oracle/wallet/ewallet.p12 -nocerts -out private_key.pem

Enter Import Password:
MAC verified OK
Enter PEM pass phrase:
Verifying - Enter PEM pass phrase:

The first password that openssl asks (Enter Import Password) is the wallet password.
The other password (Enter PEM pass phrase) is used to protect the exported key.