ITPub博客

使用oracle数据库的时候以sysdba连接数据库出现如下错误连接 Oracle 出现 ORA-09817 错误： # sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 17 16:35:02 2011Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.ERROR:ORA-09817: Write to audit file ...

Many of the directory and file names mentioned below will be site specific. For the sake of illustration, I'm assuming that Oracle was installed with a userid called 'oracle' and the main control files are located in /u01/app/oracle/admin/tsm_rman. We are backing up a database called PBW on an AIX...

UTL_FILE_DIR is the database initialization parameter the Oracle Database uses to determine what operating system directories and files PL/SQL packages, functions, and procedures may read from or write to when using the standard UTL_FILE database package.  The directories specified in the UTL...

在数据库的开发中，当PL/SQL语句很复杂的时候，我想写一些Log，就像java的Log4j那样。这样就可以很好的跟踪程序的运行情况。在网上找到的文章不是很好用，修改了一下。1：在Oracle服务器上建立一个目录并指定权限（我这个是unix的。windows用c:/tmp之类的就行）CREATE DIRECTORY TEMP AS '/tmp';GRANT READ,WRIT...

create or replace procedure p_create_table    Authid Current_User is    begin    Execute Immediate 'create table create_table(id int)';    end p_create_table; 红色字体为关键  使用户可以使用权限执行execute 我们知道...

SQL> select name, db_unique_name, open_mode from v$database;NAME      DB_UNIQUE_NAME                 OPEN_MODE--------- ------------------------------ ----------SHRARS    ...

V$RMAN_BACKUP_JOB_DETAILS展示了rman备份的相关细节。比如，rman备份持续时间、rman备份的执行次数、每一次rman备份工作的状态（failed or completed and so on），每次rman备份的起始时间等等。SQL> desc sys.v$rman_backup_job_details Name                   ...

测试环境中执行opatch报错，简单描述一下解决过程。  错误信息如下：[orat3@hpserver2 OPatch]$ ./opatch lsinventoryInvoking OPatch 10.2.0.5.1Oracle Interim Patch Installer version 10.2.0.5.1Copyright (c) 2010, Oracle Corporation.  All rights reserved.Oracl...

oraInventory存放的是Oracle软件安装的目录信息，Oralce的安装升级都需要用到这个目录，来看看Oracle文档中对这个目录的一点说明：All Oracle software installations rely on this directory. Ensure that you back it up regularly. Do not delete this directory unless you have completely removed&nbs...

SQL> set linesize 200set pagesize 1000column name format a40column value format a60select inst_id, name,value from gv$parameterwhere name in ('db_create_file_dest',               'audit_file_dest',    ...

Troubleshooting impdp is hanging no progressSR 3-17141087871 : impdp is hanging no progressHello jyothi babu -Provide the following information1. The command used when importing (include parfile if used)2. What is it waiting on? set pagesize 1000 set linesize 120 set...

https://www.ibm.com/support/knowledgecenter/SSTFZR_6.4.0/com.ibm.itsm.db.orc.doc/r_dporc_rman_script_ex.htmlIBM Tivoli Storage Manager for Databases, Data Protection for Oracle, Version 6.3Script examplesSample RMAN scripts illustrate how to create parallel backup streams to Tivoli...

RMAN>run>{>set archivelog destination to '/stage';>restore archivelog from logseq 100278 until logseq 100298;>}In some scenarios we may need to restore the archivelogs to a different location from its primary location using RMAN from its backups.Below are the methods to do it.1. &...

alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';col status format a15col description format a40 word_wrapset serverout on size 999999 lines 150 verify off pages 50 echo off trimspool onbreak on reportcompute Sum LABEL SUM of undosize_MB on reportcompute Sum LABEL SUM of block_coun...

If database server CPU usage is showing 100%, or high 90%, DBA needs to find out which session is hogging the CPU(s) and take appropriate action.I will explain in the following that how can we find out the session(s) which are excessively using CPU.v$statname and v$sesstat dictionary view...

How To Findout sessions/users/ SQL’s which consuming High CPU usage in Oracle Database. I been monitoring the performance of our DB server Linux using "top" command, and I got this monitor dislay: I think via TOAD I can specify the user that eats a lot of CPU,from where I can get it s...

I did get this error while I was importing a schema.Solution: User “Version” option while exporting from 12.2.x as belowOnce it is done, import it to 12.1.x version of database:

请加入QQ群参加Oracle 10g/11g RAC DataGuard, Goldengate交流和免费提供99%正确率的Oracle RAC, DataGuard, Goldengate, Streams部分实战文档和实战视频。Oracle&nbsp...

                  Oracle 10g/11g RAC, DataGuard实战环境请加入QQ群参加Oracle 10g/11g RAC Data...

请加入QQ群参加Oracle 10g/11g RAC DataGuard, Goldengate交流和免费提供99%正确率的Oracle RAC, DataGuard, Goldengate, Streams部分实战文档和实战视频。Oracle&...