Base-Oracle-2

Dedicated Dedicated 服务器进程服务器进程 1 12 23 3listener.oratnsnames.orasqlnet.ora全部使用默认设置即可LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=topprod)(PORT=1521)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=PLSExtProc)(ORACLE_HOME=D:oracleora92)(PROGRAM=extproc)LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=topprod)(PORT=1521)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=PLSExtProc)(ORACLE_HOME=D:oracleora92)(PROGRAM=extproc)SQLNET.AUTHENTICATION_SERVICES=(NTS)NAMES.DIRECTORY_PATH=(TNSNAMES,ONAMES,HOSTNAME)SQLNET.AUTHENTICATION_SERVICES=(NTS)NAMES.DIRECTORY_PATH=(TNSNAMES,ONAMES,HOSTNAME)这里填入要连接的ORACLE_SID这里填入服务器IP要进行测试出现这种错误，检查服务器端的监听器是否打开出现这种错误，检查前面输入的ORACLE_SID是否正确出现这种错误，检查system用户的密码这里输入net服务名TOPDB=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.180.129)(PORT=1521)(CONNECT_DATA=(SERVICE_NAME=topdb)TOPDB=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.180.129)(PORT=1521)(CONNECT_DATA=(SERVICE_NAME=topdb)可以直接编辑该文件来配置网络服务（蓝色部分为需设定项目）tnsping 服务名服务名C:Documents and SettingsLifengtnsping topdbTNS Ping Utility for 32-bit Windows:Version 9.2.0.1.0-Production on 10-2月月-2008 21:53:51Copyright(c)1997 Oracle Corporation.All rights reserved.已使用的参数文件已使用的参数文件:D:oracleora92networkadminsqlnet.ora已使用已使用 TNSNAMES 适配器来解析别名适配器来解析别名Attempting to contact(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.180.129)(PORT=1521)(CONNECT_DATA=(SERVICE_NAME=topdb)OK（0毫秒）毫秒）C:Documents and SettingsLifengC:Documents and SettingsLifengtnsping topdbTNS Ping Utility for 32-bit Windows:Version 9.2.0.1.0-Production on 10-2月月-2008 21:53:51Copyright(c)1997 Oracle Corporation.All rights reserved.已使用的参数文件已使用的参数文件:D:oracleora92networkadminsqlnet.ora已使用已使用 TNSNAMES 适配器来解析别名适配器来解析别名Attempting to contact(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.180.129)(PORT=1521)(CONNECT_DATA=(SERVICE_NAME=topdb)OK（0毫秒）毫秒）C:Documents and SettingsLifenglsnrctl start/stop/status/reload/help lsnr_namelsnrctlLSNRCTLcommandLSNRCTLquitlsnrctlLSNRCTLcommandLSNRCTLhelpstart stop statusservices version reloadsave_config trace spawnchange_password quit exitset*show*start stop statusservices version reloadsave_config trace spawnchange_password quit exitset*show*Lsnrctl 的另一个作用：当管理员需要对oracle进行一些操作时，为了防止TIPTOP用户登录和使用，可以使用lsnrctl stop停掉监听器，这样可以在不关闭服务器的情况下避免客户端登入LSNRCTLset optionLSNRCTLsetLSNRCTLshow optionLSNRCTLshowLSNRCTLset optionLSNRCTLsetLSNRCTLshow optionLSNRCTLshowpassword rawmodeDisplaymode trc_file trc_directory trc_levellog_file log_directory log_status current_listener startup_waittime save_config_on_stoppassword rawmodeDisplaymode trc_file trc_directory trc_levellog_file log_directory log_status current_listener startup_waittime save_config_on_stopLISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=topprod)(PORT=1521)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=PLSExtProc)(ORACLE_HOME=D:oracleora92)(PROGRAM=extproc)TRACE_LEVEL_LISTENER =16 TRACE_DIRECTORY_LISTENER=/u1/out TRACE_FILE_LISTENER =listener LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=topprod)(PORT=1521)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=PLSExtProc)(ORACLE_HOME=D:oracleora92)(PROGRAM=extproc)TRACE_LEVEL_LISTENER =16 TRACE_DIRECTORY_LISTENER=/u1/out TRACE_FILE_LISTENER =listener 设定跟踪级别设定trace文件位置设定trace文件名 lsnrctl start LSNRCTL for Linux:Version 10.2.0.1.0-Production on 18-FEB-2008 17:55:25 Copyright(c)1991,2005,Oracle.All rights reserved.Starting/u2/oracle/10g/bin/tnslsnr:please wait.TNSLSNR for Linux:Version 10.2.0.1.0-Production System parameter file is/u2/oracle/10g/network/admin/listener.ora Log messages written to/u2/oracle/10g/network/log/listener.log Error listening on:(ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1)No longer listening on:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=heliserver3)(PORT=1521)TNS-12546:TNS:permission denied TNS-12560:TNS:protocol adapter error TNS-00516:Permission denied Linux Error:30:Read-only file system Listener failed to start.See the error message(s)above.lsnrctl start LSNRCTL for Linux:Version 10.2.0.1.0-Production on 18-FEB-2008 17:55:25 Copyright(c)1991,2005,Oracle.All rights reserved.Starting/u2/oracle/10g/bin/tnslsnr:please wait.TNSLSNR for Linux:Version 10.2.0.1.0-Production System parameter file is/u2/oracle/10g/network/admin/listener.ora Log messages written to/u2/oracle/10g/network/log/listener.log Error listening on:(ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1)No longer listening on:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=heliserver3)(PORT=1521)TNS-12546:TNS:permission denied TNS-12560:TNS:protocol adapter error TNS-00516:Permission denied Linux Error:30:Read-only file system Listener failed to start.See the error message(s)above.对于文件系统权限错误，我们需要知道是在访问什么文件或目录时产生的18-FEB-2008 18:51:25:302 nsc2addr:(ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESSIZE=1)18-FEB-2008 18:51:25:302 sntuscrt:entry18-FEB-2008 18:51:25:302 sntuscrt:failed to change permissions of dir/var/tmp/.oracle 18-FEB-2008 18:51:25:302 sntuscrt:exit18-FEB-2008 18:51:25:302 ntusb2adr:entry 18-FEB-2008 18:51:25:302 nsc2addr:(ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESSIZE=1)18-FEB-2008 18:51:25:302 sntuscrt:entry18-FEB-2008 18:51:25:302 sntuscrt:failed to change permissions of dir/var/tmp/.oracle 18-FEB-2008 18:51:25:302 sntuscrt:exit18-FEB-2008 18:51:25:302 ntusb2adr:entry 这就是引发错误的具体位置sqlplus username/password as sysdba/sysopersqlplus/nologSQLconn username/password as sysdba/sysopersqlplus/nologSQLconn username/password as sysdba/sysopersqlplus“/as sysdba”sqlplus username/passwordservicenameSQLselect*from ima_file;SQLdelete from ima_file where ima01=AAA;SQLdelete from ima_file where ima01=AAA;122 rows deleted.SQLdelete from ima_file where ima01=AAA;SQLrollback;SQLdelete from ima_file where ima01=AAA;Rollback complete.SQLdelete from ima_file where ima01=AAA;SQLcommit;SQLdelete from ima_file where ima01=AAA;Commit complete.vi mysql.sqldelete from ima_file where ima01=AAA;vi mysql.sqldelete from ima_file where ima01=AAA;SQLdelete from ima_file where ima01=AAA;sqlplus ds/ds mysql122 rows deleted.SQLdelete from ima_file where ima01=AAA;SQLmysql;122 rows deleted.SQLdelete from ima_file where ima01=AAA;SQLselect count(*)from ima_file;SQLdelete from ima_file where ima01=AAA;SQL/COUNT(*)-1 COUNT(*)-121 SQLdelete from ima_file where ima01=AAA;SQLlistSQLdelete from ima_file where ima01=AAA;1*select count(*)from ima_file;SQLdelete from ima_file where ima01=AAA;SQLselect count(*)from ima_file;COUNT(*)-1 COUNT(*)-121 SQLedselect count(*)from ima_file where ima01 like A%SQL/SQLedselect count(*)from ima_file where ima01 like A%SQL/COUNT(*)-1 COUNT(*)-32 SQLdelete from ima_file where ima01=AAA;SQLdesc agc_file;Name Null?Type-AGC01 NOT NULL VARCHAR2(6)AGC02 NOT NULL VARCHAR2(10)AGC03 NOT NULL NUMBER(5)AGC04 NOT NULL VARCHAR2(1)AGC05 VARCHAR2(20)AGC06 VARCHAR2(20)Name Null?Type-AGC01 NOT NULL VARCHAR2(6)AGC02 NOT NULL VARCHAR2(10)AGC03 NOT NULL NUMBER(5)AGC04 NOT NULL VARCHAR2(1)AGC05 VARCHAR2(20)AGC06 VARCHAR2(20)SQLdelete from ima_file where ima01=AAA;SQLhost 或!/u2/tiptoplsaap aec amr aqc axc demo gpm oraaa.sh aem ams arm axd/u2/tiptopexitSQL/u2/tiptoplsaap aec amr aqc axc demo gpm oraaa.sh aem ams arm axd/u2/tiptopexitSQLSQLdelete from ima_file where ima01=AAA;SQLhost 或!oscommandSQLdelete from ima_file where ima01=AAA;SQLsave filename replaceSQLdelete from ima_file where ima01=AAA;SQLget filenameSQLdelete from ima_file where ima01=AAA;SQLstart filenameSQLdelete from ima_file where ima01=AAA;SQLedit filenameSQLdelete from ima_file where ima01=AAA;SQLspool filenameSQLspool output.logSQLselect count(*)from ima_file;SQLspool output.logSQLselect count(*)from ima_file;SQLspool offSQLquitSQLspool offSQLquit COUNT(*)-1 COUNT(*)-32 SQLdelete from ima_file where ima01=AAA;SQLshow option/allSQLset linesize 9999SQLset autocommit onSQLset autotrace onSQLset linesize 9999SQLset autocommit onSQLset autotrace onSQLdelete from ima_file where ima01=AAA;SQLset optionSQLdelete from ima_file where ima01=AAA;SQLshow parameters param演讲完毕，谢谢观看！