Forms Version Not Showing On 'About Oracle Applications' Form From Help Menu (Doc ID 556755.1)
Help > About Oracle Application : Missing Information Such as Forms Version and Oracle SID (Doc ID 797202.1)
Thanks for the above notes. I set the profile "FND: Diagnostics" to Yes at site level and bounced Middle-Tier services(adstpall.sh) and restarted the services. But the issue persists. Still the Forms server section is empty in Help > About Oracle Application.
I even cleared the Cache using Functional Administrator Responsibility but that too did not help.
Any other suggestion please?
Please stop all the services using "adstpall.sh" script, then start it again using "adstrtal.sh" script.
If you still have the same issue, then please provide a screenshot.
Is there any option to attach a screenshot in this post?
Only through using free hosting websites and posting the link here.
Well, in that case my screenshot looks exactly like in -
Is this happening to all users?
Is the profile option set at any other level (i.e. user, responsibility, application, ..etc)?
No. The profile option is set Only at site level. Is there a query to find out which other levels the Profile option is set at(i.e., User,responsibility,application, etc)
some new errors occurred now. Autoconfig fails on both the db and apps tier. When I bounced the database and tried to start the DB, it gave this strange error. Everthing was working fine just few minutes back. Not sure what went wrong.
ORACLE instance started.
Total System Global Area 2138521600 bytes
Fixed Size 2161024 bytes
Variable Size 1191184000 bytes
Database Buffers 922746880 bytes
Redo Buffers 22429696 bytes
ORA-01221: data file 1 is not the same file to a background process
Error: ORA 1221
Text: datafile <name> is not the same file to a background process
Cause: When the database writer opens the datafile, it is accessing a
different physical file than the foreground doing the recovery.
The time-stamp set in the file header by the foreground was not found
by the background.
It may be that the background process could not read the file at all.
Action: Look in the DBWR trace file for the error it received when attempting
to read the file header.
Reconfigure the operating system as needed to have the filename
successfully access the same file when opened by a background process.
Any suggestions here please?
Can you please stop all services, bounce the server, start the database and check then?
If you have any errors in the database log file, then you will also need to review the trace file(s) associated with the error.
You mean reboot the solaris server and then start database and applications services. We have two databases running on this solaris server.
DBWR Trace file shows:
Read of datafile '+ASMDG002/test1/datafile/system.823.828585081' (fno 1) header failed with ORA-01206
Rereading datafile 1 header failed with ORA-01206
V10 STYLE FILE HEADER:
Compatibility Vsn = 186646528=0xb200000
Db ID=0=0x0, Db Name='TEST1'
Control Seq=31739=0x7bfb, File size=230400=0x38400
File Number=1, Blksiz=8192, File Type=3 DATA
Tablespace #0 - SYSTEM rel_fn:1
Creation at scn: 0x0000.00000004 04/27/2000 23:14:44
Backup taken at scn: 0x0001.db8e5a1a 04/17/2010 04:16:14 thread:1
reset logs count:0x316351ab scn: 0x0938.0b32c3b1
prev reset logs count:0x31279a4c scn: 0x0938.08469022
recovered at 11/28/2013 19:43:22
status:0x2004 root dba:0x00c38235 chkpt cnt: 364108 ctl cnt:364107
begin-hot-backup file size: 230400
Checkpointed at scn: 0x0938.0cb9fe5a 11/28/2013 15:04:52
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
Plugged readony: NO
Plugin scnscn: 0x0000.00000000
Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988
Foreign creation scn/timescn: 0x0000.00000000 01/01/1988
Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988
Online move state: 0
DDE rules only execution for: ORA 1110
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----
----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK'
(SUCCESS, 0 csec) -----
Executing ASYNC actions
----- END DDE Actions Dump (total 0 csec) -----
ORA-01186: file 1 failed verification tests
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1:
ORA-01206: file is not part of this database - wrong
You mean reboot the solaris server and then start database and applications services.
Yes. If this is not a valid option for now, can you please shutdown the database and make sure none of the OS processes is still active?
Is this an ASM/RAC database?