ITPUB个人空间 »
zengmuansha的个人空间
欢迎访问 zengmuansha 的个人空间
我的论坛主题
-
2008-10-06 23:03:18 / Oracle数据库管理
面试时候被问道 RAC中哪个组件负责客户段连接的调解 应该安装在哪台机器上。?谁知道告诉下
查看(145)
评论(9)
-
2008-08-19 10:49:38 / Oracle数据库管理
我的数据库是发送短讯的,日志大小为200M。昨天产生17个归档日志,共3009M。17天归档日志压缩后还占用80G请问下如何才能减少日志产生量?
查看(141)
评论(10)
-
2008-08-13 10:14:39 / Oracle数据库管理
公司要买一套ORACLE 想咨询下!买什么版本好,什么价钱,是按用户算,还是按CPU算 各位能给个详细的不
查看(133)
评论(6)
-
2008-07-21 10:06:05 / Oracle数据库管理
不知道该作业停止运行很多天,后来我上午10点发现了,并手工执行了该脚本,同时通过EM把作业启动起来了。可第二天发现,作业运行时间定在上午10点钟。这时段时工作繁忙时期,所以想安排它到凌晨6点。可找不到修改的地方?
查看(188)
评论(3)
-
2008-06-16 09:26:50 / Oracle数据库管理
SYS 用户新建个SMS用户 给它付了CONNECT权限后在服务器上 用SQLPLUS /NOLOG方式登陆SQL>SMS/SMS AS SYSDBASQL> SHUTDOWN IMMEDIATE;....WHY?
查看(204)
评论(3)
-
2008-06-16 09:22:22 / Oracle数据库管理
[oracle@zfbdbsvr config]$ emca -config dbcontrol dbSTARTED EMCA at Jun 14, 2008 11:45:48 AMEM Configuration Assistant, Version 10.2.0.1.0 ProductionCopyright (c) 2003, 2005, Oracle.All rights reserved.Enter the following information:Database SID: gstgateListener port number: 1521Password for SYS user:Password for DBSNMP user:Password for SYSMAN user:Email address for notifications (optional): fk@iems.net.cn]zeng-fk@iems.net.cnOutgoing Mail (SMTP) server for notif
查看(291)
评论(9)
-
2008-05-30 15:33:56 / Oracle数据库管理
# listener.ora Network Configuration File: /u01/oracle/product/10.2.0/network/admin/listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(GLOBAL_DBNAME = gstgate)(ORACLE_HOME = /u01/oracle/product/10.2.0)(SID_NAME = gstgate)))LISTENER =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.11.219)(PORT = 1521))))因为通过WEBLOGIC时候 时不时地报 Listener Tns-12542:Tns:地址已被占用
查看(714)
评论(12)
-
2008-05-26 14:59:49 / Oracle数据库管理
我的客户端有时报,可服务器上没有相同的监理服务啊。过会儿又正常了。大家可有遇到这种事情,给各方向来啊Fatal NI connect error 12542, connecting to:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.11)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=GSTGATE)(CID=(PROGRAM=D:Program FilesQuest SoftwareTOADTOAD.exe)(HOST=GSTSMSGATE01)(USER=gstsmsgate01))))VERSION INFORMATION:TNS for 32-bit Windows: Version 10.2.0.1.0 - ProductionWindows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Versi
查看(219)
评论(1)
-
2008-05-20 11:04:26 / Oracle数据库管理
CONFIGURE CONTROLFILE AUTOBACKUP OFF;new RMAN configuration parameters are successfully storedRMAN> backup database plus archivelog;开始备份已有的归档日志Starting backup at 2008-05-17 13:14:24current log archivedusing channel ORA_DISK_1channel ORA_DISK_1: starting compressed archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=189 recid=341 stamp=654926910input archive log thread=1 sequence=190 recid=343
查看(199)
评论(4)
-
2008-05-16 17:04:15 / Oracle数据库管理
RMAN> backup database plus archivelog;channel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=448 recid=950 stamp=654532262channel ORA_DISK_1: starting piece 1 at 2008-05-16 15:10:45channel ORA_DISK_1: finished piece 1 at 2008-05-16 15:21:30piece handle=/oradata/gstgate/rmanbackup/full_GSTGATE_152_20080516_654880244.bak tag=TAG20080516T151043 comment=NONE数据文件也备份到了=/oradata/gstgate/rmanbackup/full_GSTGATE_153_20080516_654880244.ba
查看(222)
评论(1)