| Creating PeopleSoft Environment [message #606409] |
Thu, 23 January 2014 07:24  |
 |
chethanm007
Messages: 1
Registered: October 2013
Location: India
|
Junior Member |
|
|
I am trying to create a peoplesoft environment on Windows 7. I have installed Oracle 11.2.0.4, Peopletools 8.49, Tuxedo 9.1, Weblogic 9.2 server and HRMS module. I am trying to populate the data or create peoplesoft database. Due to space constraints i am not able to populate tables. I am trying to move the control files, datafiles and redologs to other network drive and then create a control file.
I backed up the current control file and then started to create the new one in the network location. It doesn't recognize the path when i try to execute the script. It says path invalid.
But when to connect to the path from run->CMD, I am able to locate the path.
Can any one tell me if we can create the control files in the network ? I have already moved all other files to that new drive.
|
|
|
|
|
|
| Re: Creating PeopleSoft Environment [message #606425 is a reply to message #606409] |
Thu, 23 January 2014 11:58  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
You don't need to do all that, it is much simpler:
1/ Move the control files and other ones to target locations
2/
a) If you use an init.ora file then modify the control_files parameter in it.
b) If you use a spfile then start the instance in NOMOUNT mode, then modify the spfile using ALTER SYSTEM command
3/ Start the instance in MOUNT mode (either STARTUP MOUNT or ALTER DATABASE MOUNT depending on previous step)
4/ Use ALTER DATABASE to rename all files to their target location
5/ Open the database using ALTER DATABASE OPEN
Note that, on Windows, Oracle is not designed to work with network drives.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
