becks wrote:You should not skip this step. The init.ora file is the same one you copied over from the source server. I have no experience with Windows, but on Unix the file is located in ORACLE_HOME/dbs directory.
Shifted the pfile and spfile over.
Have proceed until part 5. Do not really understand part 5 as i could not find ORACLE_HOME\database\ORACLE_SID \ folder. So i skip it
Step 7: could not find this ORACLE_HOME\rdbms folder also. skipAgain, you cannot skip this step. If you installed the Oracle software correctly on the target server, there should be an ORACLE_HOME/rdbms/admin directory present.
I go to step 8 then step 9 throw the following error.Pl see these MOS Docs
ORA-12560: TNS:protocol adapter error
Stilll trying to debug
becks wrote:Not sure what you mean by this - pl elaborate.
Thanks thanks. How about the word changes?
Really shld feedback to my department head. I just a database user with simple knowledge of sql statment. There no DBA in our company.All of this work should be done by a knowledgeable DBA - if you do not have one, hire a consulting DBA.
Are your guys DBA to the application team in your company? What is the usual setup of of a software developing team? Application team, Infrastructure team into DBA, weblogic administrator, load balance, network? Do your have administrator for each container like database server, application server, window server, linux server.Yes we have dedicated teams doing all of this work in their respective areas of expertise
becks wrote:So when you install the 64-bit binaries on the target and copy over the database files from the source and open the database, the word size gets automatically updated to 64-bit on the target database.
In points 5 and 6 of the guide, it mention about the word size change.
5.In the 64-bit Oracle home, add the SYSTEMTRIG_ENABLED = false parameter to the ORACLE_HOME\database\ORACLE_SID \init.ora file before changing the word size.
6.Remove this parameter from the initialization file after the word size change is complete.Once all of the steps are complete, remove the "_SYSTEM_TRIG_ENABLED = false" from the init.ora file and restart the database
becks wrote:Follow the instructions in Step 10, beginning with "Edit the trace file created in ...". After you edit the trace file as needed, execute in SQL Plus (connected as SYSDBA) to create new controlfiles.
ok i manage to create a pfile from spfile. the ppfile is an init.ora file right. After step 8 and 9, I'm connected to an idle instance. I'm stuck at step 10 whereby it says need to recreate the control files.
Do i type the create files in the sqlplus but i got back ORA-01034: Oracle not available? Thinking that I can shift the control files over as both the source and the destination database have the same database name, can I? if so, i can skip 10 to go 11 but I'm stuck at 11 when it says Alter the init file? What do I need to alter?I would strongly recommend you hire a consultant DBA to do this work for you