Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account
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
When this argument is specified, CVU auto generates fixup scripts containing appropriate values for those parameters that need to be fixed and their fix is supported by CVU. NOTE: For each verification command that supports the optional -r option to specify the supported Oracle release, the default release is assumed to be 11gR2 if -r option is not specified
Initialization Parameters
The unit of this parameter is measured in physical operating system blocks unless it has a suffix M or K, in which case the unit is Megabyte and Kilobyte, respectively. It affects also the optimal setting for SEMMNS (Number of semaphores in the system): 2*highets process value + 1*other process values + 10 * count of instances
Installing Oracle Database 10g Real Application Cluster (RAC) on Red Hat Linux Advanced Server (RedHat, Oracle10g RAC)
After you finished creating the partitions, inform the kernel of the partition table changes: su - root partprobe Creating Partitions for OCFS If you use OCFS for database files and other Oracle files, you can create several partitions on your shared storage for the OCFS filesystems. Checking Packages (RPMs) Some packages will be missing when you selected the Installation Type "Advanced Server" during the Red Hat Advanced Server installation
init.ora file location
However in order to deploy my WebReports over the Web, WebReports called from WebForms using Parameter Forms, I ran in to Report Services Errors such as: REP-50125, REP-51018 and REP-51019 in a reports trace file
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)
New Features Oracle 10G
Notable among the missing functionality was support for Advanced Encryption Standard (AES), a more powerful successor to the older Digital Encryption Standard (DES) and Triple DES (DES3). Oracle Enterprise Manager (OEM) for Oracle10G and the Database Configuration Assistant (DBCA) have been updated to allow administrators to configure and manage databases using ASM
Wait Event Enhancements in Oracle 10g
Meanwhile, ST (space management), HW (high-water mark extension), and SQ (sequence number) enqueues are in the Configuration class, as these can usually be alleviated by changes in object and database settings. Conclusion Oracle 10g includes many enhancements to the wait event interface that should make performance management using wait event methodologies easier than ever
Create Oracle Trace file for 10046
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. I just know there will be at least one person who will ask if it?s possible to set the event for the whole database, so we are demonstrating that it can be done
Parameters for the sqlnet.ora File
Note the following implications of setting the value to 12: To take advantage of the password protections introduced in Oracle Database 11g, users must change their passwords. See Also: Oracle Database Net Services Administrator's Guide for additional information about configuring this parameter Default The default value for this parameter is operating system-specific
Profile Parameters (sqlnet.ora)
Note the following implications of setting the value to 12: To take advantage of the password protections introduced in Oracle Database 11g, users must change their passwords. If the database server is unable to complete a send operation in the time specified, then it logs an ORA-12535: TNS:operation timed out and ORA-12608: TNS: Send timeout occurred to the sqlnet.log file
profiling trace files with preprocessor external tables in 11g
generating and reading tkprof reports Now that we have our Oracle directories, we can connect as our user and create an external table to generate and read TKProf reports, as follows. Wherever possible, this technique should be avoided and all work performed on the server itself (although this isn't always possible in controlled environments)
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
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. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters
Oracle database 11g offers a new quick, easy, instant solution; instead of updating ALL the rows of the table, Oracle 11g now updates the metadata only
No comments:
Post a Comment