oracle 移植问题
qtal110
|
1#
发表于 2004-11-09 19:16
oracle 移植问题
在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/binPATHexport 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_PATHexport PATH=/opt/oracle/product/9.2/bin PATHexport 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 importedIMP-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 |