用友NC55測試環(huán)境配置手冊

1、.：.；安裝ORACLE進入命令行cmdsqlplus/as sysdba建立oracle表空間：“E:NC55_tablespaces為相應表空間存儲途徑。CREATE TABLESPACE NNC_DATA01 DATAFILE E:NC55_tablespacesnnc_data01.dbf SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ; CREATE TABLESPACE NNC_DATA02 DATAFILE E:NC55_tablespacesnnc_data02.dbf SI

2、ZE 300M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ; CREATE TABLESPACE NNC_DATA03 DATAFILE E:NC55_tablespacesnnc_data03.dbf SIZE 500M AUTOEXTEND ON NEXT 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K ;CREATE TABLESPACE NNC_INDEX01 DATAFILE E:NC55_tablespacesnnc_index01.dbf SIZE

3、 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ; CREATE TABLESPACE NNC_INDEX02 DATAFILE E:NC55_tablespacesnnc_index02.dbf SIZE 300M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ; CREATE TABLESPACE NNC_INDEX03 DATAFILE E:NC55_tablespacesnnc_index03.dbf SIZE

4、 500M AUTOEXTEND ON NEXT 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;CREATE USER NC55 IDENTIFIED BY NC50 DEFAULT TABLESPACE NNC_DATA01 TEMPORARY TABLESPACE temp;GRANT connect,dba to NC55;COMMIT;Oracle數(shù)據(jù)庫優(yōu)化對于Oracle用戶，更新指定表統(tǒng)計信息方法需求在sqlplus中執(zhí)行。下面是在sqlplus中執(zhí)行優(yōu)化操作命令，NC5.5是當前系統(tǒng)存儲業(yè)務數(shù)據(jù)的用戶。這個存促過程執(zhí)行中，假設(shè)個別

5、表分析出錯后，會繼續(xù)處置其他表，并將錯誤信息寫入analyze_log表。 SQLconnect NC35/NC35oracleSQLgrant create any table to nc35 ; - 這一步非常重要，需求顯式地賦予用戶建表權(quán)限SQL CREATE OR REPLACE PROCEDURE ANALYZE_TB AS V_TABLENAME VARCHAR2(50); -table的稱號 v_indexname varchar2(50);-index的稱號 V_SQL VARCHAR2(300); V_SQL1 VARCHAR2(300); OWNER_NAME VARCHA

6、R2(100); V_LOG INTEGER; CURSOR CUR_TABLE IS - 游標 SELECT TABLE_NAME FROM USER_TABLES WHERE temporary=N; -no temp table CURSOR CUR_TABLE_TEMP IS SELECT TABLE_NAME FROM USER_TABLES WHERE temporary=Y; CURSOR CUR_LOG IS SELECT COUNT(TABLE_NAME) FROM USER_TABLES WHERE TABLE_NAME=ANALYZE_LOG; CURSOR cur_in

