foalabs

How to Rotate or Disable Logging in EmbeddedLDAPAccess.log in Weblogic Solution: The log file EmbeddedLDAPAccess.log is controlled by the parameters the are defined in <Domain_Home>/servers/<Server_Name>/data/ldap/conf/vde.prop. The following attributes should be added to vde.prop to rotate EmbeddedLDAPAccess.log, and the rotation will only happen once a day: vde.logfile=log/EmbeddedLDAP.log vde.logrotate.hour=0 vde.logrotate.minute=10 vde.logrotate.maxlogs=7 vde.accesslogfile=log/EmbeddedLDAPAccess.log Disable logging to this file by removing the file name from the following line  vde.accesslogfile=log/EmbeddedLDAPAccess.log to be vde.accesslogfile= in <Domain_Home>/servers/<Server_Name>/data/ldap/conf/vde.prop. If you like please follow and comment

Find the Bind Variable for SQLID of SQL query in Oracle Fetch the bind variable values from SQL ID -Latest DB SQL executed RAC SELECT sql_id, b.LAST_CAPTURED, t.sql_text sql_text, b.HASH_VALUE, b.name bind_name, b.value_string bind_value FROM gv$sql t JOIN gv$sql_bind_capture b using (sql_id) WHERE b.value_string is not null AND sql_id='&sqlid'; OR NON-RAC SELECT NAME,SQL_ID,POSITION,DATATYPE_STRING,VALUE_STRING FROM v$sql_bind_capture WHERE sql_id='&sqlid' order by Position; Check plan for SQL Execution plan from SQLID -- From Normal SQL if present as cursor in memory select * from table(dbms_xplan.display_cursor('&sqlid',[child], format => 'TYPICAL +PEEKED_BINDS')); Example: select * from table(dbms_xplan.display_cursor('&sqlid',1, format => 'TYPICAL +PEEKED_BINDS')); --From AWR report select * from table(dbms_xplan.display_awr('&SQL_ID',NULL,NULL,'ADVANCED')) Bind Value Check from AWR history t...

Reset the AdminServer Password in Oracle WebLogic 11g  If you forget the AdminServer password for your WebLogic 11g domain, you can reset it from the command line using the following process. 1) Set up the following environment variables. They are not necessary for the process itself, but will help you navigate. In this case my domain is called "ClassicDomain". Remember to change the value to match your domain. export MW_HOME=/u01/app/oracle/middleware export DOMAIN_HOME=$MW_HOME/user_projects/domains/DOMAIN_NAME 2) Shut down the WebLogic domain. $ $DOMAIN_HOME/bin/stopWebLogic.sh Rename the data folder. $ mv $DOMAIN_HOME/servers/AdminServer/data $DOMAIN_HOME/servers/AdminServer/data-old 3) Set the environment variables. $ . $DOMAIN_HOME/bin/setDomainEnv.sh 4) Reset the password using the following command. Remember to substitute the appropriate username and password. $ cd $DOMAIN_HOME/security $ java weblogic.security.utils.AdminAccount <username> <password> . 5)...

Error Starting Managed Services- JPS-01050: Opening Of Wallet Based Credential Store Failed Error: The following error message is shown when starting Managed Services: JPS-01050: Opening Of Wallet Based Credential Store Failed.  Detailed error syntax from the hr_managed.log ####<Date/Timestamp> <Critical> <WebLogicServer> <Host_name> <FoundationServices0> <Main Thread> <<WLS Kernel>> <> <> <1403135466910> <BEA-000386> <Server subsystem failed. Reason: weblogic.security.SecurityInitializationException: The loading of OPSS java security policy provider failed due to exception, see the exception stack trace or the server log file for root cause. If still see no obvious cause, enable the debug flag -Djava.security.debug=jpspolicy to get more information. Error message: JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException weblogic.security.SecurityInitializationException: The loa...

Autoconfig errors on adgentns.pl ORA-01400: cannot insert NULL into FND_APPS_SYSTEM.CSI_NUMBER Errors: On application Release 12 When attempting to run autoconfig on APPS Tier, the following error occurs: ERROR: [CVM Error Report] The following report lists errors encountered during CVM Phase /.../apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl 2 No of scripts failed in CVM phase: 1 AutoConfig is exiting with status 1 ERROR in NetServiceHandler.log: java.sql.SQLException: ORA-01400: cannot insert NULL into ("APPLSYS"."FND_APPS_SYSTEM"."CSI_NUMBER") ORA-06512: at "APPS.FND_APP_SYSTEM", line 39 ORA-06512: at "APPS.FND_NET_SERVICES", line 1720 ORA-06512: at line 1 A null value for parameter s_systemcsi in APPS Context XML File This makes autoconfig script to insert NULL value to ("APPLSYS"."FND_APPS_SYSTEM"."CSI_NUMBER") generating the error message : ORA-01400: cannot insert NULL into ("APPLSYS"."F...

Change database time in oracle database with Non Cdb and Cdb, Pdb database Changing the time zone in Oracle databases involves altering the ORA_SDTZ (Oracle System Datetime Time Zone) parameter. Here's a guide for both non-CDB (Container Database) and  CDB/PDB (Pluggable Database) scenarios: Non-CDB (Stand-Alone Database): Check Current Time Zone: SELECT DBTIMEZONE FROM DUAL; Change Time Zone: ALTER DATABASE SET TIME_ZONE = 'desired_timezone'; Replace 'desired_timezone' with the timezone you want to set (e.g., 'America/New_York'). We can also use offset values like ALTER DATABASE SET TIME_ZONE = '+5:30'; Verify: SELECT DBTIMEZONE FROM DUAL; CDB/PDB (Multitenant Database): For the Entire CDB: Check Current Time Zone: SELECT TIMEZONE_NAME FROM V$TIMEZONE_FILE; Change Time Zone for the Entire CDB: ALTER DATABASE SET TIME_ZONE = 'desired_timezone'; Replace 'desired_timezone' with the timezone you want to set (e.g., 'America/New_York...