Results 1 to 5 of 5

Thread: Oracle 10g

  1. #1
    Join Date
    Jul 2005
    Posts
    39

    Unanswered: Oracle 10g

    I just installed oracle 10g on WinXP. Would anyone know how to arrange the setting where it wont eat up my memory upon start up?
    ================================
    RAM disk is *not* an installation procedure
    ================================

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Open Administrative Tools - Services and change "OracleServiceits_name" (for example, "OracleServiceORA10G") Startup Type to "Manual". Doing so, Oracle won't start up when computer starts up - you'll have to do it manually.

  3. #3
    Join Date
    Jul 2005
    Posts
    39
    How would i do a manual startup?
    ================================
    RAM disk is *not* an installation procedure
    ================================

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Connect to an idle instance and issue the STARTUP command:
    Code:
    C:\>sqlplus sys/password as sysdba
    
    SQL*Plus: Release 10.2.0.1.0 - Production on Ned Vel 25 11:30:25 2007
    
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    
    Connected to an idle instance.
    
    SQL> startup
    ORA-32004: obsolete and/or deprecated parameter(s) specified
    ORACLE instance started.
    
    Total System Global Area  167772160 bytes
    Fixed Size                  1247900 bytes
    Variable Size              79693156 bytes
    Database Buffers           83886080 bytes
    Redo Buffers                2945024 bytes
    Database mounted.
    Database opened.
    SQL>
    To shut it down, connect the same way and issue
    Code:
    SQL> shutdown immediate;
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    SQL>

  5. #5
    Join Date
    Feb 2007
    Posts
    8

    A windows 'solution'

    A database in XP will show up as a 'service', for example OracleServiceORCL.
    You can stop or start these Windows 'services', just like any other.
    It is not exactly gentle for the database, because it's basically a 'shutdown abort' I guess, but it works for me.

Posting Permissions

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