I'm trying to set up a new installation of PeopleSoft based on a copy of my client's PS_HOME folder. I've installed PeopleSoft before, but I used the newest versions and started from scratch. Now I am using PS HRMS 8.9 and PT 8.48 on a Windows 2003 server. I have been following the manual to install PT 8.48 (installing third party tools, using the configuration manager), except for using the wizard to actually install PT, as the files are already there. I've changed all the config files I've come across to include the correct locations for PS_HOME, Oracle database drivers, etc.
Now I am trying to use the Database Configuration Wizard to automate the database creation using Oracle 10.1.0.5.0. After selecting a non-unicode database I click next, select the character set, then when I click next again I get the message "Unable to find dbcodes file."
I've checked in the folder PS_HOME/setup and there are two dbcodes files: dbcodes.pt and dbcodes.hc. Is this causing some kind of confusion, or is the wizard missing the dbcodes file in another location? Or maybe it's another issue entirely, I'm not sure.
Thanks for the help.
The setup folder is correct, this should contain the dbcodes files for PeopleTools and Application
Could you verify if the PS_HOME/data dir actually contains the dbfiles eg.
I am always in favor of creating the database manually, instead of using the wizard.
That way you have full control and insight of the steps to be taken.
PS_HOME/data doesn't contain any of those files. Should I then look into creating the database manually? I read through the manual's instructions but haven't attempted it yet. This installation will only be used for development/testing, not production, so I'm not overly concerned with performance or anything like that. However if the manual route is the best or only option, I will go with that.
PS_HOME/data doesn't contain any of those files. Should I then look into creating the database manually?...
Manually or through the Wizard does not matter, that won't make the files appearing. You most likely should ask how the "client" has been installed and which choices have been checked at the installation runtime. I assume you've installed Peopletools, but have you also installed the Application ? In the same folder (at this time, there was no PS_APP_HOME) ?
Since you copied a "client" PS_HOME, these files are missing. They are not required for clients but for creating en seeding the PeopleSoft database.
Like Nicolas says, during installation of PeopleTools and the Application you have the option which components to install.
During installation the component Database Server must have been selected to seed these files in $PS_HOME/data.
You could reinstall PeopleTools and the Application or copy these files from a database server installation.
The application has been installed too and is housed in a separate folder. I just looked in PS_APP_HOME/data for the files mentioned and hcengb.db, hcengl.db, and hcengs.db are there, but not ptengs.db, which makes sense to me.
That's wrong. In PTools 8.48 both PTools and Application must be installed in the same folder, otherwise you won't see the application during DBSetup.
Did I not say earlier there was no PS_APP_HOME variable at that time ?
Your wording was unclear; it seemed like you were asking if there was a PS_APP_HOME, which there is. Obviously this is incorrect then. The PS_HOME I am using is a copy of a functioning version that I am trying to get working on another server, so it sounds like the application must have been installed in this folder already? Either way, the files mentioned by Hakan are not in the folder. Is there a way to configure or create the database using my current setup? I don't have any of the PeopleTools installation files.
Sorry if it was not clear. No in PTools 8.48 there's no Application home, the Application is hosted in PS_HOME.
A working PTools does not necessarily means you have an Application installed in PS_HOME.
But now, I don't understand your sentence "I just looked in PS_APP_HOME/data for the files mentioned and hcengb.db, hcengl.db, and hcengs.db are there, but not ptengs.db, which makes sense to me."... what are you talking about then ?
To start off with PS_APP_HOME got introduced in PeopleTools 8.52.
Since you are running on PeopleTools 8.48 the application is installed in PS_HOME.
ptengs.db is used to create a PeopleTools only database, you are trying to create a HCM database. This file will not be used when creating your database.
If you want to create your HCM database copy alle files from "PS_APP_HOME" to PS_HOME and start datamover with database creation option.
Should do the trick.