A Simple Approach to Database

Oracle 11gR2 Default Listener - Grid Infrastructure home

noreply@blogger.com (Ravi Prakash) — Sun, 31 Oct 2010 21:00:32 PDT

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.

IBM DB2 Version 9.5 Step by Step Installation on Unix/Linux

noreply@blogger.com (Ravi Prakash) — Sat, 02 Oct 2010 08:26:32 PDT

Oracle 11gR2 on IBM Power - 64Bit

noreply@blogger.com (Ravi Prakash) — Tue, 28 Sep 2010 21:54:56 PDT

New to Oracle Business Intelligence!!!! Start from here

noreply@blogger.com (Ravi Prakash) — Sat, 24 Jul 2010 19:00:12 PDT

1. http://www.oracle.com/technology/products/bi/enterprise-edition.html
2. http://www.oracle.com/appserver/business-intelligence/docs/OracleBIEE-wp.pdf
3. http://bic2g.oracle.com/1/Course_Technical_Prerequisites_Installation.pdf
4. http://bic2g.oracle.com/1/BIC2G_EE_Jump.htm

>>>> http://bic2g.oracle.com/1/BIC2G_EE_v10.1.3.2_Getting_Started.htm

Oracle by example

http://www.oracle.com/technology/obe/obe_bi/bi_ee_1013/index.html

OBI on Windows....
http://www.oracle.com/technology/obe/obe_bi/bi_ee_1013/install/installoraclebee.htm

Oracle Business Intelligence Documentation
http://download.oracle.com/docs/cd/E10415_01/welcome.html

The above URL's from ORACLE will give some in-sight of OBI.

iDBA - iPhone Apps for DBA's

noreply@blogger.com (Ravi Prakash) — Fri, 19 Feb 2010 21:14:57 PST

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

noreply@blogger.com (Ravi Prakash) — Thu, 07 Jan 2010 23:40:26 PST

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?

noreply@blogger.com (Ravi Prakash) — Thu, 07 Jan 2010 17:32:35 PST

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.

Adding Partition Table to Streams

noreply@blogger.com (Krishna Ramavath) — Thu, 24 Sep 2009 20:11:16 PDT

Steps for adding a Partitioned table:

1. Stop the capture process(S)
2. Setup logging & supplemental logging for the table (S)
3. Add capture rules on the table (S)
4. Add propagation rules on the table(S)
5. Set Instantiation of table from Source(S)
6. Export, Import of table(Data) from Source(S) to Target (T)
7. Add apply rules to the table(T)
8. Start the capture process(S)

Refer krish-dba.blogspot.com for more details

ORA-00845: MEMORY_TARGET not supported on this system

noreply@blogger.com (Ravi Prakash) — Tue, 17 Mar 2009 08:45:56 PDT

ORA-00845: MEMORY_TARGET not supported on this system

[oracle@server02 ~]$ export ORACLE_SID=testdb

[oracle@server02 ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Tue Mar 17 05:59:38 2009

Connected to an idle instance.

SQL> startup

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORA-00845: MEMORY_TARGET not supported on this system

*** This Error occurred when I configured MEMORY_TARGET on a Centos 5.2 64BIT Server.

I found one Doc, which states the cause of the error and to solve the Issue.

The main reason for this error is MEMORY_TARGET or MEMORY_MAX_TARGET cannot be greater than the shared memory filesystem (/dev/shm) on the OS.

[root@bisserver02 ~]# df -h

Filesystem Size Used Avail Use% Mounted on

tmpfs 1.9G 0 1.9G 0% /dev/shm

As per the Document I increased the /dev/shm to 7GB.

[root@server02 ~]# mount -t tmpfs shmfs -o size=7g /dev/shm

[root@server02 ~]# df -h

Filesystem Size Used Avail Use% Mounted on

tmpfs 7.0G 0 7.0G 0% /dev/shm

shmfs 7.0G 0 7.0G 0% /dev/shm

[oracle@server02 ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Tue Mar 17 06:14:18 2009

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 2137886720 bytes

Fixed Size 2146112 bytes

Variable Size 1627390144 bytes

Database Buffers 503316480 bytes

Redo Buffers 5033984 bytes

Database mounted.

Database opened.

1) Reference: http://www.cyberciti.biz/tips/what-is-devshm-and-its-practical-usage.html - /dev/shm

2) Metalink - 465048.1

