-
2008-04-22 22:51:29 / Oracle数据库管理
Export: Release 9.2.0.6.0 - Production on Tue Apr 22 21:46:28 2008Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.6.0 - ProductionExport done in US7ASCII character set and UTF8 NCHAR character setserver uses ZHS16GBK character set (possible charset conversion)About to export specified users ....
查看(130)
评论(5)
-
2008-04-19 12:04:36 / Oracle数据库管理
SQL> select * from v$tablespace;TS# NAMEINCLUD---------- ------------------------------------------------------------ ------0 SYSTEMYES1 UNDOTBS1YES3 CWMLITEYES4 DRSYS
查看(5242)
评论(10)
-
2008-03-26 21:44:34 / Oracle数据库管理
Microsoft Windows [Version 5.2.3790](C) Copyright 1985-2003 Microsoft Corp.C:\Documents and Settings\Administrator>sqlplus "/ as sysdba"SQL*Plus: Release 9.2.0.1.0 - Production on 星期三 3月 26 21:26:10 2008Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.ERROR:ORA-01031: insufficient privileges请输入用户名:sqlnet.ora文件# sqlnet.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora# Generated by Orac
查看(88)
评论(3)
-
2008-03-15 11:39:57 / Oracle数据库管理
例如我7654这个进程占的CPu最多，我怎么才能看出他的sql语句，和执行计划
查看(160)
评论(3)
-
2008-03-14 22:31:32 / Oracle数据库管理
在9I的时候NET MANAGER 配完后在企业管理器可以挂接远程的数据库，在1OG可以吗，怎么没找到,10G的企业管理器真不习惯。
查看(176)
评论(7)
-
2007-12-26 09:09:33 / Oracle数据库管理
先是shutdown immediate半天停在哪里等不及了之后shutdown abortstartup后出现下面问题：SQL> startupORACLE instance started.Total System Global Area 2148620668 bytesFixed Size457084 bytesVariable Size771751936 bytesDatabase Buffers1375731712 bytesRedo Buffers679936 bytesORA-00205: error in identifying controlfile, check alert log for more infobdump的alter日志：Wed Dec 26 09:21:23 2007starting up 1 shared
查看(134)
评论(5)
-
2007-12-10 15:22:42 / Oracle数据库管理
root是 root:x:0:1:Super-User:/:/sbin/shoracle::105:50:Oracle Database Account:/DMCDBS01/oracle:/bin/csh两种不同的shell我跑这个./oraincrbk.shroot@ # more oraincrbk.sh#!/usr/bin/csh## Backup Oracle instance DMM02echo Backup Oracle instance DMM02 on `date`su - oracle -c "/opt/tivoli/tsm/scripts/incrbkEDM02.sh"root@ # more incrbkEDM02.sh#!/usr/bin/csh## Backup database instance EDM02 at incremental level 1#setenv ORACLE_SID DMM02rman target
查看(181)
评论(4)
-
2007-11-19 14:48:05 / Oracle数据库管理
先是这个实例可以起来SQL> select * from v$instance;INSTANCE_NUMBER INSTANCE_NAME--------------- ----------------HOST_NAME----------------------------------------------------------------VERSIONSTARTUP_T STATUSPARTHREAD# ARCHIVE LOG_SWITCH_----------------- --------- ------------ --- ---------- ------- -----------LOGINSSHU DATABASE_STATUSINSTANCE_ROLEACTIVE_ST---------- --- ----------------- ------------------ ---------1 DMC
查看(125)
评论(3)
