oracle-issue

oracle安装问题：
1.undefined reference to `nnfyboot'
    export ORACLE_HOME=/your/oracle/home
    cd $ORACLE_HOME/lib
    ln -s libclient10.a libagtsh.a
    cd $ORACLE_HOME
    LD_LIBRARY_PATH=$ORACLE_HOME/lib ./bin/genagtsh $ORACLE_HOME/lib/libagtsh.so 1.0


oracle启动问题：
1. TNS:net service name is incorrectly specified
  ORACLE_SID=orcl                                                                                                                                                             
  export ORACLE_SID
2. ORA-01034: ORACLE not available  
  ORACLE_SID=orcl                                                                                                                                                             
  export ORACLE_SID


oracle在sqlplus中插入数据重新连接查询不到
  commit;

oracle连接:the network adapter could not establish the connection
  lsnrctl start


oracle 修改字符集：
sqlplus / as sysdba
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 941600768 bytes
Fixed Size 1340440 bytes
Variable Size 692063208 bytes
Database Buffers 243269632 bytes
Redo Buffers 4927488 bytes
Database mounted.

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

System altered.

SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

System altered.

SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;

System altered.

SQL> ALTER DATABASE OPEN;

Database altered.

SQL> ALTER DATABASE CHARACTER SET AL32UTF8;
ALTER DATABASE CHARACTER SET AL32UTF8
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set
–提示新字符集必须为旧字符集的超集

SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;

Database altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 941600768 bytes
Fixed Size 1340440 bytes
Variable Size 692063208 bytes
Database Buffers 243269632 bytes
Redo Buffers 4927488 bytes
Database mounted.
Database opened.

oracle:TNS:listener:all appropriate instances are in restricted mode
ALTER SYSTEM DISABLE RESTRICTED SESSION;