Category: Server Administration

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

Step By Step Virtual PS Install: Install Wine

This is a continuation of my virtual PeopleSoft installation.  In this step, we will install Wine, a windows emulator that allows Linux users to run Windows-only programs.  To see the complete list of posts, click here.

I apologize about the images.  I tried to back them up, and I just found out that they did not backup properly.  I have tried to take some after the fact.

Read More

Step By Step Virtual PS Install: Configure OS

This is a continuation of my virtual PeopleSoft installation.  In this step, we will install the operating system in to the virtual machine.  To see the complete list of steps, click here.

Here are a few things that you will want to do to your new installation to prepare for installing the database and other components.

Read More

Tablespace Error

Today, we had trouble with a SQL Server installation of PeopleSoft asking for a tablspace.  We created a new record, and when we saved it, it asked for a tablespace name.  The problem was that we had no tablespaces setup in PeopleSoft.  Therefore, we couldn’t pick a tablespace and essentially couldn’t save a new record.

What was more frustrating was the fact the SQL Server does not have tablespaces.  On a SQL Server system the tablespace settings are completely ignored.  It should not show the tablespace dialog.

The solution was to turn off platform compatibility mode.  The compatibility mode allows you to create records that could be migrated to a database such as Oracle.  With this option turned on, it will ask you for the tablespace so that it will have it when it gets on the Oracle database.  You can turn it on or off in the PeopleTools Options page (PeopleTools > Utilities > Administration > PeopleTools Options).