SYBASE ASE 15.0.2 – Case Sensitive to Non-Case Sensitive

noreply@blogger.com (Ravi Prakash) — Mon, 16 Feb 2009 14:20:52 PST

SYBASE ASE 15.0.2 – Case Sensitive to Non-Case Sensitive.

Sybase ASE database by default is case sensitive. But Oracle is not. We are testing one application with SYBASE ASE 15.0.2 developer edition where we will be having a data from Oracle RDBMS which needs to be replicated to ASE. That raw data is non-case and it's in various forms. To avoid more re-work as this is an immediate testing so we planned to test this.

I tried few sites which I could not able to get the resource and after browsing Google my search ended with infocenter.sysbase.com.

1; select @@version

2; go

----------------------------------------------------------------

Adaptive Server Enterprise/15.0.2/EBF 14336/P/x86_64/Enterprise

Linux/ase1502/2486/64-bit/FBO/Thu May 24 08:06:35 2007

I Here is the procedure I used to find the default sort order of the database which is 25, Binary ordering for UTF-16.

1; sp_helpsort

2; go

………………..

Sort Order Description

------------------------------------------------------------------

Character Set = 190, utf8

Unicode 3.1 UTF-8 Character Set

Class 2 Character Set

Sort Order = 25, binary

Binary ordering for UTF-16

(return status = 0)

The are two ways to approach this one is via server console on a Unix system with sqlloc or with sp_configure. I preferred to go with sp_configure as I will always have control of what I am doing. This is a test purpose and I did not bother to dump the database. So FULL DATABASE is must, whenever we do configuration changes, always makes us on safer sideJ.

2; select s1.value2

3; from syscurconfigs s1, sysconfigures s2

4; where s1.config = s2.config

5; and s2.name = 'configuration file'

6; go

value2

----------------------------------------------------

/u02/sybase/RAP/RAPCache/ASE-15_0/RAPCache.cfg

Take a copy of the Configuration file before you proceed further. It helps us to know what we have before system changes.

4; sp_configure "default sortorder id", 52

5; go

You have just reconfigured ASE's default sort order. System table indexes will be rebuilt when you reboot ASE.

Parameter Name Default Memory Used Config Value

Run Value Unit Type

------------------------------ ----------- ----------- ------------

------------ -------------------- ----------

default sortorder id 50 0 52

25 id static

(1 row affected)

Configuration option changed. Since the option is static, Adaptive Server must be rebooted in order for the change to take effect.

Changing the value of 'default sortorder id' does not increase the amount of memory Adaptive Server uses.

(return status = 0)

Shutdown the ASE Server…

1; shutdown

2; go

Server SHUTDOWN by request.

ASE is terminating this process.

Start the ASE Server

Once you bring the ASE server it will check for consistency and it will rebuild all the indexes.

00:00000:00001:2009/02/16 15:41:29.67 server Default Sort Order successfully changed.

00:00000:00001:2009/02/16 15:41:29.67 server *** Be sure to dump all databases after

00:00000:00001:2009/02/16 15:41:29.67 server ASE has booted with the new

00:00000:00001:2009/02/16 15:41:29.67 server *** sort order, since your old dumps will

00:00000:00001:2009/02/16 15:41:29.67 server *** be unusable with the new sort order.

00:00000:00001:2009/02/16 15:41:29.67 server ASE shutdown after verifying System Indexes.

00:00000:00001:2009/02/16 15:41:29.67 kernel ueshutdown: exiting

00:00000:00001:2009/02/16 15:41:29.67 kernel SySAM: Checked in license for 1 ASE_CORE (2009.09220/permanent/1623 DCB3 B018 5E2B).

