在RAS3上装了ORACLE9I，将从2000SERVER的ORACLE中的数据以工具的形式导出DMP文件，在LINUX下用imp命令也导入成功了，配置好APACHE和PHP，用<? PHPINFO(); ?>能看到ORACLE和ORCI8参数，提示都是ENABLE，但是打开网页的时候却显示CONNET ORACLE等一些连接数据库和函数 的出错提示
Warning: Unable to connect to ORACLE (Error while trying to retrieve text for error ORA-01019) in /mnt/e/parameter/CLASSIFYseach.php on line 65
Warning: ora_open(): supplied argument is not a valid Oracle-Connection resource in /mnt/e/parameter/CLASSIFYseach.php on line 66
Warning: ora_commiton(): supplied argument is not a valid Oracle-Connection resource in /mnt/e/parameter/CLASSIFYseach.php on line 67
Warning: ora_parse(): supplied argument is not a valid Oracle-Cursor resource in /mnt/e/parameter/CLASSIFYseach.php on line 69)
（网页应该没问题，在2000下试过，很正常，能正常显示，）ORACLE也用STARTUP启动了，LSNRCTL 也START了，用OEMAPP DBASTUDIO 打开后也能看到导入数据库的用户和一些资料，在LINUX下PHP连接ORACLE是不是还要装什么软件，
php编译如下:
./configure' '--prefix=/usr/local/php
--with-apache=../apache_1.3.20
--with-config-file-path=/usr/local/php
--with-gd=/usr
--with-jpeg-dir=/usr
--with-freetype-dir=/usr
--with-tiff-dir=/usr
--with-zlib-dir=/usr
--with-oracle=/opt/oracle/product/9.2
--with-oci8=/opt/oracle/product/9.2
--with-dbase
--enable-track-vars
--enable-magic-quotes
--enable-exif
--enable-inline-optimization -q
oracle参数:
export DISPLAY=\x{201D}127.0.0.1:0.0\x{201D}
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/9.2
export PATH=$ORACLE_HOME/bin
ORACLE_HOME/Apache/Apache/bin
PATH
export ORACLE_OWNER=oracle
export ORACLE_SID=oracledb
export ORACLE_TERM=xterm
export LD_ASSUME_KERNEL=2.4.1
export THREADS_FLAG=native
export LD_LIBRARY_PATH=/opt/oracle/product/9.2/lib
LD_LIBRARY_PATH
export PATH=/opt/oracle/product/9.2/bin
PATH
export NLS_LANG=AMERICAN
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
oracle导入时的log:是不是ORACLE数据没有导入成功
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing SYSTEM's objects into SYSTEM
. importing QS_CS's objects into QS_CS
. . importing table "ADMIN" 12 rows imported
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "AQ$_QS_CS_ORDER_STATUS_QT_H" ("MSGID" RAW(16), "SUBSCRIBER#" "
"NUMBER, "NAME" VARCHAR2(30), "ADDRESS#" NUMBER, "DEQUEUE_TIME" DATE, "TRANS"
"ACTION_ID" VARCHAR2(30), "DEQUEUE_USER" NUMBER, "
ROPAGATED_MSGID" RAW(16),"
" "RETRY_COUNT" NUMBER, "HINT" ROWID, "SPARE" RAW(16), PRIMARY KEY ("MSGID""
", "SUBSCRIBER#", "NAME", "ADDRESS#" ENABLE) USAGE QUEUE ORGANIZATION INDEX"
" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREE"
"LIST GROUPS 1) LOGGING NOCOMPRESS PCTTHRESHOLD 50"
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "AQ$_QS_CS_ORDER_STATUS_QT_I" ("SUBSCRIBER#" NUMBER, "NAME" VA"
"RCHAR2(30), "QUEUE#" NUMBER, "MSG_ENQ_TIME" DATE, "MSG_STEP_NO" NUMBER, "MS"
"G_CHAIN_NO" NUMBER, "MSG_LOCAL_ORDER_NO" NUMBER, "MSGID" RAW(16), "HINT" RO"
"WID, "SPARE" RAW(16), PRIMARY KEY ("SUBSCRIBER#", "NAME", "QUEUE#", "MSG_E"
"NQ_TIME", "MSG_STEP_NO", "MSG_CHAIN_NO", "MSG_LOCAL_ORDER_NO", "MSGID" ENA"
"BLE) USAGE QUEUE ORGANIZATION INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STO"
"RAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) LOGG"
"ING NOCOMPRESS PCTTHRESHOLD 50"
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "AQ$_QS_CS_ORDER_STATUS_QT_NR" ("MSGID" RAW(16), "SUBSCRIBER#""
" NUMBER, "NAME" VARCHAR2(30), "ADDRESS#" NUMBER, "SIGN" "SYS"."AQ$_SIG_PROP"
"", "DBS_SIGN" "SYS"."AQ$_SIG_PROP", PRIMARY KEY ("MSGID", "SUBSCRIBER#", ""
"NAME", "ADDRESS#" ENABLE) USAGE QUEUE ORGANIZATION INDEX PCTFREE 10 INITR"
"ANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TAB"
"LESPACE "EXAMPLE" LOGGING NOCOMPRESS PCTTHRESHOLD 50 INCLUDING "SIGN" OVERF"
"LOW PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL "
"65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "EXAMPLE""
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "AQ$_QS_CS_ORDER_STATUS_QT_S" ("SUBSCRIBER_ID" NUMBER NOT NULL"
" ENABLE, "QUEUE_NAME" VARCHAR2(30) NOT NULL ENABLE, "NAME" VARCHAR2(30), "A"
"DDRESS" VARCHAR2(1024), "
ROTOCOL" NUMBER, "SUBSCRIBER_TYPE" NUMBER, "RULE_"
"NAME" VARCHAR2(30), "TRANS_NAME" VARCHAR2(61), "RULESET_NAME" VARCHAR2(61))"
" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREEL"
"ISTS 1 FREELIST GROUPS 1) LOGGING NOCOMPRESS"
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "AQ$_QS_CS_ORDER_STATUS_QT_T" ("NEXT_DATE" DATE, "TXN_ID" VARC"
"HAR2(30), "MSGID" RAW(16), "ACTION" NUMBER, PRIMARY KEY ("NEXT_DATE", "TXN"
"_ID", "MSGID" ENABLE) USAGE QUEUE ORGANIZATION INDEX PCTFREE 10 INITRANS "
"2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) "
" LOGGING NOCOMPRESS PCTTHRESHOLD 50"
. . importing table "ATTRIBUTE" 16682 rows imported
. . importing table "CLASSIFY_FIRST" 20 rows imported
。。。。。。
。。。。。。
. . importing table "JOBS" 19 rows imported
. . importing table "JOB_HISTORY" 10 rows imported
. . importing table "LOCATIONS" 23 rows imported
IMP-00060: Warning: Skipping table "QS_CS"."ORDER_STATUS_TABLE" because object
type "QS_ADM"."ORDERITEMLIST_VARTYP" does not exist or has different identifier
. . importing table "
ARAMETERINTL_COM" 9 rows imported
. . importing table "
RODUCTS" 114202 rows imported
IMP-00060: Warning: Skipping table "QS_CS"."QS_CS_ORDER_STATUS_QT" because object type "QS_ADM".
ORDERITEMLIST_VARTYP" does not exist or has different identifier
. . importing table "REGIONS" 4 rows imported
. . importing table "SMP_DBREPORT_SQLSCRIPTS" 0 rows imported
. . importing table "SMP_DBREPORT_TEMPLATE" 0 rows imported
. . importing table "SMP_LMV_DISPLAY_OPTION" 0 rows imported
. importing table "SMP_LMV_REDO_LOG" 0 rows imported
.
。
。
. importing table "VMQ_SQL_TEXT" 0 rows imported
. importing table "VMQ_SQL_UNQUALIFIED_NAMES" 0 rows imported
. . importing table "ZH_CLASSIFY_COUNT" 44583 rows imported
. . importing table "ZH_COLLECTION" 8 rows imported
. importing table "ZH_GONGQIU" 258 rows imported
. . importing table "ZH_GRADE" 1 rows imported
. . importing table "ZH_KEYWORD" 787 rows imported
. importing table "ZH_NEWS" 396 rows imported
. importing table "ZH_SUPPLY" 220 rows imported
. importing table "ZH_SUPPLY_ANSWER" 16 rows imported
. importing table "ZH_UPLOAD" 1 rows imported
. . importing table "ZH_USER" 8877 rows imported
IMP-00041: Warning: object created with compilation warnings
"CREATE TRIGGER "QS_CS".secure_employees"
" BEFORE INSERT OR UPDATE OR DELETE ON employees"
"BEGIN" " secure_dml;"
"END secure_employees;"
IMP-00041: Warning: object created with compilation warnings
"CREATE TRIGGER "QS_CS".update_job_history"
" AFTER UPDATE OF job_id, department_id ON employees"
" FOR EACH ROW"
"BEGIN"
" add_job_history(ld.employee_id, ld.hire_date, sysdate,"
" ld.job_id, ld.department_id);"
"END;"
IMP-00017: following statement failed with ORACLE error 600:
"BEGIN "
"SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_QUEUE_TABLE('QS_CS_ORDER_STATUS_QT',1,125,2"
",0,0,'Customer Status multi consumer queue table');"
"COMMIT; END;"
IMP-00003: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [kwqickcidx:], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_AQ_SYS_IMP_INTERNAL", line 197
ORA-06512: at "SYS.DBMS_AQ_IMP_INTERNAL", line 31
ORA-06512: at line 2
IMP-00015: following statement failed because the object already exists:
"BEGIN "
"SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_QUEUE(HEXTORAW('4E96F55AAF624CCBB722FF4871D"
"412DF'),'QS_CS_ORDER_STATUS_QT','AQ$_QS_CS_ORDER_STATUS_QT_E',1,0,0,0,0,'ex"
"ception queue');"
"COMMIT; END;"
IMP-00091: Above error occurred on the following function and object: CREATE AQ$_QS_CS_ORDER_STATUS_QT_E. Remaining PL/SQL blocks for this object will be skipped.
IMP-00015: following statement failed because the object already exists:
"BEGIN "
"SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_QUEUE(HEXTORAW('168993796DB04A4083234310FAB"
"4C7E9'),'QS_CS_ORDER_STATUS_QT','QS_CS_BOOKEDORDERS_QUE',0,5,0,0,0,'');"
"COMMIT; END;"
IMP-00091: Above error occurred on the following function and object: CREATE QS_CS_BOOKEDORDERS_QUE. Remaining PL/SQL blocks for this object will be skipped.
IMP-00015: following statement failed because the object already exists:
"BEGIN "
"SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_QUEUE(HEXTORAW('AD05A30810E9420F915A81A325F"
"0DF33'),'QS_CS_ORDER_STATUS_QT','QS_CS_SHIPPEDORDERS_QUE',0,5,0,0,0,'');"
"COMMIT; END;"
IMP-00091: Above error occurred on the following function and object: CREATE QS_CS_SHIPPEDORDERS_QUE. Remaining PL/SQL blocks for this object will be skipped.
IMP-00015: following statement failed because the object already exists:
"BEGIN "
"SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_QUEUE(HEXTORAW('3F2D878F5BE948D98F9F2136CE3"
"9BB1E'),'QS_CS_ORDER_STATUS_QT','QS_CS_BILLEDORDERS_QUE',0,5,0,0,0,'');"
"COMMIT; END;"
IMP-00091: Above error occurred on the following function and object: CREATE QS_CS_BILLEDORDERS_QUE.
Remaining PL/SQL blocks for this object will be skipped.
IMP-00015: following statement failed because the object already exists:
"BEGIN "
"SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_QUEUE(HEXTORAW('8D66D71E9BAC4D509A994694820"
"19849'),'QS_CS_ORDER_STATUS_QT','QS_CS_BACKORDERS_QUE',0,5,0,0,0,'');"
"COMMIT; END;"
IMP-00091: Above error occurred on the following function and object:
CREATE QS_CS_BACKORDERS_QUE. Remaining PL/SQL blocks for this object will be skipped.
IMP-00017: following statement failed with ORACLE error 3113:
"BEGIN "
"DECLARE "
"ta sys.re$table_alias_list;"
"vt sys.re$variable_type_list;
"BEGIN"
"ta := sys.re$table_alias_list();"
"vt := sys.re$variable_type_list();"
"ta.extend(1);"
"ta(1) := sys.re$table_alias('TAB','QS_CS_ORDER_STATUS_QT');"
"dbms_rule_imp_obj.import_evaluation_context('AQ$_QS_CS_ORDER_STATUS_QT_V', "
"ta, vt, NULL,NULL, 1);"
"END; "
"COMMIT; END;"
IMP-00003: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00000: Import terminated unsuccessfully
