Senin, 30 Juli 2012

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

Rabu, 25 Juli 2012

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 ...
 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Online Project management