This content has been marked as final. Show 2 replies
Is your TNSNAMES.ora file configured correctly? Can you TNSPING the database instance? I believe with the default P6v7 stand-alone installation it defaults to "XE" so from the command line you would run tnsping XE . If you haven't already, try rebooting that PC.
Assuming this is Oracle XE, I believe I may have had to create an environment variable for tns_admin once (but it has been awhile since I worked with XE).
If you can tell me specifically what version of Oracle and P6 I'll let you know if anything else stands out to check.
ORA-12528 really is not related to using a bad password - it's a real issue related to something not being correct with the database.
Here is a thread disucssing this issue which lists some diagnostics to try:
ORA-12528: TNS:listener: all approriate instances are blocking new connecti
The fundamental things to do are:
1) check that tnslsnr.exe is Listening on port 1521 (netstat -abnp TCP)
2) verify that you can tnsping the local database (tnsping localhost )
3) if those work, use sql plus:
sqlplus pubuser/pubuser@localhost:1521If that connects, then you're good to disgnose Primaver setup issues. But until you can pass those tests, the issue is with the Oracle database and its connection, not with P6.