// ]]>

Monday 6 April 2015

ORA-00205: error in identifying control file, check alert log for more info

SQL> select status from v$instance;

STATUS
------------
STARTED

SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info



SQL> show parameter contr


SQL> create pfile='D:\pfile.ora' from spfile;


Now edit pfile
like: =================================== Old Pfile ===================================================
dbrman.__db_cache_size=218103808
dbrman.__java_pool_size=4194304
dbrman.__large_pool_size=4194304
dbrman.__oracle_base='D:\app'#ORACLE_BASE set from environment
dbrman.__pga_aggregate_target=255852544
dbrman.__sga_target=381681664
dbrman.__shared_io_pool_size=0
dbrman.__shared_pool_size=146800640
dbrman.__streams_pool_size=0
*.audit_file_dest='D:\app\admin\DBRMAN\adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='D:\app\oradata\DBRMAN\control01.ctl','D:\app\oradata\DBRMAN\control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='DBRMAN'
*.db_recovery_file_dest='D:\app\flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest='D:\app'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=DBRMANXDB)'
*.memory_target=634388480
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
==================================== After Editing New Pfile ==========================================
dbrman.__db_cache_size=218103808
dbrman.__java_pool_size=4194304
dbrman.__large_pool_size=4194304
dbrman.__oracle_base='D:\app'#ORACLE_BASE set from environment
dbrman.__pga_aggregate_target=255852544
dbrman.__sga_target=381681664
dbrman.__shared_io_pool_size=0
dbrman.__shared_pool_size=146800640
dbrman.__streams_pool_size=0
*.audit_file_dest='D:\app\admin\DBRMAN\adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='D:\app\oradata\DBRMAN\control01.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='DBRMAN'
*.db_recovery_file_dest='D:\app\flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest='D:\app'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=DBRMANXDB)'
*.memory_target=634388480
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
============================================================================================================


SQL> SHUTDOWN IMMEDIATE;
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> CONN /AS SYSDBA
Connected to an idle instance.
SQL> STARTUP PFILE=D:\pfile.ora;
ORACLE instance started.

Total System Global Area  535662592 bytes
Fixed Size                  1375792 bytes
Variable Size             310378960 bytes
Database Buffers          218103808 bytes
Redo Buffers                5804032 bytes
Database mounted.
Database opened.


SQL> create spfile from pfile='D:\pfile.ora';

File created.



Monday 16 March 2015

Server Release info

Solaris
cat /etc/release

Red Hat
cat /etc/enterprise-release
cat /etc/redhat-release

lsb_release -a
cat /proc/version

Ubuntu/Debian
cat /etc/lsb-release

lsb_release -a

HP-UX
/stand/kernrel



AIX
oslevel -r

Friday 19 December 2014

ERROR_MESSAGE_STATE (browser not supported)


1 Method:- Simple copy URL from IE and paste other browser.
2.Method:-Note-1724418
1. Call transaction SE11 and create the following domains:
    • Domain: WDR_APP_PROP_ALLOW_USER_AGENTS
    • Description: Allow User Agents
    • Package: SWDP_RUNTIME_CORE
    • Data Type: CHAR
    • Length: 10
    • Add the following value ranges:
    • Fix.Val.: SUPPORTED
    • Short Descript.: Supported
    • Fix.Val.: TOLERATED
    • Short Descript.: Tolerated

2. Call transaction SE11 and create the following data element:
    • Data element: WDR_APP_PROP_ALLOW_USER_AGENTS
    • Short Description: Allow User Agents
    • Package: SWDP_RUNTIME_CORE
    • Domain: WDR_APP_PROP_ALLOW_USER_AGENTS
    • Add the following field labels:
    • Short: User Agent
    • Medium: Allow User Agents
    • Long: Allow User Agents
    • Heading: Allow User Agents
    • Save and activate the changes.

3. Call transaction SE16 and open the database table WDY_APP_PROP_DEF. Maintain the following entry:
    • SET NAME: STANDARD
    • PROPERTY_NAME: WDALLOWEDUSERAGENTS
    • ALIAS_NAME: wdAllowedUserAgents
    • DEFAULT_VALUE: TOLERATED
    • PROPERTY_KIND: 4
    • MIN_LEVEL: 1
    • MAX_LEVEL: 5
    • ABAP_TYPE: WDR_APP_PROP_ALLOW_USER_AGENTS
    • DESCRIPTION: Allow User Agents
    • Save your changes.
    • Display the new entry and select it.
    • In the menu, choose "Table Entry" -> "Transport Entries".
    • Select or add a transport request from the dialog box to transport the entry. Choose "OK".

4. Call transaction SHMM.
    • Choose the instance CL_WDR_CONF_APPL_SHM.
    • Choose the symbol for deletion from the table toolbar (garbage can to the right) to delete all instances from the shared memory.