Common Errors During Oracle usage and development

Common Errors During Oracle usage and development

(1) scripts generated by powerdesigner cannot be run directly;

Otherwise error: ORA-00942: Table or attempt not to exist

Http://www.cnblogs.com/chinafine/articles/1847011.html

(2) ORA-00904 invalid identifier
This error occurs because the field name is incorrect, or a comma is added when the last field is created during table creation.

Http://heisetoufa.iteye.com/blog/344306

(3) Invalid Number or ORA-01722
Cause Analysis of ORA-01722: Invalid Number

Http://271788203.iteye.com/blog/653945

(4) ORA-00001: violation of unique constraints

(5) ORA-12526: TNS: listeners: all applicable routines are in restricted mode (this error occurs when you connect to the database)

This is because the database is switched to the restricted mode. The related command is:
SQL> conn sys/zkl @ zkl as sysdba
SQL> alter system enable restricted session;

The solution is to change it to the normal mode (that is, exit the restricted mode)
[Oracle @ gd47 Oracle] $ export oracle_sid = zkl
[Oracle @ gd47 Oracle] $ sqlplus/nolog
SQL> Conn/As sysdba
SQL> alter system disable restricted session

(6) An error occurred while modifying the server Character Set: ORA-12712: new character set must be a superset of old Character Set

This is because the superset of the old character set is required by default when the character set of Oracle Database is changed. Otherwise, this error occurs. solution:

Alter database character set internal_use zhs16gbk;

(7) after installing Oracle, the following error occurs when using sqlplus, LSNRCTL, and so on:
[Oracle @ vm01 Oracle] $ LSNRCTL
LSNRCTL: Error while loading shared libraries:/opt/oracle_11g_r2_x64/product/11.2.0.1.0/db_1/lib/libclntsh. so.11.1: cannot restore segment prot after reloc: Permission denied

I checked it online because of SELinux problems. The SELinux settings are too strict. The solution is to modify the/etc/SELinux/config file under the root user,
Change SELinux = enforcing to SELinux = disabled. Save and close. Restart the machine.
You can also temporarily disable/usr/sbin/setenforce 0.
Reference: http://blog.csdn.net/taolinke/article/details/6629462

(8) Non-oracle users execute the occi program, the error exception: code-1804, message-error while trying to retrieve text for error ORA-01804
Solution:
When executing the occi program, you must set the ORACLE_HOME environment variable in advance and run it as follows:
Export oracle_base =/sdb1/Oracle/11gr2_database_x64
Export ORACLE_HOME = $ oracle_base/product/11.2.0.1.0/db_1

./Test