asked on

can't install primavera 6 v7 database in windows 2008

hello,
I'm trying to install primavera 6 database on one of our servers running windows 2008.
i installed SQL 2008 express edition and then it turned out that primavera 6 is not supported by SQL 2008 so i downloaded Oracle 10g express edition and installed it.
now when I lunch the Primavera 6 database setup i get an error (attached picture).
Am i missing some thing!!! detailed guide is highly appreciated as this is not really my expert field.
primavera-error.JPG

ASKER CERTIFIED SOLUTION

k_murli_krishna

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

schwertner

Backup LISTENER.ORA file!!!!!!!

In ...\network\admin open listener.ora

see

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Ora10g)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = test)
(ORACLE_HOME = D:\Ora10g)
)
)

Add the entry
(SID_DESC =
(SID_NAME = test)
(ORACLE_HOME = D:\Ora10g)
)
with regard to the particular Oracle Home and SID Name.

In Oracle 11g you have to create from scratch in the listener.ora file the section

SID_LIST_LISTENER =
…..

mentioned above.

Restart the listener:
c:>lsnrctl stop
c:>lsnctl start

ahmetcetin

I suggest to use SQLServer 2005, which is supported by Primavera 6. You can download SQLServer 2005 Express here:
http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx

stalliondz

ASKER

Sqlexpress is not supported by windows 2008 that we are using.

SOLUTION

ahmetcetin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial