Clone DB without adcfgclone.sh

Schema.

I want to clone in new instance ( different server ) but i'm forget to run adpreclone.sh first so in my appsutil there's no adcfgclone.sh

my detail machine :

OEL 4.8

oracle DB 10.2.0.4

 

. this how to solve that problems :

Step 1 :

Copy all your data file ( index,log,data) to new instance ( DEV )

i put on /db/data

first create you control file script :

CREATE CONTROLFILE SET DATABASE "DEV" RESETLOGS  NOARCHIVELOG

--  SET STANDBY TO MAXIMIZE PERFORMANCE

    MAXLOGFILES 32

    MAXLOGMEMBERS 5

    MAXDATAFILES 600

    MAXINSTANCES 8

    MAXLOGHISTORY 7260

LOGFILE

  GROUP 1 (

    '/db/data/log/log1a.dbf',

    '/db/data/log/log1b.dbf'

  ) SIZE 10M,

  GROUP 2 (

    '/db/data/log/log2a.dbf',

    '/db/data/log/log2b.dbf'

  ) SIZE 10M,

  GROUP 3 (

    '/db/data/log/log3a.dbf',

    '/db/data/log/log3b.dbf'

  ) SIZE 10M,

  GROUP 4 (

    '/db/data/log/log4a.dbf',

    '/db/data/log/log4b.dbf'

  ) SIZE 10M

-- STANDBY LOGFILE

DATAFILE

  '/db/data/data/APPS_TS_ARCHIVE01.dbf',

  '/db/data/data/APPS_TS_INTERFACE01.dbf',

  '/db/data/data/APPS_TS_MEDIA01.dbf',

  '/db/data/data/APPS_TS_NOLOGGING01.dbf',

  '/db/data/data/APPS_TS_QUEUES01.dbf',

  '/db/data/data/APPS_TS_SEED01.dbf',

  '/db/data/data/APPS_TS_SUMMARY01.dbf',

  '/db/data/data/APPS_TS_TOOLS01.dbf',

  '/db/data/data/APPS_TS_TX_DATA01.dbf',

  '/db/data/data/APPS_TS_TX_DATA02.dbf',

  '/db/data/data/APPS_TS_TX_DATA03.dbf',

  '/db/data/data/APPS_TS_TX_IDX01.dbf',

  '/db/data/data/APPS_TS_TX_IDX02.dbf',

  '/db/data/data/APPS_UNDOTBS01.DBF',

  '/db/data/data/APPS_UNDOTBS02.DBF',

  '/db/data/data/APPS_UNDOTBS03.DBF',

  '/db/data/data/DISCO_D.DBF',

  '/db/data/data/PORTAL01.DBF',

  '/db/data/data/SYSAUX01.DBF'

  '/db/data/data/SYSTEM01.DBF',

  '/db/data/data/SYSTEM02.DBF',

  '/db/data/data/SYSTEM03.DBF',

  '/db/data/data/SYSTEM04.DBF',

  '/db/data/data/SYSTEM05.DBF',

  '/db/data/data/SYSTEM06.DBF',

  '/db/data/data/SYSTEM07.DBF',

  '/db/data/data/SYSTEM08.DBF',

  '/db/data/data/SYSTEM09.DBF'

CHARACTER SET US7ASCII;

*save with name ctl.sql and put in /db/

on my DEV run my env ( i create manually )

example :

export ORACLE_HOME=/db/DEV/product/10.2.0/db_1

export PATH=$ORACLE_HOME/bin:$PATH

export ORACLE_SID=DEV

so i can start my sqlplus :

sqlplus "/as sysdba"

startup nomount

@/db/ctl.sql

i'm facing this problem when running sql script:

CREATE CONTROLFILE SET DATABASE "DEV" RESETLOGS  NOARCHIVELOG

*

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-00200: control file could not be created

ORA-00202: control file: '/proddata/DEV/data/control01.ctl'

ORA-27040: file create error, unable to create file

Linux Error: 2: No such file or directory

causes :

my spfile control file value still target to folder old instance. 

solving :

change spfile control file value to new instance.

under  my $ORACLE_HOME/dbs

