【正文】
nt CONNECT to fsboss。grant DBA to fsboss。grant unlimited tablespace to fsboss。alter user fsboss default role all。mit。依次執(zhí)行創(chuàng)建表、存儲(chǔ)過(guò)程、seq、packet、funcs等sql。(打開(kāi)iptables允許1521端口訪(fǎng)問(wèn),)(db本機(jī)上導(dǎo), db 報(bào)錯(cuò)) wins cmdexp userid=fsboss/fsboss@boss file= log=(.9上wins客戶(hù)端(9i) server(9i)) wins cmdimp system/oracle@boss_119_local_vm fromuser=fsboss touser=fsbos file=e:\fsboss_dmp\ log=e:\fsboss_dmp\ mit=n ignore=y9 設(shè)置開(kāi)機(jī)自動(dòng)啟動(dòng)Oracle0. 修改/etc/oratab,設(shè)置開(kāi)機(jī)可啟動(dòng),boss:/opt/oracle9/product/:Y1. cd /etc/2. vi oracle3. 輸入如下內(nèi)容:chkconfig:2345 98 05description:Oracle Serveradd for oracleORACLE_BASE=/opt/oracle9export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/export ORACLE_HOMEORACLE_SID=BOSSexport ORACLE_SIDORA_NLS33=$ORACLE_HOME/omon/nls/admin/dataexport ORA_NLS33NLS_LANG=export NLS_LANGLD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/libexport LD_LIBRARY_PATHcase $1 in start) echo Starting Oracle... su oracle c /opt/oracle9/product/ su oracle c /opt/oracle9/product/$ORACLE_HOME/bin/ 2$ORACLE_HOME/bin/ echo Started.exit 0。 stop) echo