How to get details of USER... [message #457883] |
Wed, 26 May 2010 04:51 |
snsiddiqui
Messages: 172 Registered: December 2008
|
Senior Member |
|
|
I want to save ip address, os username, terminal information at the time of record insertion/updation therefore I am using sys_context function but it gives me error at the time of form compilation.
ERROR:
ORA-00600: internal error code, arguments: [17069],[134386616],[],[],[],[],[],[]
My user has already DBA privilege.
Please help me to resolve this issue or if you guys have any other suggestion/option then please update me.
I will be very gratefull to all of you.
|
|
|
|
Re: How to get details of USER... [message #457902 is a reply to message #457883] |
Wed, 26 May 2010 05:48 |
gregor
Messages: 86 Registered: March 2010 Location: Germany
|
Member |
|
|
Hi snsiddiqui,
1.) sys_context is not working in a RAC-enviroment.
- What are your OS and Database Version-numbers?
2.) look in your bdump-folder, in the Alert.Log file, for the ora-00600 error. 2.1) Get the trace-file number found with the ora-00600 error. 2.2) search in the udump folder for that trace file number. There should be explained, what's going wrong.
|
|
|
Re: How to get details of USER... [message #457909 is a reply to message #457902] |
Wed, 26 May 2010 06:16 |
snsiddiqui
Messages: 172 Registered: December 2008
|
Senior Member |
|
|
Dear GREGOR
I am not using RAC enviroment.
OS is WINDOWS XP and Database version is
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production
There isn't any error in ALERT.LOG and also there isn't any trace file with this error number.
|
|
|
Re: How to get details of USER... [message #457916 is a reply to message #457909] |
Wed, 26 May 2010 07:00 |
gregor
Messages: 86 Registered: March 2010 Location: Germany
|
Member |
|
|
Hi snsiddiqui,
1.) the path to "alert_<SID>.log" file is defined as the database parameter "log_archive_dest%" or %user_dump%
You can see this values in: - sqlplus (connect as sys) at sqlprompt type:
SQL> show parameters %dump%
and than:
SQL> show parameters log_archive%
( you alternative see it in the spfile<SID>.ora or init<SID>.ora)
2. what your FORMS Version?
|
|
|
Re: How to get details of USER... [message #457921 is a reply to message #457916] |
Wed, 26 May 2010 07:12 |
cookiemonster
Messages: 13938 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Forms version is specified at the top of the thread - under the private messaging link.
I suspect the problem is what Littlefoot described, there's all sorts of DB stuff that forms 6i just doesn't like.
|
|
|
Re: How to get details of USER... [message #457944 is a reply to message #457921] |
Wed, 26 May 2010 08:57 |
gregor
Messages: 86 Registered: March 2010 Location: Germany
|
Member |
|
|
hi ,
I have tested sys_context,
Littlefoot is correct , forms 6i doesn't like SYS_CONTEXT. (however my Error: sys_context must be declared / Forms 6.0.8.22.1 DB 11)
- in Forms 10.2 / DB 10.2.04 , sys_context works fine.
GG
|
|
|
|
|
|
|
|
Re: How to get details of USER... [message #461693 is a reply to message #458085] |
Mon, 21 June 2010 01:14 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
See what results you obtain from running the following: select upper(osuser), upper(terminal)
into v_osuser, v_terminal
from v$session
where sid = (select distinct sid
from v$mystat);
Also look at the bits and pieces available in 'd2kwutil'.
David
|
|
|