Oracle11g libnnz11.so: cannot restore segment prot after reloc: Permission denied

[oracle@oracle11g ~]$ lsnrctl status lsnrctl: error while loading shared libraries: /u01/app/oracle/product/11.1.0/db _1/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied
Operating System: Virtual Machine: Oracle Enterprise Linux 5.2 (32-bit)
Oracle RDBMS Version: Oracle 11g - 32 bit for Linux

This is the error due to SE Linux running in Enforce mode. The best way to avoid this is – make the SE Linux in Permissive mode. This can be done at the time of Setting up your server (by not selecting the security feature) (or) once the server setup completes you can set the value to 0.
Refer Metalink Doc Note:454196.1

**********************************************************************************

[oracle@oracle11g ~]$ sqlplus / as sysdba
sqlplus: error while loading shared libraries: /u01/app/oracle/product/11.1.0/db_1/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied
[oracle@oracle11g ~]$

I could able to solve this, by following the above Metalink Document. Hope this helps you.

[oracle@oracle11g ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Aug 22 15:30:06 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to an idle instance.

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

Screening and Interview Questions for DBAs

I stopped by a BLOG “Screening and Interview Questions for DBAs” which shows good point in screening a DBA.

Oracle Database 11g Top New Feature for DBAs

Oracle Database 11g Top New Feature for DBAs : SUMMARY

1) Automatic Diagnostic Repository [ADR]

2) Database Replay

3) Automatic Memory Tuning

4) Case sensitive password

5) Virtual columns and indexes

6) Interval Partition and System Partition

7) The Result Cache

8) ADDM RAC Enhancements

9) SQL Plan Management and SQL Plan Baselines

10) SQL Access Advisor & Partition Advisor

11) SQL Query Repair Advisor

12) SQL Performance Analyzer (SPA) New

13) DBMS_STATS Enhancements

14) The Result Cache

15) Total Recall (Flashback Data Archive)

Note: The above are only top new features, there are other features as well introduced in 11g which will be included subsequently

Configure and mount a new disk in Enterprise Linux

In Previous section we saw how to add storage (Disk) to an existing OS. This section we go ahead with configuring and mounting the file system, in Enterprise Linux.
1) Use putty to connect to the Guest Operating system from your Host operating system. ## You can refer How to connect host and Guest OS in VMWare.
2)
Login as root
login as: root
root@192.168.2.135's password:
Last login: Fri Aug 1 13:12:56 2008 from 192.168.2.130
[root@oracledb2 ~]#
3)
Browse for the newly added disk in Linux using, you can see the newly added disk with /dev/sdb does’t contain a valid partition table.
[root@oracledb2 ~]# fdisk -l
Disk /dev/sda: 21.4 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sda1 * 1 637 5116671 83 Linux
/dev/sda2 638 1718 8683132+ 83 Linux
/dev/sda3 1719 2355 5116702+ 83 Linux
/dev/sda4 2356 2610 2048287+ 5 Extended
/dev/sda5 2356 2610 2048256 82 Linux swap
Disk /dev/sdb: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Disk /dev/sdb doesn't contain a valid partition table
[root@oracledb2 ~]#

4) Create a partition using fdisk /dev/sdb
[root@oracledb2 ~]# fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.
The number of cylinders for this disk is set to 1305.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)
Command (m for help): n ### Select n here
Command action
e extended
p primary partition (1-4) ### Select P for a primary partition
p
Partition number (1-4): 1
First cylinder (1-1305, default 1): 1
Last cylinder or +size or +sizeM or +sizeK (1-1305, default 1305): 1305
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@oracledb2 ~]#

5) You can check the new partition
[root@oracledb2 ~]# fdisk -l
Disk /dev/sda: 21.4 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sda1 * 1 637 5116671 83 Linux
/dev/sda2 638 1718 8683132+ 83 Linux
/dev/sda3 1719 2355 5116702+ 83 Linux
/dev/sda4 2356 2610 2048287+ 5 Extended
/dev/sda5 2356 2610 2048256 82 Linux swap
Disk /dev/sdb: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdb1 1 1305 10482381 83 Linux
[root@oracledb2 ~]#

6) Format the Newly added partition and add a label to it.

7) Mount the new file system

8) Make sure that you add this new mount point to /etc/fstab to auto mount next time when you restart the server.

Your disk is ready, restart the VMWare Guest OS and check if you can see the mount point auto mounted.

VMWare: Adding a disk to VMware Guest OS

Adding a disk to a exisiting VMWare Guest OS.
Technology Used.
1) VM Ware Version: 1.04 build-56528
http://www.vmware.com/
2) Oracle Enterprise Linux 4.2
www.edelivery.com/linux
Purpose: Add a new disk to existing VMWare Enterprise Linux OS and make it in use.
Step by Step
1) Make sure the guest operating system (Enterprise Linux) is shutdown, to add a new disk.
2) Open the VMWare Server Console and select the Guest OS in the Inventory tab.
3) On the Commands tab, click Edit Virtual machine settings.
4) A pop window appears, Virtual Machine Settings, with the existing settings, click Add button at the bottom.

5. Select Hard Disk from the Add Hardware wizard from VMWare Server console & click next to continue further.
6. Select “Create a new Virtual Disk” and click next to continue

7. Select a Disk Type – always go with the recommended configuration by VMWare (here I selected as recommended – SCSI) and click next
8. Specify Disk capacity – in my case, i selected 10GB, and I am not selecting “Allocate all disk space now” as it’s always have a advantage, it will use the host filesystem as the file system grows. Click Next to continue.
9. Specify Disk File, Location on your local hard disk and click Finish, to complete the Wizard.
10. You can see the new add disk, Hard Disk 2. You can start the Operating system, from the VMWare Console to setup the hard disk from the operating system level.
Your new disk is ready at hardware level (Virtual Machine ;-) )

To setup the newly added disk from the Guest Operating System, please follow the below link.

@ Linux -> Adding the disk.

Other Topics - Interview Questions

SYBASE ASE on Linux Enterprise Edition

Few things about Sybase, as I was asked to setup an infrastructure, with SYBASE as backend on Linux, so I choose to try myself before the project begins. I worked on Sybase few months back on a very old version for one of the leading Bank for Europe, but things have changed a lot, and why not I give a try to see the difference between old and the new version of Sybase and few things to share with.
****************************
More Information
****************************
(+) You can download Sybase ASE Express for Linux for free, it as limits like 1 CPU, 5GB Database...etc ->More Information on SYBASE ASE
http://download.sybase.com/presentation/linux_training/QUICKSTART/ASE.html
Sybase ASE Express Online - Training Guide for
Installation, Administration & Programming.
http://download.sybase.com/presentation/linux_training/
For Product Manuals
http://sybooks.sybase.com/nav/base.do
Let me finish the Installation, and soon will update :-)
Ravi Prakash