ORA-01031: insufficient privileges while connecting to database as sysdba
By Jag - August 03, 2014
ORA-01031: insufficient privileges while connecting to database as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 21 02:52:18 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01031: insufficient privileges
Enter user-name:
oracle@test.sangam /orasw/app/oracle/product/10.2.0/bin
Solution:
1. Check the uid and gid of an oracle user.
#> id oracle
uid=1014(oracle) gid=3005(oinstall) groups=100(users),3004(dba),3005(oinstall),8500(oemdba)
ORA-20100: Error: FND_FILE FAILURE unable to create file in the directory,/usr/tmp
By Jag - July 21, 2014
Concurrent requests are failed with the below error:
ORA-20100: Error: FND_FILE failure. Unable to create file, o0040178.tmp in thedirectory, /usr/tmp.
You will find more information in the request log.
ORA-06512: at "APPS.FND_FILE", line 417
ORA-06512: at "APPS.FND_FILE", line 456
ORA-06512: at line 1
Upon checking below settings there is no issue :
1. The $APPLTMP, $APPLPTMP variables and UTL_FILE_DIR database parameter are valid and pointing to directory where there is enough space and users have written permission.
2. FND_FILE.PUT_LINE is able to create new files in the temporary directory.
FND_FILE.PUT_LINE Checking method:
SQL> exec FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST');
ORA-20100: Error: FND_FILE failure. Unable to create file, o0040178.tmp in thedirectory, /usr/tmp.
ORA-06512: at "APPS.FND_FILE", line 417
ORA-06512: at "APPS.FND_FILE", line 456
ORA-06512: at line 1
Upon checking below settings there is no issue :
1. The $APPLTMP, $APPLPTMP variables and UTL_FILE_DIR database parameter are valid and pointing to directory where there is enough space and users have written permission.
2. FND_FILE.PUT_LINE is able to create new files in the temporary directory.
FND_FILE.PUT_LINE Checking method:
SQL> exec FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST');
The first step in the receiving process is called 'Gate Entry'. The truck is verified at the gate and the entry of the truck to the Factory Premises is documented. There may be a 'Weight Entry' as well, where the 'Gross Weight' of the truck is checked and documented. Once the truck enters the company premises, the material in the truck becomes the responsibility of the company.
At this point the material in the truck has not been inspected and delivered in the inventory. Just that the Truck has entered the company premises and since the Truck has been received, a potential liability has been created. In accounting terms, a potential liability is called 'Accrual'. This means that 'Gate Entry' Creates an Accrual in the system.
Every accounting transaction has to have two sides. One side of the Gate Entry is Accrual, what is the other side (Debit Side)?
The other side is the material in the truck itself. The material is yet to be inspected and hence is grouped under 'Goods Under Inspection' or 'Receiving Inspection'.
So the Gate Entry process causes a transaction named 'Receive' in Oracle and a
At this point the material in the truck has not been inspected and delivered in the inventory. Just that the Truck has entered the company premises and since the Truck has been received, a potential liability has been created. In accounting terms, a potential liability is called 'Accrual'. This means that 'Gate Entry' Creates an Accrual in the system.
Every accounting transaction has to have two sides. One side of the Gate Entry is Accrual, what is the other side (Debit Side)?
The other side is the material in the truck itself. The material is yet to be inspected and hence is grouped under 'Goods Under Inspection' or 'Receiving Inspection'.
So the Gate Entry process causes a transaction named 'Receive' in Oracle and a
This error only occurs on custom forms whereas it does not throw any error for standard forms.
I checked the form related AOL objects as below.
Responsibility: Order Management Super User
FRM-10102: Cannot attach PL/SQL library APPCORE:Oracle Pl/SQL
By Jag - April 15, 2014
Problem :: FRM-10102: Cannot attach PL/SQL library APPCORE. This library attachment will be lost if the module is saved
Solution :: Need to add FORMS_PATH in registry of windows.
Press Win R to open windows Run and put regedit to edit the windows registry.
and search ofr FORMS_PATH
and custom Forms and plls path in this variable.
Solution :: Need to add FORMS_PATH in registry of windows.
Press Win R to open windows Run and put regedit to edit the windows registry.
and search ofr FORMS_PATH
and custom Forms and plls path in this variable.
APP-FND-00828: Please enter the required context field value in the items flexfield. The context field (also Known as a structure field) appears as one of the first segments in your flexfield
By Jag - April 15, 2014
Error Message: APP-FND-00828: Please enter the required context field value in the items flexfield. The context field (also Known as a structure field) appears as one of the first segments in your flexfield.
Possible solution: could be an error associated with Descriptive Flexfield
Navigate to System Administrator responsibility.
Application>> Flexfield>> Descriptive>> Segments
There are no valid navigations for this responsibility:Orale Apps Error
By Jag - April 15, 2014
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
By Jag - April 03, 2014
Error:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Issue and its details:
Submit your concurrent Program and the Program ends up in error with log showing
the below error message
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
WARNING: inbound connection timed out (ORA-3136)-R12

Causes of the ORA-3136 Error Message
There are many changes in the default behaviour from Oracle 9i and Oracle 10g databases. One of the changes to SQLNet was the default timeout for a new connection to be established. This setting is called SQLNET.INBOUND_CONNECT_TIMEOUT.
The value in 9i was unlimited and the new value in 10g is 60 seconds. In reality, I don’t think that many applications should take 60 seconds to establish a connection to the database – I think you’d have complaints before you received this error from a genuine application.
There are several reasons why you may hit this timeout:
Cause:
Error 1: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL
Error 2: if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2).
Action:
Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.
Error 1: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL
Error 2: if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2).
Action:
Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.
Error : “FRM-92050 : Failed to connect to the Server: /forms/lservlet-1"
By Jag - September 05, 2013





