Wednesday, May 17, 2017

ERROR: ORA-28009:

I was try to connect sys to dba. It gives an error

set your profile.
 update your initSID.ora file 
as O7_DICTIONARY_ACCESSIBILITY=TRUE 

shutdown db
startup pfile= 'pfile location'

sqlplus sys/xxxx
connected.



Remote password file


Source your db profile . .SID

enter orapwd


Usage: orapwd file= entries= force= ignorecase= nosysdba=

  where
    file - name of password file (required),
    password - password for SYS will be prompted if not specified at command line,
    entries - maximum number of distinct DBA (optional),
    force - whether to overwrite existing file (optional),
    ignorecase - passwords are case-insensitive (optional),
    nosysdba - whether to shut out the SYSDBA logon (optional Database Vault only).
   

  There must be no spaces around the equal-to (=) character.



orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID entries=5 force=y ignorecase=y nosysdba=n

Enter password for SYS:xxxxxxx

after completed.

you can see the orapwSID file find in ORACLE_HOME/dbs/orapwSID

shutdown your database   and add the entry in your initSID.ora

remote_login_passwordfile='EXCLUSIVE'


to check 
select * from v$pwfile_users;



Tuesday, May 16, 2017

Reconfigurating wLS domain 12.2.1 - decreases the time

  1. Caution: Once the domain reconfiguration process starts, it is irreversible. Prior to using the Reconfiguration Wizard or WLST to upgrade the domain, ensure that you have backed up the domain. If an error or other interruption occurs during the reconfiguration process, you must restore the domain by copying the files and directories from the backup location to the original domain directory. This is the only way to ensure that the domain has been returned to its original state prior to reconfiguration.
  2. Set the CONFIG_JVM_ARGS environment variable to the following value to use the operating system's random number generator:
    -Djava.security.egd=file:/dev/./urandom
    This decreases the amount of time it takes for the Reconfiguration Wizard to reconfigure a domain.
  3. export CONFIG_JVM_ARGS=-Djava.security.egd=file:/dev/./urandom

Wednesday, May 3, 2017

how to check your ssl connection from unix server

openssl s_client -connect (url) example: xxx.xxx.com:1223

Tuesday, April 11, 2017

Convert to Oracle wallet to jks

  • Make sure your fusion middleware profile execute 
  • Make sure your JAVA HOME is correct if not you will get error


             ERROR: No Java
              /apps/oracle/product/WT/oracle_common/jdk or $JAVA_HOME should point to valid Java runtime

      wallet file should be located in your directory. 
       example ewallet.p12, ewallet.sso(optional)


./ is current location.


/apps/oracle/product/WT/oracle_common/bin/orapki wallet pkcs12_to_jks -wallet ./ -pwd xxxxxxx -jksKeyStoreLoc ./yourdesire.jks -jksKeyStorepwd xxxxxxxx


/apps/oranist/jre1.6.0_24/bin/keytool -list -v  -keystore prince.test.jks


/apps/oranist/jre1.6.0_24/bin/keytool -changealias -keystore yourdesire.jks -alias orakey -destalias desirename

Thursday, March 30, 2017

Where to Tune to your weblogic server

First, find out your weblogic JAVA_HOME.

1. cd $DOMAIN_HOME/bin/

2. grep JAVA_HOME setDomainEnv.sh

you can see the JAVA_HOME.


3. cd $JAVA_HOME/jre/lib/security/

4. Take backup of java.security cp -i java.security java.security_org

grep securerandom  java.security

you can see the securerandom.source=file:/dev/random

change to securerandom.source=file:/dev/./urandom.

save the file and start the weblogic server, you can see the different.


Wednesday, March 22, 2017

TIU 12.2

Running the Technology Inventory Utility

The Technology Inventory Utility generates a consolidated report that summarizes the version levels of all installed technology stack components.
Set your Oracle E-Business Suite environment, then run one of the following commands:

On UNIX:

Application tier:
perl $FND_TOP/patch/115/bin/TXKScript.pl 
-script=$FND_TOP/patch/115/bin/txkInventory.pl 
-txktop=$APPLTMP  
-contextfile=$CONTEXT_FILE 
-appspass=apps 
-outfile=$APPLTMP/Report_Inventory.html
Database tier:
perl $ORACLE_HOME/appsutil/bin/TXKScript.pl 
-script=$ORACLE_HOME/appsutil/bin/txkInventory.pl 
-txktop=$ORACLE_HOME/appsutil/temp 
-contextfile=$CONTEXT_FILE 
-appspass=apps 
-outfile=$ORACLE_HOME/appsutil/temp/Report_Inventory.html