UNIX下@符号报SP2-0734错误

最新推荐文章于 2022-05-31 16:51:32 发布

congbi4543

最新推荐文章于 2022-05-31 16:51:32 发布

阅读量248

点赞数

文章标签：数据库

Subject:	SP2-0734 and/or SP2-0042 Error Immediately When Attempting To Run catpatch.sql
	Doc ID:	336920.1

Symptoms

After applying a patchset, the post install documentation instructs you to run the $ORACLE_HOME/rdbms/admin/catpatch.sql script. The script does not run and instead produces the error below:

SQL> @catpatch.sql
SP2-0734: unknown command begining "catpatch.s..." ....

Cause

This is due to the display terminal keyboard configuration of the kill character.

Solution

The problem is with the display terminal keyboard settings. The sqlplus session had trouble interpreting the "@" sign, because it was assigned in the terminal to the "kill" setting. The catpatch.sql script was supposed to be run as "@catpatch.sql" and since the "@" sign had a completely different meaning for this OS session, sqlplus only saw "catpatch.sql".

The solution is to change the display terminal keyboard setting of the kill character to something else. For example:

# stty kill ^u

After making this change the script is interpreted correctly and runs as it should.

[@more@]

TST:[/oracle]$sqlplus /nolog

SQL*Plus: Release 9.2.0.8.0 - Production on Tue Apr 14 10:23:50 2009

SQL> conn sgj/XXX@ZX1;
SP2-0042: unknown command "ZX1" - rest of line ignored.
SQL> conn / as sysdba
Connected.
SQL> conn rman/XXX
ERROR:
ORA-01017: invalid username/password; logon denied
SQL> conn rman/XXX@rman
SP2-0042: unknown command "rman" - rest of line ignored.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9533994/viewspace-1020481/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9533994/viewspace-1020481/