create pfile='initDEV.ora' from spfile;

Before edit :

*.control_files='/proddata/DEV/data/control01.ctl','/proddata/DEV/data/control02.ctl','/proddata/DEV/data/control03.ctl'

after edit :

*.control_files='/db/data/index/control01.ctl','/db/data/index/control02.ctl','/db/data/index/control03.ctl'

then :

startup nomount pfile='initDEV.ora'

create spfile='spfileDEV.ora' from pfile='initDEV.ora';

@/db/ctl.sql

i'm facing this problem when running sql script:

CREATE CONTROLFILE SET DATABASE "DEV" RESETLOGS  NOARCHIVELOG

*

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-00200: control file could not be created

ORA-00202: control file: '/db/data/index/control01.ctl'

ORA-27038: created file already exists

Additional information: 1

Causes :

my control file exists

Solve :

delete all my control file.

then running again the "ctl.sql"

alter database open resetlogs;

alter tablespace temp add tempfile '/db/data/data/TEMP01.dbf' reuse;

alter tablespace temp add tempfile '/db/data/data/TEMP02.dbf' reuse;

alter tablespace temp add tempfile '/db/data/data/TEMP03.dbf' reuse;

That all step for recreate control file.

Thanks,

Mahardika Dwi Hananto

 

Read more »

Host Credentials Oracle EM

im solve this problem in 

Windows Xp 64Bit

Oracle 10.2.0.1

this actually happened in first time you configure EM.

Problem :

you're already input correct host and correct user and so correct password but system still say "there's wrong password"

causes :

you're not set permission for your user

Solution :

1. Go to Start —> Run
2. type secpol.msc /s        –> Local Security Policy window appear.
3. Left Side panel ->Local Policies -> User Rights Assignment ( press enter )
4. Right Side Panel -> Log on as a batch job –> here Double Click and Add Administrator User.

now retest again.

Thanks,

Mahardika Dwi Hananto

Read more »

ORA-12545: Connect failed because target host or object does not exist

Problem :



SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jun 18 22:29:01 2012

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
ORA-12545: Connect failed because target host or object does not exist

assumtion :


When run script db adautocfg.sh I'm facing that error


using oracle :
- DB 10.2.0.4.0
- EBS 11.0.5.0
- OEL 4.8


This for solving that error :


login using apps
> sqlplus apps/apps


Run this script :
> EXEC FND_CONC_CLONE.SETUP_CLEAN;
> commit;


then retest autoconfig.

Read more »

ERROR : when sqlplus apps/apps

Problem :


ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-06553: PLS-801: internal error [56319]

assumtion :

when i clone apps 11g in Linux 32 bit but i forget to clone oracle_home, so i install oracle 10.2.0.1 and upgrade to 10.2.0.4.

when i already patch from 10.2.0.1 to 10.2.0.4
and i recreate controlfile


and i test connect using apps :

$ sqlplus apps/apps
 and result is

ERROR:

ORA-00604: error occurred at recursive SQL level 1

ORA-06553: PLS-801: internal error [56319]

this how to solve :

$ sqlplus "/as sysdba"

SQL > startup upgrade pfile=<your path init.ora>

SQL > <your ORACLE_HOME>/rdbms/admin/utlirp.sql

SQL > shutdown

SQL > startup pfile=<your path init.ora>

SQL > <your ORACLE_HOME>/rdbms/admin/utlrp.sql

*if running utlrp.sql take a few minute depend invalid your object

Query returning the number of invalid objects remaining. This
number should decrease with time.
SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);

and now you can connect using apps schema

thank's,

Mahardika Dwi Hananto

Read more »

Complete with warning status in ORACLE EBS R12

If you meet this error.

go to System Admintrator > concurrent  > Manager > administer
Cek Output Post Processor sure that actual and target have same processes

Click button “processes”
Click button “manager log”

