This is a sample document showing how to migrate Non ASM DB to ASM DB
1 create the ASM instance
2.Create the required  DISK groups according to  the needs
DB name DEVEL
SQL> select file_name from dba_data_files;
FILE_NAME
——————————————————————————–
/oracle/DEVEL/system01.dbf
/oracle/DEVEL/undotbs01.dbf
/oracle/DEVEL/sysaux01.dbf
/oracle/DEVEL/users01.dbf
/oracle/DEVEL/example01.dbf
SQL> select name from v$controlfile;
NAME
——————————————————————————–
/oracle/DEVEL/control01.ctl
SQL> select MEMBER from v$logfile;
MEMBER
——————————————————————————–
/oracle/DEVEL/redo03.log
/oracle/DEVEL/redo02.log
/oracle/DEVEL/redo01.log
Shutdown the database.
SQL> SHUTDOWN IMMEDIATE
Start the database in nomount mode.
RMAN> STARTUP NOMOUNT (make sure you […]

Popularity: 1% [?]

read more from this topic.....

The topic is related to creating a duplicated copy of  DB from production  to Development  using rman.
The below steps are applicapable in 9i,10g and 11g.In 11g there are some new methods for creating duplicate DB  which I will be covering  in coming topics
The database names used here
database names:
Primary Database SID:       PROD  server RAC1
Duplicate Database SID:     DEVEL […]

Popularity: 1% [?]

read more from this topic.....

At times, it is important to import/export policies from Database. I am explaining the scripts to be used to achieve this.
The policies are present in the XML config file policyIX_config.xml in the location BEA_HOME/ales32-admin/bin.
To export policies from Database to an XML file:
Assume you are running from the location  BEA_HOME/ales32-admin/bin.
./policyIX.sh -export ../config/policyIX_config.xml policies_export.xml -passwdPrompt
-passwdPrompt is optional […]

Popularity: 1% [?]

read more from this topic.....

It is pretty straight forward to create the ALES schema using DB Config tool. I am writing here something which is not documented anywhere as to how to re-run the DB config tool if wrong values are specified for oes username or password etc.,               Here are the steps to be followed to revert and re-run […]

Popularity: 1% [?]

read more from this topic.....

Everything was okayed before and now the aforesaid issue occurs.

Login to SQL*Plus as apps user and run the following:
set serveroutput on
declare
db_file NUMBER;
mime_type VARCHAR2(255) := ‘text/plain’;
out_string VARCHAR2(32767) := ‘Just some plain text that is stored.’;
web_server_prefix VARCHAR2(500);
url VARCHAR2(500);
begin
db_file := fnd_gfm.file_create(content_type => mime_type, program_name =>’export’);
fnd_gfm.file_write_line(db_file, out_string);
db_file := fnd_gfm.file_close(db_file);
url := fnd_gfm.construct_download_url(fnd_web_config.gfm_agent, db_file, TRUE);
dbms_output.put_line(url);
end;
/
If it shows, errors like
declare
*
ERROR at line 1:
ORA-29875: failed […]

Popularity: 1% [?]

read more from this topic.....

While upgrading one of Oracle Software using runInstaller, I received error One-off patch installation failed during configuration . I looked at inventory log$INVENTORY_LOCATION/ logs/ installActions[YYYY]-[MM]-[DD]_[hh]-[mm]-[ss][PM|AM].log and realised error was related to Oracle Configuration Manager ( OCM )
_______
ERROR: OPatch failed because of cmd. args. problem.
To run in silent mode, OPatch requires a response file for Oracle Configuration Manager […]

Popularity: 4% [?]

read more from this topic.....

Oracle Software (Database, OID, HTTP Server, Forms & Report, Discoverer …) installation issues are logged under oraInventory/logs/[filename].log (for more on oraInventory click here ) but how to identify oraInventory location on system ?
Oracle Inventory Pointer oraInst.loc (registry variable inst_loc for windows)  determines oraInventory location

oraInventory location in windows : INST_LOC - “c:\program files\Oracle\Inventory“
oraInventory default location in Linux, AIX : Directory mentioned in /etc/oraInst.loc

oraInventory […]

Popularity: 6% [?]

read more from this topic.....