|
|
|
|
|
|
| Re: Primavera PPM FAQ [message #621692 is a reply to message #621690] |
Sat, 16 August 2014 09:20   |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
3. Always provide the DB name and version.
W.R.T. points 1, 2 and 3; please mention it in topic details.
For example : EPPM P6 8.3 Oracle 11.2.0.4
Edited by Lalit :
This will be considered as single point, to make it easier to understand I am mentioning the first point below :
1. Always post the following information in the topic title :
- Product details - Oracle Primavera products are available in two forms i.e. client and web, relating to PPM and EPPM respectively.
- Product name and version details.
- DB name and version - Oracle Primavera products are available on two DB platforms, Oracle and SQL Server.
For example : EPPM P6 8.3 Oracle 11.2.0.4
[Updated on: Mon, 22 September 2014 07:00] Report message to a moderator |
|
|
|
|
|
| Re: Primavera PPM FAQ [message #621699 is a reply to message #621697] |
Sat, 16 August 2014 10:38 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
LF,
Yes, no doubt, these will be merged into one point. That's why I edited the third point and provided an example to make sure I myself remember to consolidate them as a single point.
Hopefully, this time it won't be that difficult to finalize the points, I have a bit of experience now with previous topic.
|
|
|
|
|
|
|
|
| Re: Primavera PPM FAQ [message #622041 is a reply to message #622040] |
Wed, 20 August 2014 11:00 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
2. I don't see the tables/views/other DB objects in my schema, why?
As what privilege did you login? There are 5 schemas created by default. Please mention the user you logged in as. Usually, users log in as "privuser" and run out of privileges to view DB objects. The administrator privileges are held with "admuser".
[Updated on: Wed, 20 August 2014 11:01] Report message to a moderator |
|
|
|
| Re: Primavera PPM FAQ [message #622045 is a reply to message #622041] |
Wed, 20 August 2014 11:20 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
3. I am unable to use EXP/EXPDP utility to restore my Oracle DB
Please mention the product version and DB version. Older versions of the product, 8.1 and earlier are not compatible with EXPDP utility. If you using 8.1 or prior version of the product, use legacy EXP utility. And be advised, not all schemas would be restored.
Edit : Forgot to add the serial number.
[Updated on: Wed, 20 August 2014 11:27] Report message to a moderator |
|
|
|
| Re: Primavera PPM FAQ [message #622048 is a reply to message #622045] |
Wed, 20 August 2014 11:31 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
4. I successfully exported the dump file, however, I see errors while importing the dump file
This question has two things. Export and import of dump file. For export see FAQ#3. While importing the dump file, look at the error, for example, if it says "privuser not found", you need to remove the respective schema from the EXP/EXPDP command.
|
|
|
|
| Re: Primavera PPM FAQ [message #622052 is a reply to message #622048] |
Wed, 20 August 2014 11:46 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
5. I don't find the extended/new schema for batch jobs
Please mention the product version. If you are on 8.1 or prior version, you can't install it, that's the 5th default schema for versions 8.1 and above.
Edit : Once again I forgot to include the FAQ serial number.
[Updated on: Wed, 20 August 2014 11:48] Report message to a moderator |
|
|
|
| Re: Primavera PPM FAQ [message #622247 is a reply to message #622052] |
Sat, 23 August 2014 10:51 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
6. I don't find ADMUSER schema
Which DB is it? If it is SQL Server, SA user/schema is precreated similar to ADMUSER in Oracle, however, it is explicitly created in Oracle. So use SA as username and the system password.
|
|
|
|
| Re: Primavera PPM FAQ [message #623515 is a reply to message #622247] |
Thu, 11 September 2014 02:10 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
7. Why do I see junk values in my client.
For PPM users, that is probably because your client characterset doesn't match with database characterset. Do the following to check :
select value from v$nls_parameters where parameter = 'NLS_CHARACTERSET'; -- locale-specific characterset
select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET'; -- database characterset
If you see a mismatch between the two, then set the locale-specific characterset to that of database characterset.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
