Cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to login to DB from TC even if the DB is running

Solution Partner Legend Solution Partner Legend
Solution Partner Legend

I get following error while running TEM or login to TC. DB Connection using NetManager and Sqlplus works fine.

Checked tnsnames.ora from %TC_DATA%, it looks fine.

Any idea what is the reason behind this error ?

 

Unable to log into the database.  Check the password and try
again.[java.lang.Exception: Unable to run list_user

 

2 REPLIES

Re: Unable to login to DB from TC even if the DB is running

Solution Partner Phenom Solution Partner Phenom
Solution Partner Phenom
Are you using Oracle or MS SQL for the DB software (tnsnames.ora indicates Oracle)? Please open a tc command window and run:
install -ayt
If you don't see "Site is already installed" then you know you have a connection problem.

Likely, the user/password specified in tc_profilevars.bat is wrong. You would need to encrypt the password and add it to tc_profilevars.bat. In a Tc command window:
set TC_DB_CONNECT=infodba:<plaintext-password>@DATABASE=TC;SERVER=DBSVR.domain
(use real values for password, DATABASE and SERVER).
install -encrypt
infodba
(with MSSQL the encrypt string must be the full string and not just infodba)
Then edit tc_profilevars.bat with the new string for TC_DB_CONNECT and IMAN_DB_CONNECT.

Another possibility with Oracle is password expiration. If password expiration isn't disabled then you will get a notice within 10 days that your password will expire and needs to be changed. Teamcenter is not able to handle the notice popup and stops working completely. However, you will see this popup notice when logging into sqlplus.
Start command shell
set ORACLE_HOME=<your home>
set ORACLE_SID=Teamcent
sqlplus

Enter user/pass (infodba might work…. or you may need to use the SYSTEM login)
# change the password for user infodba to infodba.
alter user infodba identified by infodba;
# prevent this from happening again in 6 months.
alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited;
alter profile default limit PASSWORD_LIFE_TIME unlimited;
alter profile default limit PASSWORD_GRACE_TIME unlimited;
alter profile default limit PASSWORD_LOCK_TIME unlimited;

Randy Ellsworth, Teamcenter Architect, Applied CAx, LLC
NX 11 | SW 2016 | Creo 4 | TcUA 11.4
Evaluating: AW 3.4

Re: Unable to login to DB from TC even if the DB is running

Solution Partner Legend Solution Partner Legend
Solution Partner Legend

Hello Randy,

I am using Oracle. I will try the install -ayt command.However, password expiry doesn't seem to be  the problem as I can still login with sqlplus.