Oracle Exclusive
http://halimdba.blogspot.com/(you can change it to your desire time) And if it (script) found that the specific webpage is down then it will send you an email that your web site is down
Oracle error log - Oracle Database
Does Oracle have a databse error log where all database errors are logged to? I've searched(maybe not hard enough) for either an overall oracle log and for an instance specific log, but have not found anything
Oracle Forms 10g FAQ
Forms 6i will be supported until December 31st, 2004, or December 31st, 2007 with Extended Support for customers who wish to maintain such applications. However, these utilities give a misleadingly high figure for memory consumption, as they fail to take into account the extensive sharing of memory that takes place between concurrent Forms sessions
If you are on Solaris, minimum OAS version should be 10.1.3.1 (If you are on 10.1.3.0.0 on Solaris, first upgrade to 10.1.3.1 and then upgrade to 10.1.3.4) 5. should i perform any steps regarding adapters before running the installer Atul Kumar said, in December 1st, 2008 at 3:17 am Khaled, Update exact error message
It receives two parameters: A number that indicates where do we want to write our message Writing to a TRACE file Writing to the Alert.log file Writing to both of them A text string (the message itself)
Using Oracle-Managed Files
With Oracle-managed files, files are created and managed automatically for you, but with Automatic Storage Management you get the additional benefits of features such as file redundancy and striping, without the need to purchase a third-party logical volume manager. Multiple file systems are constructed to give different storage characteristics to different files as well as to divide the available disk space into pools that do not affect each other
DBA Tips Archive for Oracle
Figure 7: Switchover Back to Original Configuration Requirements to Perform a Rolling Upgrade Using SQL Apply For the purpose of this guide, it is assumed that Oracle Database 10g Release 2 and any patchsets have been installed on all nodes in the Data Guard configuration. It is important to understand that at this phase of the SQL Apply rolling upgrade that the additional physical standby databases will not be configured as standby databases of the original logical standby when it becomes the primary
About the Oracle Database Fault Diagnosability Infrastructure
Other ADR Contents In addition to files mentioned in the previous sections, the ADR contains health monitor reports, data repair records, SQL test cases, incident packages, and more. Table 8-2 ADR Home Subdirectories Subdirectory Name Contents alert The XML-formatted alert log cdump Core files incident Multiple subdirectories, where each subdirectory is named for a particular incident, and where each contains dumps pertaining only to that incident trace Background and server process trace files and SQL trace files (others) Other subdirectories of ADR home, which store incident packages, health monitor reports, and other information Figure 8-1 illustrates the directory hierarchy of the ADR for an Oracle Database instance
In spite the housekeeping or purging of those files got not simplified, unfortunately the new Oracle utility ADRCI can not purge all the files that Oracle database generates in ADR. About Me Kirill Loifman - Oracle DBA, Germany Being an Oracle Certified Professional database administrator I have more than a decade full-time DBA experience
This is useful If multiple databases share the same autobackup destination (as would be the case if several databases have a common flash recovery area). 2- RMAN backups: in this case you have three options: UNTIL TIME Recovery (before a specific time), UNTIL SEQUENCE recovery (before the one specified corrupted, missed archive log or redo log file), UNTIL SCN Recovery (before the one specified SCN or system change number)
I have tried various methods to convert to primary but everytime when I try to switchover it gives errors like "Media recovery required" or "Imcompatible media recovery in progress". We shifted the standby database ( B ) at new location and changed it to primary with following command: statup mount; alter database recover managed standby database finish; alter database commit to switchover to physical primary; shutdown; startup; This new primary ( B ) was open for end users for 2 days during which old primary ( A ) was shutdown
ORACLE - DBA Tips Corner
You can replace a failed OCR online, and you can update the OCR through supported APIs such as Enterprise Manager, the Server Control Utility (SRVCTL), or the Database Configuration Assistant (DBCA). Recover OCR from Automatically Generated Physical Backup This section demonstrates how to recover the Oracle Cluster Registry from a lost or corrupt OCR file
About Me Kirill Loifman - Oracle DBA, Germany Being an Oracle Certified Professional database administrator I have more than a decade full-time DBA experience. This is the main difference compared with previous releases where critical error information is dumped into the corresponding process trace files instead of incident dumps
With this solution, you will have Oracle managing your backup files in your FRA plus a secure copy of your backup files in a second physical location, ideally, another physical secure disk device. Because I choose CONFIGURE AUTOBACKUP CONTROLFILE; If you choose to specify the locations in your RMAN scripts using format option , automatic space management of the FRA will not be enabled for those backups
Oracle 11g changes to Optimal Flexible architecture OFA standard
Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. Enter new admin subdirectories New in Oracle 11g we see the new ADR (Automatic Diagnostic Repository) and Incident Packaging System, all designed to allow quick access to alert and diagnostic information
Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. Previously, more than one location could be specified using this parameter as long as the locations all appeared together, meaning no other parameters in between two locations
thanks and regards pradeep Shahnawaz said, in July 31st, 2008 at 2:55 am Hi, Someone has reset the password of one of the user in R12,we have reverted it back, but we need to check who has reset the password and when
No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Regards, Steven Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Basically RMAN doesnt backup corrupt archived logs
Oracle's alert.log
Common messages in the alert log ARCx: Media recovery disabled This message will be written into the alert.log if the arch process is started with the database being in noarchive log mode. Thread 1 cannot allocate new log, sequence 1558 Checkpoint not complete This error message is written into the alert.log if a checkpoint cannot write all dirty db blocks to the online redo log
February 28, 2011, 2:38 pm Reply Ad Smeulders says Hi Shad, Downloaded your script some days ago and it runs like a charm on HP-UX 11.31 with oracle 11gR2.. I heard as a joke that the overall goal was to keep the DBAs busy and clear of risks of unemployment, but was it really a joke ? I would suggest a few modifications on the current version of the script though
Expertise in Oracle Apps....: How to find log files locations in 11i and R12
http://oracleajidba.blogspot.com/2010/05/how-to-find-log-files-locations-in-11i.htmlHow to bounce Apache, clear HTML cache and have updated Java code class active in R12 In this post, sharing the difficulties of boucing Apache, clearing HTML comparing with 11i. FRM-92120 Registry.dat is missing error message with EBusiness Suite 11i After a new installation of Oracle eBusiness Suite, when launching a forms based function on a particular user PC, the user encounters the f..
No comments:
Post a Comment