Category: SQL

Unexpected Database Management System Error – Oracle Tablespace Size

Case:

You cannot open TC or you are not able to create a new item.
There are Error Messages like “Unexpected Database Management System Error“.

 

Possible Solution:

Check the size of the tablespace in the Oracle Database. Maybe they are full (IDATA).
Check this with SQLDeveloper (rightclick in database – Manage Database)

 

Increase tablespace files examples:

alter database tempfile 'D:\plm\oracle\oradata\TCTEST\TEMP01.DBF' resize 2000M;
alter database datafile 'D:\plm\oracle\oradata\TCTEST\SYSAUX01.DBF' resize 512M;
alter database datafile 'D:\plm\oracle\oradata\TCTEST\SYSTEM01.DBF' resize 1000M;
alter database datafile 'D:\plm\oracle\oradata\TCTEST\IDATA01.DBF' resize 2000M;

POM has not started

POM has not started:

Mostly a database connection problem.
In one case it is a false tem_init.bat on Server in TC12 (missing KEYMANAGER var)

CheckList:

  • SQL Service running? -> Start SQL Service or restart whole server
  • Database in Database Management Console “online”? -> try to set online
  • Available free disk space for DB_Data and LOG Files? -> IT has to increase disk space
  • License Server online and available? (CAD License works?) -> Restart License Server and check LogFiles and Firewall
  • “clearlocks -verbose” or “install -ayt” in a TC-command shell works?
    No? Try “list_users” and open the Logfile in %temp%
    Some errors about KEYMANAGER?
    Solution: Go to %TC_Root%\install\tem_init.bat
    and insert TC_USE_KEYMANAGER=false
    (this happen if you copy this file from TC11 to TC12)

 

© 2024 Teamcenter Helpdesk

Theme by Anders NorenUp ↑