[1]+ Done startserver -f RUN_RAPCache

Once you see the above message start the server and check the service.

3; sp_helpsort

4; go

Sort Order Description

------------------------------------------------------------------

Character Set = 190, utf8

Unicode 3.1 UTF-8 Character Set

Class 2 Character Set

Sort Order = 52, nocase

General-purpose case-insensitive dictionary ordering

(return status = 0)

Reference: http://manuals.sybase.com/onlinebooks/group-as/asg1250e/svrtsg/@ebt-link;pt=5693?target=%25N%14_5953_START_RESTART_N%25

RAVI PRAKASH ©

Oracle Streams Setup

noreply@blogger.com (Ravi Prakash) — Thu, 12 Feb 2009 08:43:22 PST

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

noreply@blogger.com (Ravi Prakash) — Sun, 01 Feb 2009 07:35:20 PST

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

noreply@blogger.com (Ravi Prakash) — Thu, 15 Jan 2009 19:40:54 PST

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

noreply@blogger.com (Ravi Prakash) — Thu, 15 Jan 2009 19:15:02 PST

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.

Re-Synchronize/Refresh a Table in Oracle Streams

noreply@blogger.com (Krishna Ramavath) — Thu, 22 Jan 2009 21:25:38 PST

The purpose of this article is to outline the steps for Re-Synchronize/Refresh a single table if it is out of sync with source site in one-way replication between two ORACLE databases in Streams environment.

Example:
Schema:SCOTT
Table:EMP

Steps for Refreshing a Table in Streams:

If one of the tables on the Target site is out of Sync with Source site then follow below steps to re-synchronize both:

1. Stop Capture Process on Source(S)
2. Stop Propagation Process on Source(S)
3. Stop Apply Process on Target(T)
4. Delete the apply errors on Target(T)
5. Truncate the problem table on Target(T)
6. Re-instantiate the problem table on Source(S)
7. Synchronize the problem table through exp/imp
8. Start the apply Process on Target(T)
9. Start the propagation Process on the Source(S)
10. Start the Capture Process on the Source(S)

read the full post...

RAC CRS - crs_unregister

noreply@blogger.com (Ravi Prakash) — Wed, 07 Jan 2009 07:30:21 PST

How to remove CRS entries using crs_unregister?

1. Before using crs_unregister, it's always recommended to backup OCR and voting disks. Make sure that you have a documented version to restore, if things go wild.

2. Nodeapps needs to be stopped on all the nodes (In my case I have 2 nodes).

3. You can use crs_unregister to remove the entries which are not required, here in my example I did with listener which I configured wrongly and I want this entry to be removed from CRS.

crs_unregister ora.testrac1p.LISTENER_RACDB_TESTRAC1P.lsnr

crs_unregister ora.testrac2p.LISTENER_RACDB_ TESTRAC1P.lsnr

4. Once you have removed the entries using crs_unregister, use srvctl to reflect the removed entries.

$ srvctl config listener -n testrac1p

$ srvctl config listener -n testrac2p

$ crs_stat -v

5. Once the listener entries are removed, you can use netca (NETCA) to configure the Listeners.

6. Start the Nodeapps on all the nodes

How to become an Oracle DBA?

noreply@blogger.com (Ravi Prakash) — Mon, 05 Jan 2009 12:17:43 PST

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

noreply@blogger.com (Ravi Prakash) — Sat, 03 Jan 2009 22:02:19 PST

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

Oracle Streams 10gR2 Implementaion - Table Level

noreply@blogger.com (Krishna Ramavath) — Sat, 03 Jan 2009 20:38:15 PST

Oracle Streams 10gR2 Step by Step

Purpose:

Oracle Streams enables the sharing of data and events in a data stream, either within a database or from one database to another.

The purpose of this document is to outline the steps for setting up one-way replication between two ORACLE databases using streams at table level.

RDBMS Version: 10gR2 (10.2.0.3) -> download Oracle 10gR2
Operating System: Oracle Enterprise Linux 4.5 -> download from E-delivery

