Oracle 11gR2 Default Listener - Grid Infrastructure home

Oracle Restart enabled database creation requires Default Listener configured
and running in Grid Infrastructure home. Use NETCA in Grid Infrastructure home - "/u01/app/oracle/product/11.2.0/grid" to configure a listener before proceeding.






I faced this issue when setting up Oracle 11gR2 Standalone with Oracle Grid Control 11gR2 for ASM and restart capabilities, and when selecting Oracle Enterprise Manager I got the above error screen but I have a listener running on Oracle Grid home, but still you see the same error.

This is due to the Listener which should be by default, like the name should be LISTENER and the port should be 1521. Any changes with both will result in the above error.

I dropped the existing listener and re-created a new one with NETCA with the default port and the name which worked.

Oracle 11gR2 on IBM Power - 64Bit

iDBA - iPhone Apps for DBA's

iDBA an app for Oracle database administrators available in app store .

Features :
All important Oracle Database administration areas covered conceptually and concisely.
Good For quick reference, Very helpful specially when preparing for surprise quiz,test,interview .
Important RAC management commands .
Quick SQL reference for DBAs.
Important Unix commands for DBAs .
Regular upcoming releases to improve and add new features,Topics

Please click here to download

App developer Blog -> Vivek Gupta

Apple iPhone Application for Oracle DBA’s -> Init.ora

Apple iPhone Application for Oracle DBA’s
Init.ora

It’s good news to iPhone users, who want to have a quick look at the parameters, handy. Last weekend I downloaded init.ora application from Apple Apps Store and it’s free of cost. It covered almost all the parameters from 7 to 11g and gives a brief description of what the parameter does. It as a search option as well, for a quick search.

It’s handy and easy to browse, application is free.

Filesize is around 0.5MB

Microsoft Windows 7 Upgrade for S$20?

Yes, you have an option to upgrade your Windows Vista if you Purchased your laptop on or after June 26^th 2009, your laptop is eligible for upgrade. I purchased my laptop ACER ASPIRE 4937G on June 28^th 2009 but shipped with Windows Vista Home Premium and was quite disappointed with a way its working and very keen to look for an upgrade which my search ended getting a Windows 7 Home Premium upgrade for Just $$20 dollars.

You can check the upgrade options at Microsoft http://www.microsoft.com/windows/windows-7/

Or visit your Laptop Manufacturer site like the one i tried here at ACER http://www.acer.com/windows7upgrade/ and for eligible models you can look below URL, http://www.acer.com/windows7upgrade/eligible.html

So get your copy now and give a try, its worth.

Oracle Streams Setup

Would like to share some good documents online from Oracle on Streams, which are very useful in setting up Oracle Streams.
1. Oracle Streams Deployment on Release 9iR2.
2. Streams Sample and Best Practices - Oracle.com
3. Customer Case Studies from Oracle

DBA Resolutions for 2009 :: Tom Kyte's

Tom Kyte's DBA Resolutions for 2009
Is it not good to practice the resolutions of Tom on his blog? We often never get a chance to recover the database, which needs practice all the time. Well it gives a good insight about how to keep up with the skills.

Don’t miss reading this, which got good information.
Tom Kyte's DBA Resolutions for 2009
Thought of sharing this, may be you have missed.

Oracle Critical Patch Update - January 2009

Oracle Critical Patch Update - January 2009
CPU Patch released for January 2009. For details,
http://www.oracle.com/technology/deploy/security/alerts.htm?msgid=7301948

Oracle 11g: oracle.sysman.emcp.exception.EMConfigException: Error starting Database Control

SEVERE: Error starting Database Control

Refer to the log file at D:\Oracle11g\app\Acer-5670\cfgtoollogs\dbca\db11g\emConfig.log for more details.

Jan 15, 2009 7:44:08 PM oracle.sysman.emcp.EMConfig perform

CONFIG: Stack Trace:

I was asked to check with this error which was generated at the time of Database creation on Windows XP SP2 failed at 86% showing the below error.

Jan 15, 2009 7:44:08 PM oracle.sysman.emcp.EMConfig perform

SEVERE: Error starting Database Control

Refer to the log file at D:\Oracle11g\app\Acer-5670\cfgtoollogs\dbca\db11g\emConfig.log for more details.

Jan 15, 2009 7:44:08 PM oracle.sysman.emcp.EMConfig perform

CONFIG: Stack Trace:

oracle.sysman.emcp.exception.EMConfigException: Error starting Database Control

at oracle.sysman.emcp.EMDBPostConfig.performConfiguration(EMDBPostConfig.java:869)

at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:250)

at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:213)

at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:235)

at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:460)

at java.lang.Thread.run(Thread.java:595)

Jan 15, 2009 7:44:08 PM oracle.sysman.emcp.EMConfig restoreOuiLoc

