There’s more than One Reason For this i will provide you with two solutions (Meta-link Note):
Solution One :
1. Backup and edit the forms configuration file (Default= formsweb.cfg)
2. Modify the HTMLdelimiter to have only one character as a value
HTMLdelimiter=%
3. Save and exit the file.
Solution Two :
Edit oracle_apache.conf and comment out the include related to the forms.conf as the following :
# Oracle Forms Developer
#include “/oas/product/oas2/forms/server/forms.conf”
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/15/2011 12:54:22
RMAN-12001: could not open channel ORA_DISK_1
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database
ORA-12154: TNS:could not resolve the connect identifier specified
Solution :
RMAN> run {
2> allocate channel ch00 type disk;
3> restore database;
4>}
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 02/13/2011 14:51:58 RMAN-06054: media recovery requesting unknown log: thread 1 seq 2 lowscn 547146 This Error Happened Sometimes When you try to restore rman backup from Real Application Cluster To single Node Solution RMAN > recover database noredo;
Sometimes Users Cannot access to Database You Need To check The following :
Sqlplus / as sysdba
Show parameter local_listener ;
You have to see output like this :
local_listener (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=you-ip-address)(PORT=1521))))
If you see Null Value Do the Following :
Alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.250.25)(PORT=1521))))’ scope=memory ;
Or For Real Application :
Alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.250.25)(PORT=1521))))’ scope=memory sid=’you-node-name’;
Scope = memory For Test Purpose
Sql > Alter system register ;
Now You should see database name service on listener ;
to Apply these Changes all we have to do is scope=spfile like the following :
Alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.250.25)(PORT=1521))))’ scope=spfile ;
Or For Real Application :
Alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.250.25)(PORT=1521))))’ scope=spfile sid=’you-node-name’;
Amazing Oracle Trick I found today while i am Browsing OTN , I see to post it here .
What is Open resetlog mode :
First i will show its Normal Database this mean not in recovery mode :
sqlplus / as sysdba Connected to an idle instance. SQL> ORACLE instance started. Total System Global Area 838860800 bytes Fixed Size 2087672 bytes Variable Size 213910792 bytes Database Buffers 616562688 bytes Redo Buffers 6299648 bytes Database mounted. Database opened. SQL> shutdown Database closed. Database dismounted. ORACLE instance shut down. SQL> exit
Now Lets Open it :
sqlplus / as sysdba
Connected to an idle instance. SQL> startup mount ORACLE instance started. Total System Global Area 838860800 bytes Fixed Size 2087672 bytes Variable Size 213910792 bytes Database Buffers 616562688 bytes Redo Buffers 6299648 bytes Database mounted. SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01139: RESETLOGS option only valid after an incomplete database recovery SQL> recover database; ORA-00283: recovery session canceled due to errors ORA-00264: no recovery required SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01139: RESETLOGS option only valid after an incomplete database recovery SQL> recover database until cancel; Media recovery complete. SQL> alter database open resetlogs; Database altered. SQL>
NLS_LANG has been set to an invalid value in the environment of the user starting Oracle Forms Services.
Solution
Set NLS_LANG to a valid value like AMERICAN_AMERICA.AR8MSWIN1256 in the default.env file or any custom environment file which is being used.
You can go to regedit and also set the NLS_LANG value to the one mentioned above and check if this resolves the issue.
If the Above Solution Doesn’t Work For you Try The Below One :
1) FRM-92100 occurs when invoking a new forms session from existing form session, or another URL is invoked from the parent browser window of the forms applet?
To work-around use the applet parameter separateFrame=”True”. This parameter is set in the static html file or formsweb.cfg
2) If using Oracle Jinitiator, try clearing the Jinitiator JAR or jcache:
For versions 1.3.x.x.x : Control Panel – Jinitiator Control Panel – Cache Tab Page – Clear JAR Cache button
3) If using MS Internet Explorer check that permissions / security options are set correctly
Launch Microsoft Internet Explorer.
Select the Tools -> Internet Options from the top level menu.
Click the SECURITY Tab:
Choose Local Intranet Zone from the list.
Click Custom Level.
Select Java Permissions – Custom from the list.
Click Java Custom Settings.
Select the Edit Permissions tab.
Choose Enable for Run Unsigned Content.
Choose Enable for Run Signed Content.
Select the ADVANCED tab.
Scroll down to Java VM.
Check the Java console enabled option.
Select the CONNECTIONS tab.
Click the LAN Settings button.
If IE is using a proxy server : Check the Bypass proxy server for local addresses check box. Click the Advanced button, and enter the local domain in the Exceptions box. Use the form *.domain.com, where domain.com maps to your local domain.
Click OK to exit the dialog.
Click OK to save the changes and exit IE.
Restart the computer.
Check for whether user has full database export/import privilege
Query :
SQL>SET lines 100
COL privilege FOR a50
SELECT grantee, granted_role, default_role
FROM dba_role_privs
WHERE granted_role IN ('DBA', 'EXP_FULL_DATABASE', 'IMP_FULL_DATABASE')
ORDER BY 1,2;
Check for user has create table or create session privilege.
Query
SQL>SET lines 100 pages 100
COL privilege FOR a40
SELECT grantee, privilege
FROM dba_sys_privs
WHERE (grantee IN ('TEST', 'PUBLIC')
OR grantee IN (SELECT granted_role FROM dba_role_privs
WHERE grantee IN ('TEST', 'PUBLIC')))
AND privilege IN ('CREATE SESSION', 'CREATE TABLE')
ORDER BY 1,2;
Check for granted privileges on directory objects.
Query :
SET lines 110
COL privilege FOR a12
COL grantee FOR a25
COL owner FOR a25
SELECT p.grantee, p.privilege, p.owner, d.directory_name
FROM dba_tab_privs p, dba_directories d
WHERE p.table_name=d.directory_name
AND (grantee IN ('TEST', 'PUBLIC')
OR grantee IN (SELECT granted_role FROM dba_role_privs
WHERE grantee IN ('TEST', 'PUBLIC')))
ORDER BY 4,3,2;
Make sure RMAN is connected to the right target database and the recovery catalog. Then run the CREATE SCRIPT command, as shown in this example:
CREATE SCRIPT full_backup
{
BACKUP DATABASE PLUS ARCHIVELOG;
DELETE OBSOLETE;
}
COMMENT with descriptive information:
CREATE GLOBAL SCRIPT global_full_backup
COMMENT 'use only with ARCHIVELOG mode databases'
{
BACKUP DATABASE PLUS ARCHIVELOG;
DELETE OBSOLETE;
}
RUN { EXECUTE SCRIPT full_backup; }
PRINT SCRIPT full_backup; PRINT SCRIPT full_backup TO FILE 'my_backup.txt';
LIST SCRIPT NAMES;
LIST ALL SCRIPT NAMES;
REPLACE SCRIPT full_backup
{
BACKUP DATABASE PLUS ARCHIVELOG;
}
DELETE SCRIPT 'full_backup'; DELETE GLOBAL SCRIPT 'global_full_backup';
The Below Scripts To Check Backup Status Via Sqlplus , Maybe you will find Same Or Another Scripts In the Same way :
Sqlplus / as sysdba
This script will report on all backups – full, incremental and archivelog backups –
col STATUS format a9 col hrs format 999.99 select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,'mm/dd/yy hh24:mi') start_time, to_char(END_TIME,'mm/dd/yy hh24:mi') end_time, elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key;
This script will report all on full and incremental backups, not archivelog backups –
col STATUS format a9 col hrs format 999.99 select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,'mm/dd/yy hh24:mi') start_time, to_char(END_TIME,'mm/dd/yy hh24:mi') end_time, elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS where input_type='DB INCR' order by session_key;
I would Love to Thank gavin soorma – OCM For His Amazing Effort . Share it For Knowledge .
ORA-01034: ORACLE not available When Create DBCONSOLE / DBCONTROL
If you are using the following Command :
$ emca -deconfig dbcontrol db -repos drop
$ emca -config dbcontrol db -repos create
Try Use
emca -config dbcontrol db -repos recreate -ORACLE_HOSTNAME “Hostname”
-SID “SID” -PORT “PortNumber” -ORACLE_HOME $ORACLE_HOME -DBDNMP_PWD “Password”
It Should be Work
AbbasGol's Blog 