Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Oracle Password

4 replies [Last post]
mani M.R
User offline. Last seen 8 years 35 weeks ago. Offline
Joined: 4 Aug 2009
Posts: 21

Hai All
I working in StandAlone Version (P6.7 - Oracle Database)
In P6 v7 I getting Error Message
Unable to connect to the database. Would you like to configure the database connection now?"
Connect String - XE
Database - ORAPMDB
Username - ADMPRM$PM
Password -     (That we Typed during Installation)
I forgot that Password
Is there Any Way to Retrieve The Password
Is there any any other way to Resolve the Problem
Regards
Mani.

Replies

ethan adam
User offline. Last seen 5 years 28 weeks ago. Offline
Joined: 12 Sep 2018
Posts: 2
Groups: None

1Z0-950 is one of the most coveted certification exams of IT world. Now pass your 1Z0-950 exam in just a first trial with the help of Braindumps4IT exam dumps. We offer the first class Oracle Cloud 1Z0-950 braindumps in the form of PDF files along with 1Z0-950 Exam Engine. All 1Z0-950 Exam Questions are latest and verified by professional experts to guarantee your success.

Ozgur Goral
User offline. Last seen 8 years 45 weeks ago. Offline
Joined: 24 May 2012
Posts: 4
Groups: None

Hi all,

I just installed the primavera on a virtual machine and got no error during the installation. But now dealing with configuration stuff.

Could  anyone please tell me how to configure the database. Didn't primavera already install and configure the database during the installation? I found  many Username and Password combinations and the ones listed above but any of them didn't work. The error is: "invalid username/password; logon denied).

why is this so hard, please someone who has the chance to communicate with  primavera authorities, he/she let them know that this configuration story sucks.

 

Thanks in advance.

mani M.R
User offline. Last seen 8 years 35 weeks ago. Offline
Joined: 4 Aug 2009
Posts: 21

 Sir

Thanks For Your Reply

1.SQL> alter user ADMPRM$PM identified by <R123456>;  it didnt work

When i typed SQL> alter user ADMPRM$PM identified by "R123456";  it Works

Thanks a lot

Regards

Mani

Ronald Winter
User offline. Last seen 3 years 2 weeks ago. Offline
Joined: 4 Jan 2003
Posts: 928
Groups: None

Mani,

 

You cannot retrieve the Oracle Database password but you cna reset it.  After that, you will need to deal with the fact that P6 now has the wrong password, but that is another procedure.  Good luck!

------------------------------

To change the password for database users, ADMPRM$PM, PRIVPRM$PM, PUBPRM$PM do the following:

Login to SQLPlus by first running the command prompt (Windows Start Button/Run, “cmd” or Windows Start Button/All Programs/Accessories/Command Prompt)  Then at the C:> prompt,

c:\>sqlplus / as sysdba

The prompt will turn into an SQL> prompt, i.e. “SQL>”.  Type the following:

SQL> alter user ADMPRM$PM identified by <new_pass>;

Where <new_pass> is the new password you specify for the user.  Don’t forget to enter the “;” at the end, or you will be prompted for the 2ndhalf of your entry “;” with a “?” prompt.  (In that case, just enter the ";".)

You can repeat the alter user command for each user password that you would like to change. 

To exit SQLPlus, type

SQL>exit 

 and Return.  To exit the windows command prompt, also type,

C:\>exit

and Return.