Source database (S): ORCL.ORACLEDB1.KRISH.COM 192.162.2.138
Target database (T): MYDEV.ORACLEDB2.KRISH.COM 192.162.2.139

Source Schema: SCOTT
Target Schema: SCOTT

Replication Tables:
EMP,
DEPT,
SALGRADE,
BONUS

Streams Setup Steps:
Following sequence of steps are required in order to implement streams with no downtime.

1. Set parameters Relevant to Streams (S & T)
2. Set up ARCHIVELOG mode (S & T)
3. Create separate Tablespace for stream admin user (S & T)
4. Setup streams admin user (S & T)
5. Create a database link on source (S)
6. Setup Streams queues on both Source(S) and Target (T)
7. Setup supplemental logging on Source(S)
8. Configure capture process (S)
9. Configure propagation process (S)
10.Create destination tables (Metadata-only export/import) on Target (T)
11.Set Instantiation of tables from Source(S)
12.Export, Import of tables(Data) from Source(S) to Target (T)
13.Grant object privileges to stream admin user (T)
14.Configure apply process on Target(T)
15.Start the apply process (T) and Capture process(S)

.............. Continued ->Click Here

Agent configuration in databases Grid Control

noreply@blogger.com (Naveen Oguri) — Sat, 03 Jan 2009 17:48:10 PST

Delete the targets from OMS including the old agent registration;
Log into Grid
-> Targets
-> All Targets
-> Search for targets of type Agent
-> Select radio button of one of the Agents of status
-> Remove
You will get an error screen that it is monitoring targets and cannot be removed.
-> Follow the "Click here for the list of targets running on the host".
-> Select All
-> Remove

The non-clustered targets will be removed after you click OK. The clustered targets have to be removed one at a time.

-> Select one of the remaining clustered targets (if any on that host).
-> Remove

You get a warning about the agent cannot be contacted.

Check the "Ignore the status of the agent(s)" check box.

Press YES. Repeat as necessary.

Only the two competing agents should still be listed on the node.

Select the one with status and Remove.
This may give you an error that it's still monitoring targets.
Press OK
Repeat steps h - p as necessary until it finally removes all databases/listeners/asm.

When nothing but the two agents appears on the list but the agent still won't delete, follow the link to the old agent and remove the host from the list of monitored targets on the agent status page.

Repeat steps b - f and the agent should finally go away.

Finish removing all targets before proceeding to rediscovery.
Rediscover targets on the nodes via the new agent.
Log into Grid
-> Targets
-> Databases
-> Add
Click the flashlight
Select the host you just cleaned out in step 1.
-> Select
-> Continue
If prompted whether to discover targets only on this node or on all hosts in the cluster, select all hosts in the cluster and continue.

Wait for discovery to complete (this can take a while especially if the node is clustered).
The list of discovered targets will be displayed. Any targets with a pink wrench will need you to specify the connection password. If you don't know or can't find the current value, just reset the password and then enter the new password in the configuration screen.

Even after discovery completes, you may still need to find and configure the dbsnmp passwords for some of the databases.

Hits on Google Search Enginee before Migration

noreply@blogger.com (Ravi Prakash) — Sun, 04 Jan 2009 05:18:46 PST

How we used to be before Blog Migration

noreply@blogger.com (Ravi Prakash) — Sun, 04 Jan 2009 05:16:43 PST

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

noreply@blogger.com (Ravi Prakash) — Thu, 01 Jan 2009 18:21:22 PST

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

VMWare: Network Adapters

noreply@blogger.com (Ravi Prakash) — Tue, 13 Jan 2009 13:33:46 PST

Reference to the OTN discussion
1. Virtual Network Editor.
2. Summary Page - Listed available Virtual network

3. VMWare Server - Virtual Node Information, List of Devices on RAC 2

4. VMWare Server - Virtual Node Information, List of Devices on RAC 1

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

noreply@blogger.com (Ravi Prakash) — Wed, 04 Feb 2009 15:05:33 PST

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 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.