xuansiyu的专栏

把数据库切换成ARCHIEVELOG（归档）模式1、c:\> sqlplus internal/oracle@smart.comsql> shutdown immediatesql> startup pfile=$oracle_home\admin\smart\pfile\initsmart.ora mount;sql> alter database archivelog;

查看em端口/home/oracle/app/product/10.2.0/install/portlist.ini[oracle@localhost ~]$ emctl start dbconsoleTZ set to PRCOC4J Configuration issue. /home/oracle/app/product/10.2.0/oc4j/j2ee/

开始运行的非ASM，之后添加几块硬盘后，出现无法启动数据库问题startup 的时候报ORA-27154、ORA-27300、ORA-27301、ORA-27302  用一下方法解决今天刚装了oracle11g,配制好了之后启动数据库时遇到下面的错误：SQL> startupORA-27154: post/wait create failed

先启动监听重新配置emctl$emca -config dbcontrol dbEMCA 开始于 2014-3-23 1:41:44EM Configuration Assistant, 11.2.0.0.2 正式版版权所有 (c) 2003, 2005, Oracle。保留所有权利。输入以下信息:数据库 SID: ora11监听程序端口号: 1

用root身份执行 $ORACLE_HOME/root.sh

替换字体[oracle@hngdcrm lib]$ cd $ORACLE_HOME/jdk/jre/lib/[oracle@hngdcrm lib]$ mv font.properties font.properties.bak[oracle@hngdcrm lib]$ cp font.properties.zh_CN.Redhat font.properties [oracl

由于主机名不一致，启动EM时提示[oracle@hnmtvcrm ~]$ emctl start dbconsoleTZ set to PRCOC4J Configuration issue. /home/oracle/app/product/10.2.0/oc4j/j2ee/OC4J_DBConsole_hnmtvcrm_hngdcrm not found. 我重

1、启动服务：OracleOraDb11g_home1TNSListener2、启动数据库：OracleServiceORCL服务

1.安装好Oracle数据库后: 执行 dbstart和dbshut会提示：[oracle@oracle11g ~]$ dbstartORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net ListenerUsage: /u01/app/oracle/oracle/product/10.2.0/db_1/bin

[oracle@hngdcrm bdump]$ tail -f alert_hngdcrm.log ……Errors in file /home/oracle/app/admin/hngdcrm/bdump/hngdcrm_ora_25812.trc:ORA-07445: exception encountered: core dump [kslgetl()+120] [SIGSE