Hi All,
Today while performing manual migration of the database to 10gr2 we encountered the following error while trying to run catupgrd.sql script as shown below
SQL> spool upgrade.log
SQL> @catupgrd.sql
SP2-0734: unknown command beginning “catupgrd.s…” – rest of line ignored
Later on we discovered that error was due to OS which was unix and following line needs to be added to the .profile of the oracle to solve the problem
if [ “$TERM” = “” ]
then
eval ` tset -s -Q -m ‘:?hp’ `
else
eval ` tset -s -Q `
fi
stty erase “^H” kill “^U” intr “^C” eof “^D”
stty hupcl ixon ixoff
tabs
Alternatively we could solve the problem by typing the following command
$stty kill Ctrl-u
$sqlplus
SQL> spool upgrade.log
SQL> @catupgrd.sql
The stty kill Ctrl-U solved the problem.
Hi All,
Today One of my collegue had gone to install Oracle 9.2.0.4 on linux x86-64bit on AMD 64 bit. But to his suprise the OUI hanged when copying a file naeet.o
when the installation was only 17% over. Later if found that it was a bug with 9204 OUI on linux x86-64 on amd 64.
So the workaround for that is to set an environment variable called
LD_ASSUME_KERNEL to 2.4.21 before running the runInstaller script.
$LD_ASSUME_KERNEL = 2.4.21
$export LD_ASSUME_KERNEL
$./runInstaller
After setting the above variable the installation went through but it started
giving make file errors during relinking.
So to solve that problem we opened a new terminel where environment variable
LD_ASSUME_KERNEL was not set and
we tried to relink the oracle binaries as shown
$echo $LD_ASSUME_KERNEL
$cd $ORACLE_HOME/bin
$relink all
and there was no error found when manually relinking the oracle binaries and
the installation went through sucessfully.
Later when we applied the 9207 patch we followed the same above procedure
and 9207 patch was also applied sucessfully.
Also it is advisable to check all the pre requistes as given in metalink Docs.
Alternatively the above error can also be solved by invoking the OUI of 9206
and using the product.jar of 9204 to install 9204.
