Results 1 to 11 of 11
  1. #1
    Join Date
    Mar 2004
    Posts
    8

    Unanswered: installing oracle in linux, how to know if it's running?

    Hi all, I have installed oracle 9i in my red hat linux box, but I'm getting few problems (Logging as root):

    1) if I type lsnrctl status i get:

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)) )
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 9.2.0.1.0 - Production
    Start Date 03-MAR-2004 15:49:11
    Uptime 0 days 4 hr. 5 min. 4 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File /oracle/db/product/9.2.0.1.0/network/admin/listener.or
    a
    Listener Log File /oracle/db/product/9.2.0.1.0/network/log/listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)) )
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=pingpong .us.oracle.com)(PORT=1521)))
    Services Summary...
    Service "ETSDB" has 1 instance(s).
    Instance "ETSDB", status BLOCKED, has 1 handler(s) for this service...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "hct.apps.oracle" has 1 instance(s).
    Instance "ETSDB", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully


    is this ok? why does it say BLOCKED?

    2) if I try my installation using sqlplus scott/tiger, I get the following:

    QL*Plus: Release 9.2.0.1.0 - Production on Wed Mar 3 20:00:17 2004

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    ERROR:
    ORA-01033: ORACLE initialization or shutdown in progress


    Enter user-name:


    why is that?

    thanks!

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: installing oracle in linux, how to know if it's running?

    Originally posted by aegcp
    Hi all, I have installed oracle 9i in my red hat linux box, but I'm getting few problems (Logging as root):

    1) if I type lsnrctl status i get:

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)) )
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 9.2.0.1.0 - Production
    Start Date 03-MAR-2004 15:49:11
    Uptime 0 days 4 hr. 5 min. 4 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File /oracle/db/product/9.2.0.1.0/network/admin/listener.or
    a
    Listener Log File /oracle/db/product/9.2.0.1.0/network/log/listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)) )
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=pingpong .us.oracle.com)(PORT=1521)))
    Services Summary...
    Service "ETSDB" has 1 instance(s).
    Instance "ETSDB", status BLOCKED, has 1 handler(s) for this service...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "hct.apps.oracle" has 1 instance(s).
    Instance "ETSDB", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully


    is this ok? why does it say BLOCKED?

    2) if I try my installation using sqlplus scott/tiger, I get the following:

    QL*Plus: Release 9.2.0.1.0 - Production on Wed Mar 3 20:00:17 2004

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    ERROR:
    ORA-01033: ORACLE initialization or shutdown in progress


    Enter user-name:


    why is that?

    thanks!
    Check your alert log.

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    try this command:
    ps -ef | grep oracle


    post the results.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Mar 2004
    Posts
    8
    this is the result:

    oracle 796 1 0 15:21 ? 00:00:00 /oracle/db/product/9.2.0.1.0/bin
    root 1182 1142 0 15:22 pts/0 00:00:00 su oracle
    oracle 1183 1182 0 15:22 pts/0 00:00:00 bash
    oracle 1217 1183 0 15:23 pts/0 00:00:00 ps -ef
    oracle 1218 1183 0 15:23 pts/0 00:00:00 grep oracle


    so it looks like it's running. but if I do (with oracle user):

    $ sqlplus scott/tiger

    i get:

    SQL*Plus: Release 9.2.0.1.0 - Production on Thu Mar 4 15:23:05 2004

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux Error: 2: No such file or directory


    Enter user-name:


    what's wrong?

  5. #5
    Join Date
    Jan 2004
    Posts
    370
    The instance isn't running (why do you think it is?).

    You need to login as sysdba and start it up.

  6. #6
    Join Date
    Mar 2004
    Posts
    8
    sigh... thanks!

    now, if I do ps -ef | grep oracle, i get this:

    oracle 1715 1714 0 17:23 pts/0 00:00:00 bash
    oracle 2029 1498 0 17:47 pts/1 00:00:00 sqlplus
    oracle 2031 2029 0 17:47 ? 00:00:00 oracleETSDB (DESCRIPTION=(LOCAL=
    oracle 2092 1 0 17:51 ? 00:00:00 ora_pmon_ETSDB
    oracle 2094 1 0 17:51 ? 00:00:00 ora_dbw0_ETSDB
    oracle 2096 1 0 17:51 ? 00:00:00 ora_lgwr_ETSDB
    oracle 2098 1 0 17:51 ? 00:00:00 ora_ckpt_ETSDB
    oracle 2100 1 0 17:51 ? 00:00:00 ora_smon_ETSDB
    oracle 2102 1 0 17:51 ? 00:00:00 ora_reco_ETSDB
    root 2179 1641 0 18:52 pts/2 00:00:00 grep oracle

    ETSDB is my db name. but, apart from that, why can't I do a simple
    # sqlplus scott/tiger

    (same with oracle user), i get this:

    SQL*Plus: Release 9.2.0.1.0 - Production on Thu Mar 4 18:55:20 2004

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    ERROR:
    ORA-01033: ORACLE initialization or shutdown in progress


    Enter user-name:


    But, if I do:

    sqlplus /nolog
    SQL> connect system/manager as sysdba
    Connected.

    it shows no error!

    :-(
    Last edited by aegcp; 03-04-04 at 22:39.

  7. #7
    Join Date
    Jan 2004
    Posts
    370
    Check the alert log - startup and shutdown times are logged there.

    Is the instance still running?
    From the ps output it looks like you've still got a session still connected.
    Your sysdba session?
    Can you perform any database operations from that session?

    select * from dba_users;

  8. #8
    Join Date
    Mar 2004
    Posts
    8
    thanks.

    I checked the alert log for my ETSDB database (alert_ETSDB.log) and at the end I get:

    Thu Mar 4 19:20:01 2004
    ALTER DATABASE MOUNT
    Thu Mar 4 19:20:01 2004
    ORA-00202: controlfile: '?/dbs/cntrl@.dbf'
    ORA-27037: unable to obtain file status
    Linux Error: 2: No such file or directory
    Additional information: 3
    Thu Mar 4 19:20:01 2004
    ORA-205 signalled during: ALTER DATABASE MOUNT...

    there's certainly an error with this... but, if I'mnot mistaken, this is related to my ETSDB instance, right? is this related on why scott/tiger doesn't even work?

    if i do a:

    select * from dba_users

    i get:

    ERROR at line 1:
    ORA-01219: database not open: queries allowed on fixed tables/views only

    ?

  9. #9
    Join Date
    Jan 2004
    Posts
    370
    Yes, that's the reason.

    Your database isn't open.
    It isn't even mounted.

    Have you actually created a database?

  10. #10
    Join Date
    Mar 2004
    Posts
    8
    oh dear.... as u can see this is my first intallation, so be patient

    from what I've read, once you installed oracle db, it comes with a dabase that you can access it using scott/tiger. this way you can test that it sqlplus is working properly. if it is, then you can move on and start creating another instance.

    so u mean that I also have to install this db in order to access it with scott/tiger?

    if so, how do i create it?

  11. #11
    Join Date
    Jan 2004
    Posts
    370
    The Oracle Installer normally starts the Database Configuration Assistant (dbca) after installing the database software. Maybe it didn't start or gave errors during database creation?

    You start it as the oracle user by typing dbca at the command prompt.

    See the following link:

    http://download-west.oracle.com/docs...te.htm#1000144

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •