Monday, December 21, 2009

Clear the temporary tablespace

If the tablespace is a default temporary tablespace when you are greeted with the following exception:

SQL> DROP TABLESPACE temp;
drop tablespace temp
*
ERROR at line 1:
ORA-12906: cannot drop default temporary tablespace

Steps to clear the temporary tablespace:

1) SQL>CREATE TEMPORARY TABLESPACE temp2
TEMPFILE '/database/oracle/oradata/KOUSHIK/temp2_01.dbf' SIZE 5M REUSE
AUTOEXTEND ON NEXT 1M MAXSIZE unlimited
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

Tablespace created.

2) SQL>ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2;

Database altered.

3) SQL>DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;

Tablespace dropped.

4) SQL>CREATE TEMPORARY TABLESPACE temp
TEMPFILE '/database/oracle/oradata/KOUSHIK/temp01.dbf' SIZE 500M REUSE
AUTOEXTEND ON NEXT 100M MAXSIZE unlimited
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

Tablespace created.

5) SQL>ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp;

Database altered.

6) SQL>DROP TABLESPACE temp2 INCLUDING CONTENTS AND DATAFILES;

Tablespace dropped

Saturday, December 19, 2009

java.io.FileNotFoundException,

[12/19/09 4:01:46 PM] [UNEXPECTED] [617977:RT3277692] java.io.FileNotFoundException: /erpdb/KMCUPD/inst/apps/KMCUPD_kmctapp1/logs/appl/conc/out/o3277692.out (No such file or directory (errno:2))
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.(FileInputStream.java:106)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:230)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:172)


Solution:

Make space in system by deleting unnecessary files

Thursday, December 17, 2009

Transuction resister is erroring out

Error:

Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.US7ASCII

'.,'

stat_low = 86
stat_high = 0
emsg:was terminated by signal 6
Enter Password:
SIGSEGV 11* segmentation violation
si_signo [11]: SIGSEGV 11* segmentation violation
si_errno [0]: Error 0
si_code [1]: SEGV_MAPERR [addr: 0x4f4431]


Aborting...

An unexpected exception has been detected in native code outside the VM.
Unexpected Signal : 11 occurred at PC=0xC0240140
Function=free
Library=/usr/lib/hpux32/libc.so.1

Current Java thread:
"Thread-4" prio=5 tid=41082050 nid=16 lwp_id=6506397 runnable [0x5dd10000..0x5dd10dc0]
at oracle.reports.engine.EngineImpl.CRunReport(Native Method)
at oracle.reports.engine.EngineImpl.run(EngineImpl.java:437)
at oracle.reports.server.JobManager.runJobInEngine(JobManager.java:916)
- locked <5f5b0040> (a oracle.reports.engine.EngineImpl)
at oracle.reports.server.ExecAsynchJobThread.run(ExecAsynchJobThread.java:54)


Solution:

A. Please query for the following flex fields in "key flexfield segments" form
1.System Items,
2.Item Categories,
3.Stock Locators,
4.Sales Orders,
5.Accounting Flexfield,
6.Account Aliases.

B. Please make sure that at least one segment is enabled in each of these flexfields, if not enable a segment freeze and compile the flexfield and then test the issue. Also please bounce the reports server once and then re-test the issue.

Getting FRM-41839 FRM-41092 FRM-40737 FRM-40734 When Using Mouse Scroll on Oracle Applications 12.0.4

FRM-41839: Disk I/O error on temporary record buffer file /tmp/fileICVLQ3.TMP
FRM-41092: No records in block PROFILE_VALUES
FRM-40737: Illegal restricted procedure MESSAGE in ON-ERROR trigger
FRM-40734: Internal Error: PL/SQL error occurred



Way arround:

On Forms version 10.1.2.2.0:

1. Apply Patch 8493152 - MERGE LABEL REQUEST ON TOP OF 10.1.2.2 FOR BUGS 7590411 8428638 7231982
2. Then add the following line on $INST_TOP/ora/10.1.2/forms/server/default.env

FORMS_SCROLL_ALL_BUT_ONE=true
OR

Upgrade to Forms 10.1.2.3:

1. Follow Note 437878.1 - Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12
2. Then add the following line on $INST_TOP/ora/10.1.2/forms/server/default.env

FORMS_SCROLL_ALL_BUT_ONE=true

FRM-40735: ZOOM trigger raised unhandled exception ORA-06502.

ORA-01403: no data found

--------------------------------------------------------------
FRM-40735: ZOOM trigger raised unhandled exception ORA-06502.


solution:

open the form
Select Help-Diagnostics-Custom Code - OFF

Monday, December 14, 2009

Oracle account error

ORA_28000: The account is locked
Wait for PASSWORD_LOCK_TIME or contact your DBA
ORA-28001: The password has expired
Change the password or contact your DBA
ORA-00988: Missing or invalid password(s)
Use double quotes for the password (e.g. alter user scott identified by "!alex";)
ORA-01017: Invalid username/password; logon denied
Contact your DBA if the problem still persists

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...