Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    Join Date
    Aug 2004
    Location
    Manchester, UK
    Posts
    143

    Unanswered: Shutdown problems

    Hello, I'm trying to bounce a database (called sadas) but I have come across a strange problem. I can log in to sqlplus using sys/pass@sadas as sysdba. I can then perform 'shutdown immediate' with no problems.

    But then when I attempt 'startup' I get told: "you are not logged in". So then I exit out of sqlplus and log in again as sys. I then attempt 'startup' again, and get the message 'database cannot be mounted in exclusive mode'.

    I really can't make out what is happening, I am simply trying to bounce the server in the most basic way.

    The contractor who created the database has told me to use the following script to do this, but I still can't get past the fact that I should be able to do a basic shutdown as described above!

    Contractor's script!


    Code:
    call c:\APPS\oracle\ora81\bin\oradim.exe -shutdown -sid SADAS -usrpwd ORACLE -shuttype srvc,inst -shutmode i
    net stop OracleORAHOME81TNSListener
    net start OracleOraHOME81TNSListener
    ORADIM -STARTUP -SID SADAS -USRPWD ORACLE -STARTTYPE SRVC -PFILE D:\SADAS\ORACLE\ADMIN\PFILE\SADASINIT.ORA
    I shouldn't have to shut the listener down to shut the database as far as I know. I don't do that on all my other oracle dbs.

    Any ideas on how to get past this?

    Many thanks!

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    The above script is shutting down the Oracle Service (instance and service) ... look in the services
    to see this ... control panel / administrative / services / OracleServiceSADAS. Look in the registry to see if the
    AUTOSTART is set to TRUE (hkey_local_machine\software\oracle\...).

    If the database is setup for AUTOSTART = TRUE, then you should be able
    to stop and start the service and be ok.

    HTH
    Gregg

  3. #3
    Join Date
    Aug 2004
    Location
    Manchester, UK
    Posts
    143
    No, sorry, I know that the oradim scripts work fine, and do indeed bring the db up and down as required along with the service etc, but my point is really that I can't see why the db doesn't shutdown and startup manually when I type the command directly into sqlplus. I want to know why I can't just log in as sysdba and do shutdown immediate, followed by startup.

    Thanks

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    You should be able to shutdown / startup ...
    What do you get when you issue the following:

    cmd> sqlplusw / nolog
    sql> connect sys/password@sadas as sysdba

    sql> select open_mode from v$database;
    sql> select * from v$instance;

    sql> shutdown immediate;

    sql> startup pfile=c:\.....\initfile.ora

    In your tnsnames.ora ... do you have anything like
    (SERVER = DEDICATED)

    Gregg

  5. #5
    Join Date
    Aug 2004
    Location
    Manchester, UK
    Posts
    143
    Will check this out tomorrow, as I need to kick the users off first.

    Thanks

  6. #6
    Join Date
    Aug 2004
    Location
    Manchester, UK
    Posts
    143
    Ok, I tried all of this. Still no luck, I get the same message - cannot open database in exclusive mode. The tnsnames file does not have server = dedicated in it, and the open_mode is open.

    Any other thoughts?

    Thanks,
    Paula.

  7. #7
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Are you running this from the server or from your client???

    How about post the tnsnames, sqlnet and listener .ora's (change
    the names in these files to protect the innocent) .... It looks like you are probably running 8.1.7 ( are you running 8.1.7.4 ?)

    Gregg

  8. #8
    Join Date
    Aug 2004
    Location
    Manchester, UK
    Posts
    143
    Hi,

    I am running this from the server directly. The database is at version 8.1.5.0.0.

    TNSNAMES.ora:

    Code:
    # C:\APPS\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:C:\Apps\Oracle\Ora81\network\admin\tnsnames.ora
    # Generated by Oracle Net8 Assistant
    
    SADAS.WORLD =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = SADAS)
        )
      )
    
    TESTOMBC.WORLD =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = TESTOMBC)
        )
      )
    
    EXTPROC_CONNECTION_DATA.OLDHAM.GOV.UK =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
        )
        (CONNECT_DATA =
          (SID = PLSExtProc)
          (PRESENTATION = RO)
        )
      )
    SQLNET.ora:

    Code:
    # C:\APPS\ORACLE\ORA81\NETWORK\ADMIN\SQLNET.ORA Configuration File:C:\Apps\Oracle\Ora81\network\admin\sqlnet.ora
    # Generated by Oracle Net8 Assistant
    
    NAMES.DEFAULT_DOMAIN = WORLD
    
    NAMES.DEFAULT_ZONE = WORLD
    
    SQLNET.AUTHENTICATION_SERVICES= (NTS)
    
    NAME.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)
    LISTENER.ora:

    Code:
    # C:\APPS\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:C:\Apps\Oracle\Ora81\network\admin\listener.ora
    # Generated by Oracle Net8 Assistant
    
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
          )
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxx)(PORT = xxxx))
          )
        )
        (DESCRIPTION =
          (PROTOCOL_STACK =
            (PRESENTATION = GIOP)
            (SESSION = RAW)
          )
          (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx)(PORT = xxxx))
        )
      )
    
    SID_LIST_LISTENER =
      (SID_LIST =
        (SID_DESC =
          (SID_NAME = PLSExtProc)
          (ORACLE_HOME = C:\Apps\Oracle\Ora81)
          (PROGRAM = extproc)
        )
        (SID_DESC =
          (GLOBAL_DBNAME = SADAS)
          (ORACLE_HOME = C:\Apps\Oracle\Ora81)
          (SID_NAME = SADAS)
        )
      )
    Thanks for all your help.

    Paula.

  9. #9
    Join Date
    Aug 2003
    Location
    West
    Posts
    101
    Don't you have a trc or alert_log in you bdump area?

  10. #10
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Are you specifying the PFILE option when you startup? The parameter file is not in the standard location so if you don't use the pfile parameter then the database will not startup correctly.

    sqlplus "/ as sysdba"
    connect internal
    startup PFILE=D:\SADAS\ORACLE\ADMIN\PFILE\SADASINIT.ORA
    exit
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  11. #11
    Join Date
    Aug 2004
    Location
    Manchester, UK
    Posts
    143
    Quote Originally Posted by Ida Hoe
    Don't you have a trc or alert_log in you bdump area?
    The trace just tells me the following:

    ORA-09341: scumnt: unable to mount database
    OSD-04400: unable to acquire internal semaphore for process

    This implies there are sessions open, but I did shutdown immediate which should kill them all shouldn't it?

  12. #12
    Join Date
    Aug 2004
    Location
    Manchester, UK
    Posts
    143
    Quote Originally Posted by beilstwh
    Are you specifying the PFILE option when you startup? The parameter file is not in the standard location so if you don't use the pfile parameter then the database will not startup correctly.

    sqlplus "/ as sysdba"
    connect internal
    startup PFILE=D:\SADAS\ORACLE\ADMIN\PFILE\SADASINIT.ORA
    exit
    I have tried both ways, specifying and not specifying the pfile. I get the same error both times.

    Thanks,

    Paula.

  13. #13
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Under 8.1.5 ... Can you startup the database other than exclusive mode?
    I don't remember. I always used SVRMGRL for start/shutdown of 8.1 databases...

    What happens when you try to start it up using SVRMGRL

    Gregg

  14. #14
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Do you have enough semphores set on UNIX?

  15. #15
    Join Date
    Aug 2004
    Location
    Manchester, UK
    Posts
    143
    Hmm, I'm not sure. All my other DBs are 9i. This one has been hanging around for ages and I have only recently been asked to look at it. I've only ever used sqlplus. What do I do with svrmgrl?

Posting Permissions

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