Jump to content

Search the Community

Showing results for tags 'listener'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Oracle
    • Oracle Forum


  • Community Calendar

Found 1 result

  1. I could access the database fine before the power outage. From what I've read, it is an issue with the environment variables, but those are correct. See below. C:\Documents and Settings\konoca>sqlplus / as sysdba SQL*Plus: Release - Production on Wed Feb 21 09:17:08 2018 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-01031: insufficient privileges Enter user-name: dbaprod Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Enter user-name: C:\Documents and Settings\konoca>sqlplus dbaprod/Get0ut@firsp SQL*Plus: Release - Production on Wed Feb 21 09:17:54 2018 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12541: TNS:no listener Enter user-name: C:\Documents and Settings\konoca>lsnrctl stat LSNRCTL for 32-bit Windows: Version - Production on 21-FEB-2018 09:18 :46 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST= STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 32-bit Windows: Version - Produ ction Start Date 18-FEB-2018 08:52:13 Uptime 3 days 0 hr. 26 min. 33 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File E:\oracle\product\10.2.0\network\admin\listener.ora Listener Log File E:\oracle\product\10.2.0\network\log\listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) Services Summary... Service "FIRSP" has 1 instance(s). Instance "FIRSP", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully C:\Documents and Settings\konoca>echo %ORACLE_HOME% E:\oracle\product\10.2.0 C:\Documents and Settings\konoca>echo %ORACLE_SID% firsp C:\Documents and Settings\konoca> # listener.ora Network Configuration File: E:\oracle\product\10.2.0\network\admin\listener.ora # Generated by Oracle configuration tools. #TRACE_LEVEL_LISTENER = SUPPORT #TRACE_DIRECTORY_LISTENER = E:\oracle\product\10.2.0\network\trace #TRACE_TIMESTAMP_LISTENER = ON SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = FIRSP) (ORACLE_HOME = E:\oracle\product\10.2.0) (PROGRAM = extproc) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) )