CONFIG: Restoring oracle.installer.oui_loc to D:\Oracle11g\app\Acer-5670\product\11.1.0\db_1\oui

1. I created a loop back adapter and disabled all the remaining Network connections which did not work.

To create a Loop Back Adapter in Windows XP ->

http://dba-onweb.blogspot.com/2008/01/microsoft-loopback-adapter.html

2. Second Approach – Installed JAVA (http://www.java.com/) and rebooted the laptop to start the DBCA once again to do a fresh setup which in turn worked.

How to become an Oracle DBA?

How to become an Oracle DBA?

Lesson 01

This is where I started 7 years back, and sharing my thoughts from few years. 7 years back, database administrator is very less known and when I started working out to be a Database Administrator, I opted to take a course from Oracle University affiliated SQL * International, of course its costly I felt its better and it worked for me. At that time, I used to browse for online documents, used to find very less. These days we have more documents on line, Oracle Forums for new aspirants, so many websites offer lot.

As a starter you have plenty of options, if you are a self starter you can browse Oracle Documentation on line and you can start learning.
http://www.oracle.com/pls/db102/homepage

In this post and upcoming posts I will discuss the topics to concentrate.
1. Get familiar with the Oracle Database Users and their responsibilities, it will help you to understand the roles and responsibilities and of course that you want to concentrate to become a Database administrator.

You can find more information on http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/dba.htm#sthref57

It will give you a basic understanding of database administrator. It’s the stepping stone. I don’t want to talk much about SQL, PL/SQL. Assuming that you already aware of this. Basics is well to go with, you don’t need to be a mater in PL/SQL.

2. What type of activities does Database administrator do?
Database Administrators as so many responsibilities which he/she needs to deliver. So get to know what the tasks of a DBA.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/dba.htm#i1006205
Going with the above, you might get to know what a DBA can do and you might be prepared to get ready to learn Oracle Database.

3. How to go-ahead after this?
Download Oracle Database 10gR2 for your operating system; initially you can use your Windows XP Professional where you can install Oracle Database Software easily. If you have good exposure on Linux, well I suggest you to try working out.

On Windows

http://www.oracle.com/technology/obe/10gr2_db_single/install/wininst/wininst_otn.htm

On Linux
http://www.oracle.com/technology/pub/articles/smiley_10gdb_install.html
This gives you a good start, and of course hands on experience which is must for a DBA. So keep working I will come up with my next post on what to do once you have Oracle Database on your Laptop/Desktop/Workstation.

We moved successfully

We just moved to this blog DBA-ONWeb from ravidba-oracle.blogspot.com which used to be my blog for almost 4 years. We will keep this blog posted with all the resource and the issues we have faced and of course the way we try to resolve the issues.

Wishing you all, a good year a head…
Ravi Prakash

Hits on Google Search Enginee before Migration

How we used to be before Blog Migration

1Z-050 Oracle 11g New Features for Administrators: Certified

Well, one more certification added to my list “Oracle 11g New Features for Administrators 1Z-050”.
Most of the time the test is concentrated on new enhancements like
Virtual Private Database
ASM Enhancements
AWR Baselines, SQL Advisior, STS
DIAGNOSTIC_DEST
Direct NFS
Flashback archive
SQL Management Base
MEMORY_TARGET
(+) and a use full resource http://www.amazon.com/OCP-Oracle-Database-11g-Administrators/dp/0071496823 OCP Oracle Database 11g: New Features for Administrators Exam Guide (Exam 1Z0-050) (Osborne Oracle Press) which helps you to build your knowledge on Oracle 11g as well as in getting the Certification.

Good Luck
Ravi Prakash

libawt.so: libXp.so.6: cannot open shared object file

libawt.so: libXp.so.6: cannot open shared object file

Operating System: RH Linux 5.3 64bit.

Issue: When running Sybase Central

$./scjview

Current thread: main

java.lang.UnsatisfiedLinkError: /u03/sybaseiq/shared/jre-1_42/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory

at java.lang.ClassLoader$NativeLibrary.load(Native Method)

at java.lang.ClassLoader.loadLibrary0(Unknown Source)

at java.lang.ClassLoader.loadLibrary(Unknown Source)

at java.lang.Runtime.loadLibrary0(Unknown Source)

at java.lang.System.loadLibrary(Unknown Source)

at sun.security.action.LoadLibraryAction.run(Unknown Source)

at java.security.AccessController.doPrivileged(Native Method)

at java.awt.Toolkit.loadLibraries(Unknown Source)

at java.awt.Toolkit.<clinit>(Unknown Source)

at java.awt.Color.<clinit>(Unknown Source)

at javax.swing.plaf.metal.MetalTheme.<clinit>(Unknown Source)

at javax.swing.plaf.metal.MetalLookAndFeel.getCurrentTheme(Unknown Source)

at javax.swing.plaf.metal.MetalLookAndFeel.createDefaultTheme(Unknown Source)

at javax.swing.plaf.metal.MetalLookAndFeel.getDefaults(Unknown Source)

at javax.swing.UIManager.setLookAndFeel(Unknown Source)

at javax.swing.UIManager.setLookAndFeel(Unknown Source)

at com.sybase.util.UIUtils.installLookAndFeel(UIUtils.java)

at com.sybase.central.viewer.SybaseCentral.main(SybaseCentral.java:383)

What i observed is libXp package is missing,

[root@testserver01 sybcentral43]# yum install libXp

Which helps you to solve the issue, Please let me know if you face any issues like this or this helped you to solve the issue you are facing.

Cygwin X Window: _X11TransSocketINETConnect() can't get address for localhost:6010: Temporary failure in name resolution

Any Idea with the below error: xterm issue using Cygwin: Connecting from a Windows XP Work Station to a OLE 4.7 on VMWare 1.0.6.

Administrator@TESTDB-02 ~
$
Administrator@TESTDB-02 ~
$ ssh -Y oracle@192.168.2.172
oracle@192.168.2.172's password:
Warning: No xauth data; using fake authentication data for X11 forwarding.
Last login: Mon Dec 8 16:09:50 2008 from TESTDB-02.bis.local
ora11gprod-> xclock
_X11TransSocketINETConnect() can't get address for localhost:6010: Temporary failure in name resolution
Error: Can't open display: localhost:10.0
*** Tried again ****
Administrator@TESTDB-02 ~
$ ssh -Y oracle@192.168.2.172
oracle@192.168.2.172's password:
Warning: No xauth data; using fake authentication data for X11 forwarding.
Last login: Mon Dec 8 16:13:33 2008 from TESTDB-02.bis.local
ora11gprod-> xclock
_X11TransSocketINETConnect() can't get address for localhost:6010: Temporary failure in name resolution
Error: Can't open display: localhost:10.0
I think this is something to do with localhost:10.0 but i am not sure from where its taking...
Any help on this...




It's worked. Guess what?
I missed localhost entry in /etc/hosts.
Added this line to resolve the issue.

VMware Server 2.0 (Beta)

My Hands on VMware Server 2.0(beta)
For almost 16 months I am using VMware server versions from 1.0.2 and there so and my first Hands on Oracle Real Application Clusters (Learning Purpose) is on 1.0.4 went well without any issues. In fact the concept of Virtualization is one of the deemed reason to consolidate the space of Data Centers. My last project with the bank, almost all the utility servers run on Virtualization. It’s got so many advantages, but which is not going to be the topic, now, but if you talk about my personal interests to try this product, it’s always a useful tool for me.
It’s easy to use, like, you can divide your existing system into multiple virtual machines, you can host all the freeware Linux and its compatible with almost all flavors of Linux (Of course I am more used to Enterprise Linux from Oracle).

I thought of giving a try with Enterprise Linux 5.2 from Oracle, but the VMware 1.0.6 / 1.0.4 as still don’t have VMware Tools are not there for Linux 5.2 so I used face few difficulties with the Console and of course with the Display.

I am happy to see the VMware Server 2.0 which got support of almost all the Operating systems, from Microsoft Win 3.1 to Windows 2008 (64 bit) & for Linux 5 versions.

The things i like more in VMware Server 2.0 (beta).

1) Guest Operating System's - Support to all Windows operating system from 3.1 to Windows 2008 Server, and even for Windows Vista.

