Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    12

    Unanswered: Use SQL+ without starting DB

    I am trying to help some of my classmates get Oracle 8i, personal edition up and running and I need some help. Unnfortunately this class was unprepared to become DBA's as this is an SQL class. So, I've been trying to help. Here are the last couple of problems I'm dealing with:


    1) Can you use SQL+ without mounting and opening a DB?
    If so, how?
    I have tried: Connect system\manager as sysdba and get a SHARED REALM error. ( which I assume is the closed db )

    2) If they MUST have a db to run sql against, What is a good tutorial for them to use for command line DB creation. Some users have not been able to install the DB config Assistant.

    Hey, Any help on these matters appreciated. I've been trying to help answer these questions because I know how FRUSTRATING it can be when something doesn't work right.

    TIA...DBA_Frog

  2. #2
    Join Date
    Sep 2002
    Location
    ITALY
    Posts
    53

    Re: Use SQL+ without starting DB

    HI TIA.

    Try this, in unix works ... )

    /app/oracle/product/8.1.7/>export ORACLE_SID=<mySID>
    -- use set ORACLE_SID=...
    /app/oracle/product/8.1.7/>sqlplus /NOLOG

    SQL*Plus: Release 8.1.7.0.0 - Production on Tue Sep 17 16:17:08 2002

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

    SQL> connect internal
    Connected.
    -- try here the startup open .....
    -- SQL> alter system checkpoint;
    -- System altered.

    SQL>

    Have a nice day with the oracle.
    Franco Ceotto
    SIPTI srl
    OnSite Services
    9i OCP DBA, Performance Engineer

  3. #3
    Join Date
    Sep 2002
    Location
    ITALY
    Posts
    53

    Re: Use SQL+ without starting DB

    Hi TIA.

    Sorry i misunderstanded your question.

    The correct answer is:
    you cannot issue sql statements if you do not have a database processing them.

    bye.
    Franco Ceotto
    SIPTI srl
    OnSite Services
    9i OCP DBA, Performance Engineer

Posting Permissions

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