oracle數(shù)據(jù)庫(kù)安裝(參考版)
2024-10-06 17:20本頁(yè)面
【正文】 注： for NTD:\oraversion\。以后每增加一個(gè)業(yè)務(wù)數(shù)據(jù)庫(kù)，都需要為該數(shù)據(jù)庫(kù)配置一個(gè)BDE別名。首先把Configuation/Drivers/Native/ORACLE/，VENDOR 。3． 打開(kāi)控制面板中的BDE Administrator配置BDE數(shù)據(jù)庫(kù)別名。需要配置ODBC用戶數(shù)據(jù)源zxinjf。服務(wù)標(biāo)識(shí)中服務(wù)名填ZXIN。一個(gè)叫zxin,，另一個(gè)服務(wù)名由數(shù)據(jù)庫(kù)服務(wù)器的IP地址拼裝而成，拼裝成的網(wǎng)絡(luò)服務(wù)名就是zx192_128_27_133。 安裝SYBASE客戶端安裝ORACLE Client , 安裝步驟請(qǐng)參考ORACLE的安裝手冊(cè)。2．增加任務(wù)的方式待定。3． 在zxinconfig庫(kù)中針對(duì)每個(gè)局在tb_zxinapliast表內(nèi)增加一條記錄。create user zxdb_186 identified by zxdb_186 default tablespace zxin_scp temporary tablespace zxin_temp profile default 創(chuàng)建業(yè)務(wù)用戶，如zxdb_kf。create user zxinchargebak identified by zxinchargebak default tablespace zxin_smp temporary tablespace zxin_temp profile default 創(chuàng)建用戶zxin。create user zxinsys_01 identified by zxinsys_01 default tablespace zxin_smp temporary tablespace zxin_temp profile default 創(chuàng)建用戶zxincharge。create user zxdb_kf identified by zxdb_kf default tablespace zxin_scp temporary tablespace zxin_temp profile default SMP/SCP合一上的用戶 創(chuàng)建用戶zxinconfig。create user zxin identified by zxin default tablespace zxin_scp temporary tablespace zxin_temp profile default 創(chuàng)建業(yè)務(wù)用戶，如zxdb_186。create user zxincharge identified by zxincharge default tablespace zxin_smp temporary tablespace zxin_temp profile default 創(chuàng)建用戶zxinchargebak。create user zxinconfig identified by zxinconfig default tablespace zxin_smp temporary tablespace zxin_temp profile default 創(chuàng)建用戶zxins
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1