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 »

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

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

Read more »