Please post the details of the application release, database version and OS.
Just wanted to let you know that there was some maintainace activity. After that when i tried to start the ebs db and listener it is givng the below error.
What kind of maintenance activities?
LSNRCTL for Linux: Version 220.127.116.11.0 - Production on 01-SEP-2013 20:59:45
Copyright (c) 1991, 2011, Oracle. All rights reserved.
/db/tech_st/11.2.0/bin/tnslsnr: please wait...
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
oracle 3828 1 0 10:26 ? 00:00:00 /u01/oracle/SID/db/tech_st/11.2.0/bin/tnslsnr SID -inherit
What is the output of "ps -ef |grep tnslsnr"?
Was the database env file set before starting the listener?
ORA-00000: normal, successful completion
Please post the output of "env | sort" command.
Please also check the database log file for any errors.
SQL*Plus: Release 18.104.22.168.0 Production on Mon Sep 2 10:50:36 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> select open_mode from v$database;
select open_mode from v$database
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
If the database is not up yet, then this is an expected output.
Please unmount the file system and mount it again (you may also reboot the server) and try the above commands again.