7、dex IS select index_name from user_indexes group by index_name; BEGIN -DBMS_OUTPUT.ENABLE (buffer_size=100000); BEGIN OPEN CUR_LOG; FETCH CUR_LOG INTO V_LOG; IF V_LOG=0 THEN EXECUTE IMMEDIATE CREATE TABLE ANALYZE_LOG (USER_NAME VARCHAR(20),OP_TIME CHAR(19) DEFAULT to_char(sysdate,yyyy-mm-dd hh24:mi:

8、ss),ERROR_TEXT VARCHAR(200),TABLE_NAME VARCHAR(40); END IF; - EXCEPTION - WHEN OTHERS THEN -dbms_output.put_line(-CREATE LOG_TABLE: err!); END; SELECT USER INTO OWNER_NAME FROM DUAL; V_SQL1:=INSERT INTO ANALYZE_LOG (USER_NAME,ERROR_TEXT,TABLE_NAME) VALUES (|OWNER_NAME|,ANALYZE BEGIN,ALL); EXECUTE IM

9、MEDIATE V_SQL1; -更新表統(tǒng)計信息及柱狀圖信息 OPEN CUR_TABLE; - begin LOOP FETCH CUR_TABLE INTO V_TABLENAME; EXIT WHEN CUR_TABLE %NOTFOUND; begin V_SQL:= ANALYZE TABLE | V_TABLENAME | COMPUTE STATISTICS ; EXECUTE IMMEDIATE V_SQL; -dbms_output.put_line(EXECUTE: |V_SQL| OK!); V_SQL:= ANALYZE TABLE | V_TABLENAME | CO

10、MPUTE STATISTICS FOR ALL INDEXED COLUMNS; EXECUTE IMMEDIATE V_SQL; -dbms_output.put_line(EXECUTE: |V_SQL| OK!); EXCEPTION WHEN OTHERS THEN -dbms_output.put_line(-EXECUTE: |V_SQL| err!); V_SQL1:=INSERT INTO ANALYZE_LOG (USER_NAME,ERROR_TEXT,TABLE_NAME) VALUES (|OWNER_NAME|,|V_SQL|,|V_TABLENAME|); EXE

11、CUTE IMMEDIATE V_SQL1; end; END LOOP; CLOSE CUR_TABLE; CLOSE CUR_LOG ; -刪除索引統(tǒng)計信息 OPEN cur_index ; LOOP FETCH cur_index INTO v_indexname; EXIT WHEN cur_index %NOTFOUND; begin v_sql:=analyze index |v_indexname| delete statistics ; EXECUTE IMMEDIATE v_sql; -dbms_output.put_line(EXECUTE: |V_SQL| OK!); E

12、XCEPTION WHEN OTHERS THEN - dbms_output.put_line(-EXECUTE: |V_SQL| err!); V_SQL1:=INSERT INTO ANALYZE_LOG (USER_NAME,ERROR_TEXT,TABLE_NAME) VALUES (|OWNER_NAME|,|v_sql|,|v_indexname|); EXECUTE IMMEDIATE V_SQL1; end; END LOOP; - 封鎖游標 CLOSE cur_index ; -刪除暫時表統(tǒng)計信息 OPEN CUR_TABLE_TEMP ; while cur_table_

13、temp%FOUND LOOP FETCH CUR_TABLE_TEMP INTO V_TABLENAME; EXIT WHEN CUR_TABLE_TEMP%NOTFOUND; begin V_SQL:= ANALYZE TABLE | V_TABLENAME | DELETE STATISTICS ; EXECUTE IMMEDIATE V_SQL; -dbms_output.put_line(EXECUTE: |V_SQL| OK!); EXCEPTION WHEN OTHERS THEN - dbms_output.put_line(-EXECUTE: |V_SQL| err!); V

14、_SQL1:=INSERT INTO ANALYZE_LOG (USER_NAME,ERROR_TEXT,TABLE_NAME) VALUES (|OWNER_NAME|,|V_SQL|,|V_TABLENAME|); EXECUTE IMMEDIATE V_SQL1; end; END LOOP; - 封鎖游標 CLOSE CUR_TABLE_TEMP ; V_SQL1:=INSERT INTO ANALYZE_LOG (USER_NAME,ERROR_TEXT,TABLE_NAME) VALUES (|OWNER_NAME|,ANALYZE END,ALL); EXECUTE IMMEDI

15、ATE V_SQL1; commit; EXCEPTION WHEN OTHERS THEN IF CUR_TABLE%ISOPEN THEN CLOSE CUR_TABLE; END IF; IF CUR_TABLE_TEMP%ISOPEN THEN CLOSE CUR_TABLE_TEMP ; END IF; IF CUR_LOG%ISOPEN THEN CLOSE CUR_LOG; END IF; IF cur_index%ISOPEN THEN CLOSE cur_index; END IF; commit; END; /SQLexec ANALYZE_TB ;下面提供的腳本示范如何創(chuàng)

16、建定時義務，也是要在sqlplus中運轉(zhuǎn)。當天的凌晨2點開場更新統(tǒng)計信息，以后每14天的凌晨2點更新統(tǒng)計信息。留意建立當前job時，運用NC的用戶銜接數(shù)據(jù)庫執(zhí)行就可以了。詳細優(yōu)化時間設(shè)置用戶根據(jù)實踐情況靈敏調(diào)整。 VARIABLE JOBNO NUMBER;VARIABLE INSTNO NUMBER;BEGIN SELECT INSTANCE_NUMBER INTO :INSTNO FROM V$INSTANCE; DBMS_JOB.SUBMIT(:JOBNO,ANALYZE_TB; ,TRUNC(SYSDATE)+1+2/24,TRUNC(SYSDATE)+15+2/24,TRUE,:IN

17、STNO);COMMIT;END;/對于晉級用戶，假設(shè)以前有相關(guān)定時義務設(shè)置，建議用戶去除以前的定時義務。詳細查看系統(tǒng)中的定時義務經(jīng)過下面SQL執(zhí)行即可。發(fā)現(xiàn)v3留下的統(tǒng)計數(shù)據(jù)庫的job，應該及時刪除掉。 SQLselect job,last_date,this_date,next_date,what,broken from user_jobs;SQLexec sys.dbms_job.remove(12);效力器端NC啟動與相關(guān)設(shè)置進入NC相應目錄如：E:ufsoft5.5nchomestartup.bat出現(xiàn)上述畫面后啟動勝利。進入E:ufsoft5.5nchomebin ncSysCon

18、fig.bat 設(shè)置相應數(shù)據(jù)參數(shù)后保管。至此效力器端配置根本終了。客戶端配置NC的客戶端不需求手動安裝，在系統(tǒng)登陸時會自動檢查用戶客戶端環(huán)境中能否安裝了JRE。當客戶端沒有安裝JRE或相關(guān)JRE版本不匹配時，系統(tǒng)或自動下載并安裝引薦版本JRE。安裝NC客戶端配置程序時要具有administrator權(quán)限，才干保證正常安裝。 在訪問NC時，需求調(diào)整IE的平安權(quán)限，詳細操作過程： 啟動IE閱讀器工具Internet選項平安自定義級別 將下載ActiveX、啟用ActiveX、cookies等選項設(shè)置為啟用在IE中設(shè)置對于本地地址不運用代理效力器。操作順序為:工具Internet選項銜接頁簽局域網(wǎng)設(shè)置。翻開Internet Explorer菜單欄點“工具Internet選項平安自定義級別平安設(shè)置 “ActiveX控件和插件下的第5個“下載未簽名的ActiveX控件選擇“提示確定！刷新您要安裝的頁面即可由于運用的軟件沒有經(jīng)過微軟的徽標認證，在SP2中默許是不允許安裝這樣的程序的，處理方法為開場-控制面板-系統(tǒng)-硬件。其中在驅(qū)動程序項里有有個“驅(qū)