After Oracle Upgrade from 10.2 to 11I can't connect to my mdm repository

[thomas_haase]

Hello,

after my oracle upgrade from 10.2.0.4 to Oracle 11.2.0.2 I can't conntect to the MDM Repositories.

The Database is running.

The tnsping from the MDM-Server to the DatabaseServer is working.

ebdadm> tnsping ebd

TNS Ping Utility for Solaris: Version 11.2.0.2.0 - Production on 18-JUL-2011 13:53:39

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:

/oracle/EBD/102_64/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = q4de8nsyf34)(PORT = 1534))) (CONNECT_DATA = (SERVICE_NAME = EBD)))

OK (0 msec)

Have anyone the same problem?

Greeting Thomas

[thomas_haase]

Hello,

my problem was one security parameter from the oracle 11 database.

The password from the user who is connecting to the database was expired.

I set this oracle parameter in the userprofile to unlimitet than it works.

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

greeting

Thomas

[Former Member]

Hello Thomas

What about mdm user grants? Are it the same as on previous Oracle instance or not?

Usually, we are archiving sap mdm repositories before update and than unarchiving its at the new DBMS instance.

p.s. sometimes somebody forget to set the same charset as on previous database - please check it too

Regards

Kanstantsin Chernichenka

Edited by: Kanstantsin Chernichenka on Jul 18, 2011 6:07 PM