libclntsh error

I had an error with data mover:

[pshr@localhost ~]$ psdmtx -CT ORACLE -CD HRDMO -CO SYSADM -CP SYSADM -CI PEOPLE -CW PEOP1E -FP ~/test.dms
PeopleTools 8.49 - Data Mover
Copyright (c) 2008 PeopleSoft, Inc.
All Rights Reserved

dlopen in libpscompat failed for ‘libpsora.so’: libclntsh.so.9.0: cannot open shared object file: No such file or directory
PSDMTX Error: signon
Reason: Could not sign on to database HRDMO with user SYSADM.

The fix was to create a symbolic link:

[pshr@localhost ~]$ cd /home/pshr/app/pshr/product/11.1.0/db_1/lib
[pshr@localhost lib]$ ln -s libclntsh.so libclntsh.so.9.0

Resources

Unable to boot the apserver… Need to install 32 bit library for window to fix the Missing or invalid version of SQL library libpsora

Yum with Oracle DVD

I found a great link showing how to use the Oracle Linux DVD as a repository for yum.  Although the post mentions using the DVD, you could probably setup 6 repositories with the 6 CDs to make it would for the CDs too.

Having Yum is very powerful because it figures out the prerequisites for installing software.  That is one thing I definitely miss as I am working with Unbreakable Linux.  I think next time I might try Ubuntu or Fedora just for experimenting around because the repositories are already setup and software installation is easier.

Customer Connection

Customer Connection is set to migrate to MetaLink3 not this weekend but the next.  Currently, you should be logging into the new MetaLink3 and making sure that you have access.  That way you are ready for the change.

Change is always exciting, and I am hoping that this new site provides users an easier-to-use interface.  I always had trouble searching through the old Customer Connection.  Currently, it is hard to tell because none of the customer connection information exists in the new system.

I haven’t read all of the documentation yet, and so, I probably shouldn’t be commenting yet, but I first thought that Oracle was combining MetaLink and Customer Connection.  But, why do we have two separate systems?  From what I can tell, I will have to access MetaLink for my Oracle patches and MetaLink3 for PeopleSoft patches.

Another thing I found funny was that the Customer Connection Login page does not have a note or warning about the change.  Since the change is only a couple of weeks away, I would have thought I would see something reminding me.

I did find a thread going for comments on the changes.  Please share your comments.

Resources

SQL Server Take Offline

We had an issue with taking a SQL database offline, and we found that the SQL allowed more control for rolling back in-progress transactions.  Here is the article that listed the SQL.

I think our problem had something to do with the SQL Agent.  We ended up having to kill the process that was accessing the database, and I am pretty sure it was a SQL Agent process.  Then, the database went offline, and we able to restore it.

Resources

SQL for taking databases offline

PeopleTools 8.50 Preview

Peter Slager posted a new article about “What’s new in PeopleTools 8.50”.  From the screenshots he posted, it looks very exciting.  I am anxious to get in and try it out!

I read several posts about it coming out in late 2009.  That is a long time to wait!

Resources