2) Same for Linux. (Enterprise Linux from Oracle Corp. 5.0)
3) The Web Interface - With the Host Configuration Details.
4) The status of Guest OS and the Hardware Version etc.,
5) The Pop-up window of guest OS.

So whats waiting for, just give a try. I have Enterprise Linux 5.2 from Oracle running on this, which i want to give a try with Oracle 11g.
Ravi Prakash

Oracle Block Size :: Larger vs. Small data block – OTN Forum

Oracle Block Size :: Larger vs. Small data block – OTN Forum
Very informative thread which gives you an idea about different opinions from senior oracle guru’s about choosing an appropriate block size.
Well, for setting up Database block size, I always go with Vendor Application team with the proposals, as they are the best to decide which one to use with their application.
My recent setups, I stick to 8K in size, and it’s the default from Oracle as well. I need to concentrate more on this, from now.

Oracle Forum - that i always like to see updates

1. URGENT URGENT PLZ READ B4 OTHERS VERY URGENT NO TIME WASTERS
Replies: 508 - Pages: 34 [ 1 2 3 4 5 Next ] - Last Post: Feb 18, 2008 1:23 PM by: RACER

2. Larger vs. Small data block
Replies: 451 - Pages: 31 [ 1 2 3 4 5 Next ] - Last Post: Jul 13, 2008 10:44 PM by: Niall Litchfield

Critical Patch Update - July 2008

CPU Patch for July released