Archive

Archive for the ‘Oracle Database’ Category

Configuration settings are unavailable because /Farm_IDMDomain/asinst_1/oid2 is down


Problem:

If you see an error in the Enterprise Manager console as shown below, follow the solution that might solve the issue.

Information: Configuration settings are unavailable because /Farm_<domain>/<asinst>/oid1 is down.

Solution:

  • Restart with opmnctl stopall and opmnctl startall
  • Restart weblogic admin
  • Start weblogic managed server wls_ods1
  • Start weblogic managed server wls_oif1
  • opmnctl stopproc ias-component=EMAGENT
  • opmnctl startproc ias-component=EMAGENT
  • Now try in /em console this time you should see the details

Oracle Spatial Database Installation11g R2 quick step-by-step

December 26, 2012 Leave a comment

This post lists down the steps to Configure Oracle spatial Database 11gR2 on your machine. This post is definitely not intended for Advanced installation and configuration, it’s just for those users who are looking at an easy approach to installing & configuring Oracle database on their machine.

Pre-installation Requirements:
  • You should have at least 1 GB RAM (In current world this isn’t ideal as the Windows OS itself required about 512 MB RAM, I would suggest have a minimum of 2 GB RAM)
  • If your machine is on DHCP then you need to have Loop back adapter installed.
  •  Loop back adapter is required even in case you are currently working in non-network mode but later plan to connect to your network after Oracle installation.
  • Steps to install loop back adapter http://docs.oracle.com/cd/B19306_01/install.102/b14316/reqs.htm#BABGCEAI
  • Please check the compatibility metrics it’s an excel sheet you can find in the Oracle database download site, just to ensure software you are downloading is compatible to your system configuration
Installation:
  • Download Oracle software appropriate version
  • Run the installer
  • Click Next0
  • Select Install only option0.10.2
  • Click Next, Next, Next, Next till you finish installation successfully
  • Now go to start –> Oracle Db Home –> Configuration & Migration tools –> Database Configuration Assistant (DBCA)
  • This should open your DBCA wizard. Now just follow the screens below…1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
  • That’s it! You’ve Oracle Database 11gR2 installed now
  • Open command prompt and just type in sqlplus. If you can see the below screen then you now have Oracle db installed & configured on your machine.20
  • Happy learning…

ODBC Connection Issues – Architecture Mismatch Issue


Issue “[MICROSOFT] [ODBC Driver Manager] The specified DSN contains an architecture mismatch between driver & applications”

This is a typical issue you find in Windows 64 bit OS that tries to use 32 bit Oracle drivers while configuring ODBC connection.

There are 4 ways to solve this issue:

Scenario 1:

  • On Windows 64 bit OS
  • If Oracle Database Server with 64 bit already installed
  • If ArcGIS Server 32 bit is already installed
  • Install Oracle Client 32 bit 
  • Go to C:\windows\SysWOW and search for odbcad.exe
  • Run odbcad.exe to add ODBC connection (just google for creating ODBC connection)
  • Go to ArcCatalog, create an OLEDB connection. From the drop down chose ODBC connection name you created in above step.

Scenario 2:

  • On Windows 64 bit OS
  • If Oracle Database Server with 64 bit already installed
  • If ArcGIS Server 64 bit is already installed
  • Go to c:\windows\system32 and search for odbcad.exe
  • Run odbcad.exe to add ODBC connection (just google for creating ODBC connection)
  • Go to ArcCatalog, create an OLEDB connection. From the drop down chose ODBC connection name you created in above step.

Scenario 3:

  • On Windows 64 bit OS
  • If Oracle Database Server with 32 bit already installed
  • If ArcGIS Server 32 bit is already installed
  • Go to c:\windows\SysWOW and search for odbcad.exe
  • Run odbcad.exe to add ODBC connection (just google for creating ODBC connection)
  • Go to ArcCatalog, create an OLEDB connection. From the drop down chose ODBC connection name you created in above step.

Scenario 4:

  • On Windows 32 bit OS
  • Install 32 bit Oracle client to connect to remote database server
  • Go to c:\windows\SysWOW and search for odbcad.exe
  • Run odbcad.exe to add ODBC connection (just google for creating ODBC connection)
  • Go to ArcCatalog, create an OLEDB connection. From the drop down chose ODBC connection name you created in above step.