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 »