• Home
  • RMAN
  • Database
    • Data Guard
    • Data Pump
    • Performance Tuning
    • Security
    • General
  • Enterprise Manager
    • Grid Control 11g
    • Cloud Control 12c
  • Middleware
    • APEX
    • Application Server
    • Forms & Reports
    • WebLogic Server
  • OS
    • Linux & UNIX
    • Windows
    • VirtualBox
  • SQL Server
  • MongoDB
  • About Me
Home » Articles posted by Garth ( » Page 3)

Author Archives: Garth

Creating an Oracle 11g Database using DBCA (non-ASM)

Posted on May 19, 2013 by Garth

In this example, I’ve already installed the Oracle Database 11gR2 software (11.2.0.4 in this example) on one of my Linux 6.4 machines, and I’m going to create a new database instance simply called ’emrep’ (as it’s going to be used for my EM12c database repository) using the DBCA tool. The data files will be stored under

Read More…

Posted in Database | Tags: 11g, create, database, dbca, emrep, netca | 3 Comments |

Oracle Database 11gR2 (11.2.0.3) installation on Oracle Linux 6.4

Posted on May 17, 2013 by Garth

In this post, I’m installing the Oracle Database 11g Release 2 (11.2.0.3) software on Oracle Linux 6.4, along with optional instructions on how to apply the latest Patch Set Update (PSU) to your new Oracle home. First and foremost, before you start, make sure your Linux server meets the minimum hardware requirements: 1GB of RAM (plus

Read More…

Posted in Database | Tags: 11g, database, install, installation, linux, psu | 2 Comments |

Removing a Domain in WebLogic

Posted on May 16, 2013 by Garth

First of all, shutdown your domain (in this example, my domain is called ‘oldDomain’ and has one Managed Server): export MW_HOME=/u01/app/oracle/middleware export WLS_HOME=$MW_HOME/wls_10.3.6 export DOMAIN_NAME=oldDomain export DOMAIN_HOME=$MW_HOME/user_projects/domains/$DOMAIN_NAME $DOMAIN_HOME/bin/stopWebLogic.sh $DOMAIN_HOME/bin/stopManagedWebLogic.sh ManagedServer_1 Remove the domain entry from the Node Manager file: vi $WLS_HOME/common/nodemanager/nodemanager.domains …remove this line: oldDomain=/u01/app/oracle/middleware/user_projects/domains/oldDomain Remove the domain registry entry relevant to your domain: vi $MW_HOME/domain-registry.xml

Read More…

Posted in WebLogic Server | Tags: delete, domain, remove, weblogic, wls | Leave a comment |

Installing and configuring the APEX Listener 2.0.1 on WebLogic 12c

Posted on May 1, 2013 by Garth

The Oracle APEX Listener is a Java based alternative to using Oracle HTTP Server (OHS) with mod_plsql.  In the past I’ve installed early versions of APEX 3 using this configuration, then later on started using EPG (Embedded PL/SQL Gateway) which worked fairly well. Recently however, I decided to try using the latest APEX Listener 2.0.1 on WebLogic 12c

Read More…

Posted in APEX, WebLogic Server | Tags: 12c, 2.0, apex, listener, weblogic | 14 Comments |

Installing APEX 4.2 and configuring Embedded PL/SQL Gateway (EPG)

Posted on April 30, 2013 by Garth

A standard Oracle 11.2.0.3 database installation comes bundled with Application Express (APEX) 3.2.1 by default.  I’m going to upgrade to the latest version of APEX (currently 4.2.2) and then configure the Embedded PL/SQL Gateway (EPG), which uses the Oracle XML DB HTTP components within the database itself, so I don’t need to run a separate HTTP server. First

Read More…

Posted in APEX | Tags: acl, apex, epg, install, pl/sql gateway, upgrade, xml | 27 Comments |

Forms 11g – Java client hangs at security warning with “The application’s digital signature cannot be verified”

Posted on April 30, 2013 by Garth

Having modified our formsweb.cfg file recently to configure WebUtil in our Forms 11g installation, we started hitting issues when trying to access various form-based application URLs. When the security warning window appears (below), usually you would tick the check-box and run the application: In this instance however, the window turned completely unresponsive and just hung, resulting in the Java

Read More…

Posted in Forms & Reports | Tags: forms, formsweb.cfg, java, webutil, webutilarchive | 1 Comment |

Enabling and configuring Database Mail in SQL Server using T-SQL

Posted on April 25, 2013 by Garth

Having had to run through this process again recently, I thought I’d tidy up my notes on all of this, and put together a proper how-to post 🙂 When SQL Server 2005 was released, the added functionality of Database Mail came with it, giving us the ability to use SMTP to send email from SQL Server

Read More…

Posted in SQL Server | Tags: 2000, 2005, 2008, database, mail, notifications, smtp, sql server | 23 Comments |

Useful HP-UX commands

Posted on April 18, 2013 by Garth

An ongoing post detailing some everyday HP-UX commands…which I keep forgetting 😉 Check whether your server is 32-bit or 64-bit: # getconf KERNEL_BITS # print_manifest | grep “OS mode” Display network packets: # nettl -start # nettl -status all Memory details: # dmesg | grep -i physical # /usr/sam/lbin/getmem Swap info: # swapinfo (displayed in

Read More…

Posted in Linux & UNIX | Tags: commands, hardware, hp-ux, kernel, memory, network, swap | Leave a comment |

Applying PSU 12.1.1.0.4 to WebLogic 12c…and patch conflicts!

Posted on April 18, 2013 by Garth

Following on from my recent WebLogic 12.1.1.0 installation on Linux, the first thing I then did was look for the latest PSU (Patch Set Update) to cover off the latest bug fixes and security vulnerabilities, that PSU being… PSU No: 12.1.1.0.4 (April 2013) Patch ID: YJCB Patch No: 16083652 To find the relevant patch number, I did

Read More…

Posted in WebLogic Server | Tags: 12.1.1.0.4, 12c, conflict, psu, weblogic | 1 Comment |

WebLogic Server 12c (12.1.1) installation

Posted on April 18, 2013 by Garth

This is pretty much identical to a WebLogic 11g installation, but I decided to post separately as this includes details of the PSU appropriate to this WebLogic 12.1.1 installation, a potential gotcha with the H675 patch, and I’m using Oracle JDK 7. I’m assuming here that the “oracle” user, groups etc. have already been created here.  If

Read More…

Posted in WebLogic Server | Tags: 12.1.1, installation, java 7, weblogic, wls | Leave a comment |

Archived

Popular Posts

  • Restoring a MongoDB document from the oplog
  • PLS-00801: internal error [hshuid:LU invalid] when compiling a package body
  • OTN Appreciation Day : Oracle Reports Server Job Queue Monitoring
  • Configuring Oracle Reports Server Job Queue Monitoring
  • Data Guard "CORRUPTION DETECTED: In redo blocks starting at block..." issues

External Links

  • SQL Formatter
  • Oracle Live SQL
  • SQL Fiddle
  • ASH Viewer
  • MOS
  • Oracle Forum
  • Oracle Base
  • Oracle FAQ
  • Oracle Articles
  • Rob Zoeteweij’s EM Blog
  • Prev
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • Next
Copyright © 2020 SnapDBA.com