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
startup
(after seeing
...
Database mounted.
Database opened.)
quit
cd /u02/app/oracle/product/11.2.0/dbhome_1/bin/
./lsnrctl start
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?
Sincerely,
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.
Regards,
Alex Lora - Alex Lora Tue 12/12/23 12:33 PM
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.
Regards,
Alex Lora - Alex Lora Tue 12/12/23 12:33 PM