Oracle Faq

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. 

Share This