-
编辑 删除
V$SESSION_EVENT
V$SESSION_EVENT[@more@]Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> conn / as sysdbaConnected.SQL> desc V$SESSION_EVENT Name Null? Type ----------------------------------------- -------- ---------------- SID NUMBER EVENT VARCHAR2(64) TOTAL_WAITS NUMBER TOTAL_TIMEOUTS NU
-
编辑 删除
v$system_event
v$system_event[@more@]Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> conn / as sysdbaConnected.SQL> desc v$system_event Name Null? Type ----------------------------------------- -------- ------------- EVENT VARCHAR2(64) TOTAL_WAITS NUMBER TOTAL_TIMEOUTS NUMBER TIME_WAITED NUMBER AV
-
编辑 删除
v$event_name
v$event_name[@more@]$ sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on Wed Jan 31 10:52:16 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> conn / as sysdbaConnected.SQL> desc v$event_name Name Null? Type ----------------------------------------- -------- -------------------- EVENT# NUMBER EVENT_ID NUMBER NAME
-
编辑 删除
TNS-12542 Error When Executing Batch Jobs or in High Transaction Environment
TNS-12542 Error When Executing Batch Jobs or in High Transaction Environment[@more@]The information in this document applies to: Oracle Net Services - Version: 8.1.7.4 to 10.1.0.0Microsoft Windows 2000Microsoft Windows XP (64-bit Itanium)Microsoft Windows (32-bit)ErrorsTNS-00512 "Address already in use"TNS-12542 TNS:address already in useTNS-12560 "TNS:protocol adapter error"SymptomsTNS-12542 errors in log files when executing batch jobs or in high transaction environments. C
-
编辑 删除
修改OEM中sysman的密码
修改OEM中sysman的密码[@more@]sysman不是oracle用户，因此不能用alter user 子句修改密码。修改方法是以oem所属用户登陆，然后运行该用户下的存储过程：smp_maintenance.RESET_SYSMAN 该过程将sysman的密码重置为oem_temp.例如，如果存放oem的用户是oem,密码也是oem在sqlplus 中执行：SQL> conn oem/oem;SQL>exec smp_maintenance.RESET_SYSMAN;
-
编辑 删除
用RMAN创建Standby Database
用RMAN创建Standby Database[@more@]数据库软件必须为企业版，主数据库和备用数据库软件版本相同（最好打了相同补丁）一.主数据库用rman创建数据库备份在进行操作前先备用原来的备用的文件和归档日志文件，以免复制的内容太多。1.备份和删除以前rman备份的文件把原来用rman备用的文件地址备份一下，建议修改一下文件目录名字，然后再创建一个目录。同样对归档日志文件进行相同的操作。1.1 sqlplus登陆修改参数检查数据库是否为归档模式，如果为非归档模式请先修改为归档模式，请参考以前的文档SQL> archive log list数据库日志模式
-
编辑 删除
Using an RMAN Backupfile Located on a Remote Network Drive (WinNT)
ORA-19505 :Using an RMAN Backupfile Located on a Remote Network Drive (WinNT)[@more@]Problem Description-------------------When using RMAN to restore a database, where the RMAN backupis located on a remote node, this fails with errors like:(In example below H: is a mapped network drive).RMAN-10035: exception raised in RPC: ORA-19505: failed to identify file"H:BACKUP_RMANBACKUP15_RMAN1_432213015"ORA-27041: unable to open fileOSD-04002: unable to open fileO/S-Error: (OS 5) Permission den
-
编辑 删除
How to use a network resource with the system account
How to use a network resource with the system account[@more@]Doc ID: Note:144485.1 Problem Description ------------------- After install of the Oracle rdbms software and the creation of a database. The created database uses the NT internal System account to run. When you try to use a network resource you get an error that the disk or resource is not accessable. This problem can occur using UTL_FILE or for example when enabling archiving to a remote disk. Solution Description
