redhatenterpriselinux54上安裝oracle10g(參考版)
2025-04-12 11:16本頁面
【正文】 六、 監(jiān)聽配置參考/opt/oracle/product/LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) ) )/opt/oracle/product/ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORCL) ) )55 / 55。 查詢service name：SQL show parameter service_names。HOST_NAME INSTANCE_NAME VERSION Fantasy orc 查詢數(shù)據(jù)庫名：SQL select name from v$database。 [oracleFantasy ~]$ sqlplus / as sysdbaSQL set line 200 *) echo Usage: `basename $0` start|stop|restart|reload exit 1esacexit 0使用chkconfig 設(shè)置運(yùn)行權(quán)限chkconfig dbora reset加載到自動啟動目錄 chkconfig list | grep dboradbora 0:關(guān)閉 1:關(guān)閉 2:啟用 3:啟用 4:啟用 5:啟用 6:關(guān)閉 一些服務(wù)介紹和補(bǔ)充 a：$ORACLE_HOME/bin/dbstart | dbshutb：$ORACLE_HOME/bin/lsnrctl start | stop 監(jiān)聽器啟動|關(guān)閉。 stop) Oracle listener and instance shutdown echo n Shutdown Oracle: su $ORA_OWNR c $ORACLE_HOME/bin/lsnrctl stop su $ORA_OWNR c $ORACLE_HOME/bin/dbshut rm f /var/lock/oracle su $ORA_OWNR c $ORACLE_HOME/bin/emctl stop dbconsole su $ORA_OWNR c $ORACLE_HOME/bin/isqlplusctl stop echo OK 。full=y ignore=y登陸內(nèi)網(wǎng)服務(wù)器后，切換到oracle賬戶，su – oracle，輸入imp lvs/lvs file=/data/oraclebackup/ ignore=y full=y配置oracle啟動(本例sid是切換到oracle賬戶下，su – oracle,輸入sqlplus /nolog,進(jìn)入數(shù)據(jù)庫，orcl) 安裝后在運(yùn)行$ORACLE_HOME/bin/dbstart時報錯，F(xiàn)ailed to autostart Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnslsnr解決方法:vi $ORACLE_HOME/bin/dbstart這個文件，找到ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle修改為ORACLE_HOME_LISTNER=$ORACLE_HOME配置/etc/oratab文件chown oracle:oinstall oratabvi /etc/oratab文件 將orcl:/datas/apps/oracle/product/:N 修改為orcl:/datas/apps/oracle/product/:Y完成以上操作后，下面創(chuàng)建自啟動腳本dbora。lvs/lvscag1第四，GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW , DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE, DBA,CONNECT,RESOURCE,CREATE SESSION TO 用戶名字 grant create user,drop user,alter user,create any view,drop any view,exp_full_database,imp_full_database,dba,connect,resource,create session to lvs2 。lsnrctl start 39。dbstart39。39。:39。要從命令行執(zhí)行此操作，請在以 oracle 身份登錄后使用 SQL*Plus，如下所示：啟動： $ sqlplus SQL*Plus:Release Production on Sun Jun 13 22:27:48 2004 Copyright (c) 1982, 2004, rights reserved. Enter username:/ as sysdba Connected to an idle instance. SQL startup ORACLE instance started. Total System Global Area 188743680 bytes Fixed Size 778036 bytes Variable Size 162275532 bytes Database Buffers 25165824 bytes Redo Buffers 524288 bytes Database mounted. Database opened. SQL exit Shutd
公司管理相關(guān)推薦
鄂ICP備17016276號-1