foalabs

Increase Virtual Machine Memory in the OVM Manager GUI Steps  1. Using Oracle VM Manager GUI: 2. Login to Oracle VM Manager (GUI). 3. Select the VM and click on edit. 4. Check the assigned "Max. Memory (MB):" and "Memory (MB):". 5. If the "Max. Memory (MB):" is the same as "Memory (MB):", then you have to shut down the VM to increase the "Max. Memory (MB):" and "Memory (MB):". 6. If the "Max. Memory (MB):" is higher than the "Memory (MB):", then you can increase the "Memory (MB):" till "Max. Memory (MB):". 7. Ensure the "Memory (MB):" should not be higher than "Max. Memory (MB):" 8. Click on Save. Login to the VM and verify allocated memory. If you like please follow and comment

ORA-24001: cannot create QUEUE_TABLE Error: 12:23:05:252 WARNING: Old e_DEM_CONN_s was removed from ENGINE_STARTER_LIST 12:23:05:449 ERROR: Failed to initialize notification queue for Engine Starter ID: e_DEM_CONN_s, Status: FAILURE: -24001 ORA-24001: cannot create QUEUE_TABLE, DEMANTRA.E_DEM_CONN_S_OUT already exists, Exiting... 12:23:05:449 Got std::runtime_error in main loop: ERROR: Failed to initialize notification queue 12:23:05:449 Unregistering listener... 12:23:05:452 e_DEM_CONN_s was removed from ENGINE_STARTER_LIST Reason: After cloning the demantra database from production starting Engine Starter give queue table error. Solution: Drop AQ table Connect Demantra schema SQL> exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table => 'E_DEM_CONN_S_OUT', force => TRUE); SQL> exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table => 'E_DEM_CONN_S_IN', force => TRUE); If you like please follow and comment

ASCP 12.2.x PlanningUI.ear Fails To Start With Java.lang.nullpointerexception In Weblogic  ERROR Planning UI was deployed to a separate WebLogic Home  along side VCP 12.2.x.  No errors were encountered during the installation/configuration. When trying to access the actual User Interface from the Supply Planning Work Area it gives the following errors: but ASCP Managed Server logs display following java error: Internal Server Error 500 on the webpage ASCP Managed Server logs show the following java error: <Watch 'UncheckedException' with severity 'Notice' on server 'ASCPManagedServer' has triggered at  Notification details: WatchRuleType: Log WatchRule: (SEVERITY = 'Error') AND ((MSGID = 'WL-101020') OR (MSGID = 'WL-101017') OR (MSGID = 'WL-000802') OR (MSGID = 'BEA-101020') OR (MSGID = 'BEA-101017') OR (MSGID = 'BEA-000802')) WatchData: DATE = Jan 25, 2016 2:37:59 PM GMT SERVER = ASCPManagedServer MESSA...

How to Define PDB Listeners With Different Ports In a Oracle database Multitenant Create a listener and start it. LISTENER_FUNEBS122 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = FUNEBS122-host)(PORT = 1522)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522)) ) ) ENABLE_GLOBAL_DYNAMIC_ENDPOINT_PDB_LISTENER=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_PDB_LISTENER=SUBNET # line added by Agent lsnrctl start LISTENER_FUNEBS122 Now connect to the PDB for which you are setting up listener. SQL> alter session set container=PDB10; Session altered. SQL> show con_name CON_NAME -------- PDB10 Set listener_networks: use the listener port and the hosname SQL> alter system set listener_networks='(( NAME=net1)(LOCAL_LISTENER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=FUNEBS122-host)(PORT =1522)))))' scope=both; System altered. SQL> alter system register; System altered. Check the status of the listener: lsnrctl status LISTENER_FUNEBS122 LSNRCTL ...

After upgrading to EBS 12.2, login page loops with credentials blanked out and don't login Error: The cause is that AdminSecurityCfg handles input stream not using the traditional Reader on System.in but rather System.Console APIs to handle the user input. Reason: The cause is that AdminSecurityCfg handles input stream not using the traditional Reader on System.in but rather System.Console APIs to handle the user input. Solution: a) Run the following command: { echo APPS/<PASSWORD>; } | java oracle.apps.fnd.security.AdminSecurityCfg -unlock DBC=$FND_SECURE/<sid_name>.dbc -nopromptmsg b) Restart the services If you like please follow and comment

Autopatch error: The worker should not have status 'Running' or 'Restarted' at this point Error: If you are restarting a failed patch session in oracle applications, sometimes you may encounter the error AutoPatch error: The worker should not have status 'Running' or 'Restarted' at this point. Telling workers to quit... All workers have quit. Connecting to APPS......Connected successfully. AutoPatch error: Error running SQL and EXEC commands in parallel Cause: 1. adpatch or adop process was killed from OS level while patch is being applied 2. Database shutdown or terminated Solution: Using adctrl utility, use option 4 to change the worker status to Failed Review the messages above, then press [Return] to continue.                     AD Controller Menu      ---------------------------------------------------      1.    Show worker status      2.    Tell worker to restart a ...

