ORACLE not available.

srikanthrad
srikanthrad used Ask the Experts™
on
srikanth@srikanth-laptop:~$ $ORACLE_HOME/bin/lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 30-JAN-2010 03:27:45

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                30-JAN-2010 03:21:01
Uptime                    0 days 0 hr. 6 min. 43 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/srikanth/app/srikanth/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /home/srikanth/app/srikanth/diag/tnslsnr/srikanth-laptop/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
The listener supports no services
The command completed successfully
srikanth@srikanth-laptop:~$ ps -ef | grep pmon
srikanth 16259 14127  0 03:28 pts/1    00:00:00 grep pmon
srikanth@srikanth-laptop:~$ tnsping $ORACLE_SID

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 30-JAN-2010 03:30:08

Copyright (c) 1997, 2009, Oracle.  All rights reserved.

Used parameter files:
/home/srikanth/app/srikanth/product/11.2.0/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (10 msec)

srikanth@srikanth-laptop:~$ echo $ORACLE_HOME
/home/srikanth/app/srikanth/product/11.2.0/dbhome_1
srikanth@srikanth-laptop:~$ echo $ORACLE_SID
orcl
srikanth@srikanth-laptop:~$ ps -ef | grep smon
srikanth 17310 14127  0 03:41 pts/1    00:00:00 grep smon


srikanth@srikanth-laptop:~$ sqlplus srikanth/*******

SQL*Plus: Release 11.2.0.1.0 Production on Sat Jan 30 03:35:19 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0

Open in new window

init-ora-and-spfile.txt
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Does this link helps you?
http://www.orafaq.com/forum/t/26524/2/

Author

Commented:
I added this to my listener.ora file

SID_LIST_LISTENER =
 (SID_LIST =
   (SID_DESC =
     (SID_NAME = ORCL)
     (ORACLE_HOME = /home/srikanth/app/srikanth/product/11.2.0/dbhome_1)
     (PROGRAM = extproc)
   )
 (SID_DESC=
       (GLOBAL_DBNAME=ORCL)
       (ORACLE_HOME=/home/srikanth/app/srikanth/product/11.2.0/dbhome_1)
       (SID_NAME=ORCL)
  )
 )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /home/srikanth/app/srikanth


My TNSNAMES.ORA file is like this:

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

Now, it is not saying This listener doesn't provide any services. But, still getting the same error shared realm and everything.

now lsnrtctl services is giving the following message:

srikanth@srikanth-laptop:~/app/srikanth/product/11.2.0/dbhome_1/bin$ lsnrctl services

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 30-JAN-2010 05:31:25

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "ORCL" has 1 instance(s).
  Instance "ORCL", status UNKNOWN, has 2 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
The command completed successfully

Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
C:\sqlplus
SQL*Plus: Release 8.1.7.0.0 - Production on Mon Oct 19 14:58:50 2009

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Enter user-name: sys/sys as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 237856796 bytes
Fixed Size 75804 bytes
Variable Size 80416768 bytes
Database Buffers 157286400 bytes
Redo Buffers 77824 bytes
Database mounted.
Database opened.
SQL>

This did the trick for me.. Thanks a bunch.. If I forgot the password to my account, what do I do in oracle?

Author

Commented:
Forgot the password to my personal accountL. What do I do now? Thanks for links.. That helped a lot.

Author

Commented:
got it.
alter user username identified by passwd.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial