我的论坛主题

• 普通用户以 AS sysdba 也可以进去而且可以关闭数据库

  2008-06-16 09:26:50   /   Oracle数据库管理

  SYS 用户新建个SMS用户 给它付了CONNECT权限后在服务器上 用SQLPLUS /NOLOG方式登陆SQL>SMS/SMS AS SYSDBASQL> SHUTDOWN IMMEDIATE;....WHY?

  查看(131) 评论(3)

• Oracle 10G EM 创建无法分配端口是如何回事？

  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

  查看(129) 评论(9)

• Listener Tns-12542:Tns:地址已被占用

  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:地址已被占用

  查看(407) 评论(12)

• 我的客户端有时报 TNS-12542: TNS: 地址已被占用

  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

  查看(163) 评论(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

  查看(137) 评论(4)

• 归档日志无法通过RMAN还原出来！

  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

  查看(149) 评论(1)

• system表空间膨胀后如何安全有效的缩小？

  2008-05-16 10:22:17   /   Oracle数据库管理

  一不小心用户的表和索引放到了SYSTEM表空间去了，表空间从500M膨胀到9G。后来把用户的数据移走了。那该如何缩放SYSTEM表空间呢？通常是 alterdatabase datafile '/..../....dbf' resize 500M就报数据在高位置错误！用大家通用方法 就是找出对象，然后移到其它表空间里去，再来RESIZE后，再移回来！可这是系统表空间，要移的是系统表数量很多。会对数据库造成破坏性影响吗？

  查看(291) 评论(9)

• 如何还原备份后的归档日志？

  2008-05-12 15:58:44   /   Oracle数据库管理

  备份时候我把它打进了备份集了 137piece handle=/oradata/gstgate/rmanbackup/full_GSTGATE_134_20080508_654149207.bak tag=TAG20080508T040020 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:06:06Finished backup at 2008-05-08 04:12:53Starting backup at 2008-05-08 04:12:53using channel ORA_DISK_1channel ORA_DISK_1: starting compressed full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00001 name=/oradata/gstgate/syste

  查看(111) 评论(0)

• 空库：ORA-12547: TNS:lost contact

  2008-05-07 15:00:11   /   Oracle数据库管理

  [oracle@localhost ~]$ export ORACLE_SID=gstsms[oracle@localhost ~]$ rman target/Recovery Manager: Release 10.2.0.4.0 - Production on Wed May 7 14:55:06 2008Copyright (c) 1982, 2007, Oracle.All rights reserved.oraclegstsms: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directoryRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-005

  查看(468) 评论(9)

• ORACLE日常监控的脚本和系统的脚本？

  2008-05-07 09:59:58   /   Oracle数据库管理

  我的是ORACLE10G R2 LINUX 企业4 UPDATE4 64需要个日常监控的脚本 来收集数据库和系统的 性能 CPU io 空间和数据增长量的

  查看(163) 评论(2)