EBS R12.2: RESTARTING ONLINE PATCHING ENABLEMENT PATCH when failed Error: When applying online enablement patch 13543062 for adop, patch stopped at last 3 jobs remaining. When tried to continue the patch from where it stopped it is throwing the following error. ERROR: adpatch is not available for standalone use. Use adop to apply   patches. For usage, enter adop -? or adop -help. This happens that many time there are issues encountered and we have restart patch using below command. adpatch options=hotpatch,forceapply When the time comes to re-apply the patch to fix problems, if you use the same command to reapply the patch, we will notice that the patch completed normal with in no time and nothing happens in the back end. This is because of a specific feature from Adpatch.  ADPATCH by default skips jobs that are marked as “run successfully” in previous runs or as part of another patch. So we have to force it re-run those jobs.  adpatch options=hotpatch,forceapply,nocheckf...

ORA-24816: Expanded Non Long Bind Data Supplied After Actual Long Or Lob Column ERROR ATTENTION: All workers either have failed or are waiting:  FAILED: file pqpzzcncprg00025.ldt on worker  X.  FAILED: file jg12acp.ldt  on worker  Y. ERROR - details (from US_jg12acp_ldt.log and US_pqpzzcncprg00025_ldt.log) A database error occurred: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column Reason: The value for environment variable NLS_LANG is different than the database character set(NLS_CHARACTERSET) when invoking FNDLOAD. Please use the following command to verify the cause: Environment setup: $echo $NLS_LANG (Unix) Database characterset: Using sqlplus client query: SQL> SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET'; Solution If the Patch is stopped please just change setup for environment variable NLS_LANG to proper value and restart adpatch (continue previous session). For example: If the database character...

How to Stop-Start Container and Pluggable Databases in Multitenant Architecture Container Database (CDB) Startup and shutdown of the container database is the same as a normal database If we are shutting down the container the pluggable associated will also be stopped. Start with options STARTUP [NOMOUNT | MOUNT | RESTRICT | UPGRADE | FORCE | READ ONLY] Shutdown with options SHUTDOWN [IMMEDIATE | ABORT] Pluggable Database (PDB) Pluggable databases can be started and stopped from either Container database or switching to respective pluggable database. SQLPLUS- Connected to pluggable database STARTUP FORCE; STARTUP OPEN READ WRITE [RESTRICT]; STARTUP OPEN READ ONLY [RESTRICT]; STARTUP UPGRADE; SHUTDOWN [IMMEDIATE]; SQLPLUS- Connected to pluggable database or container database The ALTER PLUGGABLE DATABASE command can be used from the CDB or the PDB. When connected to PDB below commands can be run ALTER PLUGGABLE DATABASE OPEN READ WRITE [RESTRICTED] [FORCE]; ALTER PLUGGABLE DATABASE OPEN...

Query related to SQL Profiles in Oracle Find SQL profiles in database SELECT NAME,type, SQL_TEXT, CATEGORY, STATUS FROM DBA_SQL_PROFILES; How to check the Sql profile content SELECT CREATED, PROFILE_NAME, SQL_TEXT, extractvalue(VALUE(hint), '.') AS hint FROM DBMSHSXP_SQL_PROFILE_ATTR h, DBA_SQL_PROFILES p, TABLE(xmlsequence(extract(xmltype(h.comp_data), '/outline_data/hint'))) hint WHERE p.name = h.profile_name; select hint as outline_hints from (select p.name, p.signature, p.category, row_number() over (partition by sd.signature, sd.category order by sd.signature) row_num, extractValue(value(t), '/hint') hint from sqlobj$data sd, dba_sql_profiles p, table(xmlsequence(extract(xmltype(sd.comp_data), '/outline_data/hint'))) t where sd.obj_type = 1 and p.signature = sd.signature and p.category = sd.category and p.name like ('&&profile_name')) order by row_num; Sql-id related to Oracle Sql profile select distinct p.name sql_profile_name, s....

Pack Command Issue *sys-package-mgr*: Can't Write Cache File Error: *sys-package-mgr*: can't create package cache dir, '/tmpWLSTTempfunebs/packages' java.io.IOException: Permission denied         at java.io.UnixFileSystem.createFileExclusively(Native Method)         at java.io.File.createNewFile(File.java:1006)         at java.io.File.createTempFile(File.java:1989)         at java.io.File.createTempFile(File.java:2040)         at com.oracle.cie.domain.script.jython.WLST_offline.getWLSTOfflineInitFilePath(WLST_offline.java:239)         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)         at java.lang.reflect.Me...