If there any error like this :
[2/10/12 9:39:24 PM] [UNEXPECTED] [40193:RT454369] java.io.FileNotFoundException: /usr/temp/xdo2VPYjzquiI021012_0939244520.fo (No such file or directory)
    at java.io.FileOutputStream.open(Native Method)
    at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
    at java.io.FileOutputStream.<init>(FileOutputStream.java:131)
    at oracle.apps.xdo.common.tmp.TmpFile.createTmpFileJDK118(TmpFile.java:146)
    at oracle.apps.xdo.common.tmp.TmpFile.createTmpFile(TmpFile.java:113)
    at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:987)
    at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)
    at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1665)
    at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:975)
    at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5936)
    at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)
    at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)
    at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:296)
    at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:173)





Solution :

Make temp folder in usr.

Effect of this error is when you view output theres XML report not a word.

Read more »

ERROR : Invalid Login Credentials ( APEX 4.0 )

Hi,

APEX 4.0

First of all this causes maybe :
1. you input incorrect password
2. you input incorrect user
3. you input incorrect workspace
4. account was lock by something

in this session i'll give solution for number 4 cause.

first thing to do is :
you must login to sql

1. sqlplus / as sysdba
2. sql > alter user APEX_040000 account unlock;
3. sql > conn  APEX_040000/password;
4. sql >

   begin
   wwv_flow_api.set_security_group_id(p_security_group_id=>10); 
   wwv_flow_fnd_user_api.create_fnd_user( 
     p_user_name => 'admin2', 
     p_email_address => 'dev@null.com',
     p_web_password => 'admin2') ; 
   end;
   /
   commit
   / 

5. sql > alter user APEX_040000 account lock;

then

login to apex_admin
http://test.test.local:7780/pls/apex/apex_admin

user :admin2
pass :admin2



maybe for first time login
it mus be reset password
then go to workspace task position in right of your screen

choose find a user.

then




choose image pencil to edit your user :
look for Account Privileges see Account Availability is must be "locked" change to "unlocked"
then try again in APEX home.

Thanks.

Read more »

Connect to SQLPLUS : ERROR: ORA-12560: TNS:protocol adapter error ( WINDOWS )

Problem :

Causes :

Not set Enviroment

Solution :

set your ORACLE_HOME and your PATH
set ORALE_HOME="your oracle path"
set PATH=%ORACLE_HOME%\bin;%PATH%


example :

set ORACLE_HOME=C:\product\11.2.0\dbhome_1
set PATH=%ORACLE_HOME%\bin;%PATH%

pict :

Thanks.

Read more »

error adadmin

problem :

$ adadmin
-bash: adadmin: command not found

even you execute enviroment file.

how to solve :

put this in your .bash_profile

AD_TOP=/u01/CRP/apps/apps_st/appl/ad/12.0.0; export AD_TOP
APPL_TOP=/u01/CRP/apps/apps_st/appl/; export APPL_TOP
COMMON_TOP=/u01/CRP/apps/apps_st/comn; export COMMON_TOP
ORACLE_HOME=/u01/CRP/apps/tech_st/10.1.2; export ORACLE_HOME
IAS_ORACLE_HOME=/u01/CRP/apps/tech_st/10.1.3; export IAS_ORACLE_HOME

PATH=$PATH:$HOME/bin

export PATH

and then

$ export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib/

now you can execute

$ adadmin

if you meet this error :

 Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                     Oracle Applications AD Administration

                                 Version 12.0.0

NOTE: You may not use this utility for custom development
      unless you have written permission from Oracle Corporation.

AD Administration error: Unable to get value of ORACLE_SID or TWO_TASK.

AD Administration error:
Unable to get database name.

how to solve :
ORACLE_SID=CRP;export ORACLE_SID

and problem solve.


Thanks.

Read more »

ORACLE R12 Troubleshooting On OEL 5.5

if you find an error :

The requested
URL /OA_HTML/AppsLogin was not found on this server.

( view By Mozzila)

this how to solve :

This problem occurred because wsrp_service.wsdl was owned by root but the services were being started by applmgr.

Ensure that the file
$ORA_CONFIG_HOME/10.1.3/j2ee/oacore/application-deployments/oacore/html/server-wsdl/wsrp_service.wsdl

it shows it is owned by root. Somebody started the services of Apps as root user.

Changed the owner of the file to Apps Owner.

Restarted the service.

Everything works fine.

Read more »