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...

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 : Go to Start —> Run type secpol.msc /s        –> Local Security Policy window appear. Left Side panel ->Local Policies -> User Rights Assignment ( press enter ) 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 autoconf...

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...

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)    ...

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 sqlplus / as sysdba sql > alter user APEX_040000 account unlock; sql > conn  APEX_040000/password; 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 / sql > alter user...

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 : Than...

Read more »