The Oracle server on Informatics is not running after maintenance

Verify that Oracle service and tnslistener are running by using tnsping to server (or logging in and seeing "oraclebisr11g (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))" and "/u02/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr LISTENER -inherit" in the process list)
If not, log into server as oracle execute commands
sqlplus / as sysdba
(after seeing 
Database mounted.
Database opened.) 
cd /u02/app/oracle/product/11.2.0/dbhome_1/bin/
./lsnrctl start

Tags oracle Informatics tnslistener
Asked by Alex Lora on Mon 12/11/23 12:04 PM
Sign In to leave feedback or contribute an answer

Answer (1)

This answer has been marked as the accepted answer
Mark Sayers Tue 12/12/23 10:59 AM

Hello Alex,

Forgive me, but I'm not quite sure of the nature of this question post. Is there something related to TeamDynamix that should have been involved in your Oracle server's operations?

Mark Sayers
Sr Support Consultant, CS

No feedback
Hi Mark,
I was looking for a place to enter information that I could remember in the future in regards to troubleshooting this issue. I have been advised to use itatlas for that. You can disregard this as it was only informational.

Alex Lora
- Alex Lora Tue 12/12/23 12:33 PM