This discussion is archived
2 Replies Latest reply: Dec 14, 2012 2:18 AM by daxmacher RSS

Unable to connect to database... P6 v 7

962011 Newbie
Currently Being Moderated
I'm having problems trying to login to P6 v 7. I'm getting the message unable to connect to the database and do I want to configure the database now. I can't recall how this was initially done. Anyone know how to configure the ORAPMDB database?
  • 1. Re: Unable to connect to database... P6 v 7
    Ruben Reyes - Oracle Explorer
    Currently Being Moderated
    If your installation is standalone and as you mention you are using Oracle database, then follow this steps

    Select the driver Oracle,
    The string connection for Oracle XE is just 'xe'
    For the public username and password use the default 'pubprm$pm' or you can use also 'pubuser' in case that the first fail
    confirm the configuration and test it

    If this username and password fails or throw this kind of error "bad public username or password", I will suggest to create a SR.

    Edited by: 931913 on Sep 27, 2012 8:05 AM
  • 2. Re: Unable to connect to database... P6 v 7
    daxmacher Newbie
    Currently Being Moderated
    Hello,

    there are some possible reasons for your problem:

    1) Please check if your xe is running. Sometimes there is a mismatch with the url. So start a console (cmd) and enter tnsping xe => you should see there the connection setting with maybe an IP. Check if that is correct with your actual IP. You can change this by looking for listener.ora and also the tnsnames.ora and exchange the value there. Restart Oracle Service and Listener under your services.

    2) To check if you can access your xe start a console and enter sqlplus pubuser/<your password>@xe => Is it connecting => ok | if not then you have a wrong pubuser password. You can change it with sqlplus / as sysdba => Enter alter user pubuser identified by <pubuserpassword>; Then enter that password in your new connection.

    I hope this helps
    Daniel

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points