Database Technologies...!

Reasons for ORA-00119 and ORA-00130 during Oracle database startup Oracle startup can be failed on Linux system with below error message. ORA-00119: invalid specification for system parameter LOCAL_LISTENER and ORA-00130 . Common reasons for ORA-00119 and ORA-00130 includes, Incorrectly defined local_listener parameter Issues with server hostname configuration In the given instance no value was set for the LOCAL_LISTENER parameter. And the hostname for the system was correct. But " hostname –i " was failing, with host name lookup failure as below. Check the '/etc/hosts' and '/etc/sysconfig/network' for difference on hostname definition. Set the same hostname in both files and reboot the server.

This is a step by step guide on OpenEdge Replication setup with 2 nodes. Here I ll be setting up replication for Openedge 10.2B databases on RHEL 6.2 on top of Virtualbox. My replication environment will be configured for automatic transition, (DR conversion to primary) and will be using Defer Agent Startup (DR database can be created while production is running - minimum production timeout) method. With OpenEdge DR option comes as a separate installable add-on products for database. It has two variants. 1. OpenEdge Replication. 2. OpenEdge Replication Plus. (Provides the possibility to perform read-only actions on DR DB) Virtualbox Setup Install OS (Mine - RHEL 6.2) and  Progress Openedge database (Mine -OpenEdge Enterprise DB 10.2B) and the Fathom replication product (Mine - OpenEdge Replication plus). After installation check with ‘showcfg’ on proenv prompt, should display both the products. Clone or manually create another duplicate server.  Make s

I am planning to post a set of articles covering various DR options provided by Oracle, DB2 and Progress OpenEdge database. This will include setup guides for Oracle DataGuard, DB2 HADR and OpenEdge Fathom Replication. Series will be started with basic setup of each of these technologies, and then these will be reconfigured, changed as per the requirements to demonstrate different recovery scenarios. First I will setup a simple HADR system using Virtualbox. At the start only basic setup will be configured and will be changed/ reconfigured when testing different DR situations. Virtualbox Setup Install OS and db2 (I am using Oracle linux 5.6 (32) and db2 10.1 (32)) into single VM. Clone or manually create another duplicate server.  Make sure to configure network connectivity between two machines. Use different hosts names. In this example my primary would be "db21" and standby is "db22" DB2 Setup step 1 – Create two db2 instances

DB - Oracle 11gR2 OS - Oracle Linux 5.6 Sometimes it is required to install Oracle without the GUI. Oracle provides silent install capability for this, where installation is totally controlled by a response file. Response files can be generated while performing a GUI installation using OUI by starting the   runInstaller with –record and –destinationFile options as below, ./runInstaller -record -destinationFile <Path_to_Create_Response_File> This will record whatever the options selected on GUI installation and store them in response file in given path. Also you can use sample response file and edit them. I have attached the response file used for this example. The options on the file are self-explanatory so you can edit them to match your environment. Once you have a proper response file silent installation is straight forward task. Also oracle provides some runInstaller options to manage the setup as well. So using the attached response file I

DB - OpenEdge 11.2  OS - Windows  Abbreviations - MT -> Multi-Tenancy/Tenant,  OE -> OpenEdge  Recently we had to go through on MT architecture and had to use OpenEdge for the implementation. From this post I am hoping to discuss the summary of MT architecture and a very simple use case for demonstrating multi-tenancy support in db level using OpenEdge 11.2.  Multy-Tenancy is a resource sharing concept where deferent tenants (Logical set of users – eg. different clients of a cloud service provider) are accessing same service despite having well differentiated data access, security and resource allocations. Multi Tenancy support was there for infrastructure layer (IaaS providers) and also for application layer. Now database vendors provide MT support built in to the database layer as well so the users can access fully shared applications without even knowing it.  Below image demonstrate the shared tenant access where all entities (Infrastructure, Database and Applic

DB - Oracle 11.2.0.3 OS - Windows server 2008 In the process of migrating a database from 10g to 11g on windows, it was required for us to create rman backup schedule  using DBMS_SCHEDULER. In 10g also, we were using DBMS_SCHEDULER so we were hoping to use same job definition in 11g, but with 11g there has been changes in the dbms_scheduler. In 10g we have used a .bat script which will run a rman script inside it to do a full backup of database. So in 10g job defined with job_type “EXCUTABLE” and job_action pointing to the .bat file did the trick. In 11g also we needed to do the same. But mainly two differences were there. 1 – We can not directly provide .bat file for the job_action. 2    If OracleJobScheduler<DBID>  windows service is not started, Then “Credentials” must be used So the solution was the below job definition with use of credentials and also using arguments for providing the location of bat file. begin dbms_scheduler.create_schedule( sched

DB - Oracle 9 OS - AIX Tools - Netbackup We have a 9i database which acts as a BCV and kept in read only mode. As per our client agreements we need to do restoration testing for each of the database in every 3 months time. Below is the process we used when restoring raw device based read only database (With Stand by Control file) using netbackup. Step 1- Restore oracle home to target database and do the needed changes in parameter file accordingly Restore the oracle home to target server (If you have same oracle_home as the source in target already this is not required). Then edit the parameter file accordingly. Follow ( http://dbtechno.blogspot.com/2012/11/restore-rman-full-backup-on-different.html - step3) Then mount the database. SQL>alter database mount standby database Standby since we are using a standby control file. Step 2 – Create required raw devices in target host Here you need to identify the required tablespaces/logs you are going to restore and the

DB2 v9.1 fixpsck 10 - Single Instance on AIX Issue - Can not connect to db2 database directly from server it self. (Remote connection were allowed) Error returned was as below. Any db2 command failes with same error. Since the remote connection are allowed, and only local connections were refused it was obvious that this was not caused by network error/port mismatch etc.. So we were checking for any server changes made and found that the OS admin has changed the "/etc/service" file in the process of SHC gap closing. Cause - While the SHC OS admin has removed the db2 FCM (Fast communications manager) related entries from /etc/services. Which was causing the error. What is FCM - FCM is the mechanism used by DB2 to communicate within database partitions in a DPF environment. Solution - Add the FCM port entries in  "/etc/service". This entries should have port range defined as in the below example. ( cat /etc/services | grep -i db2 ) The difference bet