Page 1 of 2 12 LastLast
Results 1 to 15 of 25
  1. #1
    Join Date
    Mar 2011
    Posts
    12

    Unanswered: **EASY** Oracle 11g Question!

    The Initial POST is Below.

    The new one is the one that follows -

    I need someone who is well versed in the creation of databases and using SQL to provide some one on one help probably through MSN or email.

    The issue should be incredibly easy for someone who is good at this stuff and using ORACLE 11g. Its to do with creating the database through DBCA.

    Books required -

    Practical Guide to Using SQL in Oracle - Richard Earp and Dr Sikha Bagui
    Oracle Database 11g, A Beginners Guide - Mcgraw Hill

    If you cannot get a hold of these i will provide. You will need the book to understand my sticking point. Im a total beginner and these books have just confused me in the first few chapters.




    Original Post - Discard -


    Guys....2 days ive been struggling...please help...

    Heres where i am stuck -

    I installed O11g
    I created a database
    I did NOT configure enterprise manager
    I used sample schemas

    everything installed fine. however, after i clicked finish...thats it. no windows opened or nothing,

    i remember using oracle at home a few years ago and i opened a box with a white background and i could create tables and stuff.

    i dont know what to now with this 11g! i have no clue how to get this started up!
    im using mgrath handbook to follow through but his book is so complicated i have no idea it doesnt tell me what to do after creating the database, it just jumps to networks then coding.
    i dont want to network. i just want to create and code.

    its really bothering me now.
    ive always used oracle in windows xp.
    im on xp sp3 at the moment.
    Last edited by kapows; 03-21-11 at 18:59.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    If the database is up and running, you need to access it. The simplest way is to run SQL*Plus. It is a command line utility, so you'll need to run CMD first and then - at the command prompt - connect to the database, like in this example:
    Code:
    M:\>sqlplus scott/tiger@ora10
    
    SQL*Plus: Release 10.2.0.1.0 - Production on Pet OŚu 18 07:53:36 2011
    
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, OLAP and Data Mining options
    
    SQL>
    Now you can create tables, query existing ones, whatever.

    This is Oracle documentation; Developers Essentials section is displayed on the screen. Check 2 Day Developer's Guide (feel free to browse other documentation you find useful).

  3. #3
    Join Date
    Mar 2011
    Posts
    12
    Thanks for the help!

    Ok so ill tell you what i have done and what i havent done.

    Things I havent done.

    1. In my book it say -

    There are two scripts that need to be executed by the root owner to make these changes. Have the operating system administrator log in and
    run orainstRoot.sh and root.sh (as shown in the illustration).

    During my installation though, the illustration they show never came up. They dont tell you where to find or how to run the script

    2. Ive read in various places something to do with $ORACLE_SID or something. I havent touched that at all.

    Now, i think im on the right path in terms of SQL*Plus and if someone could explain the following image to me and tell me which step i did right and which i did wrong please it would help alot in understanding.

    My services - http://i.imgur.com/p1wHq.jpg

    Command Line - http://i.imgur.com/pwuCy.jpg

    This is the screen i was hoping to work in as i have done in the past when i last used Oracle which was Oracle 8 - http://i.imgur.com/0ppuT.jpg

    Handbook that im using - Mcgraw Hill - A Beginners Guide

    My database Username/Password - sample1/sample1

    **Extra**

    After doing some research ive heard that the GUI i want is now obsolete with 11g. If that is the case, are companies now using Oracle Sql Developer to create and manage tables?
    Or do they still use SqlPlus?
    What is the difference between the two and which should i use?

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    What is your MAJOR problem, exactly? SQL*Plus session image shows that you managed to shut down and start up your database, so - that seems to be OK. If you want to connect as SAMPLE1 user, you'd run (at the command prompt)
    Code:
    sqlplus sample1/sample1
    GUI you are talking about is ... which one? Is it iSQL*Plus? If so, it doesn't exist in your version (so forget about it). SQL Developer is a free GUI tool, provided by Oracle. Some people use it, some don't. I know quite a few users who still prefer good, old SQL*Plus. Some other use TOAD, PL/SQL Developer etc., but these are commercial products.

    How much do you know about Oracle? You said you used 8i (but that's a really old piece of software). From what you wrote here (so far), it seems that you are still a beginner, so - perhaps you should start from beginning and use SQL*Plus. It simply won't let you do stupid things by clicking around (and not knowing what you, actually, do). Once you learn it, GUI is a nice add-on. Choose any you want.

  5. #5
    Join Date
    Mar 2011
    Posts
    12
    ok i get ya i think im getting there now - ignore everything above and check this query

    i connect like this
    sql>connect sample1/sample1 as sysdba

    now, in my handbook, it says that i should type
    sql>desc customers;

    but guess what? it says that it doesnt exist.
    i dont think im connected to the sample schemas!
    i installed the db and selected sample schemas once created.
    what gives?

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I suggest you take a break & stop poking at SQL when you do NOT understand the basics.

    When all else fails, Read The Fine Manual
    Contents
    You'd benefit greatly from learning & understanding the basic to avoid asking RTFM questions.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Mar 2011
    Posts
    12
    seriously i could follow the book its just that i dont think im running the SH schema

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >its just that i dont think im running the SH schema

    SQL> CONNECT SH/<password>
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Mar 2011
    Posts
    12
    thanks anec
    ive done that already
    it says connected
    but when i type >desc customers;
    it says object does not exist

    (if i type the code for the follwing thats what it shows)
    global name
    SAMPLE1
    user
    SYS

    ill take your advice as i dont want to be a pain and if you think i should start over then i will. thanks again

  10. #10
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    sqlplus
    / as sysdba
    select owner from dba_tables where table_name = 'CUSTOMERS';
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  11. #11
    Join Date
    Mar 2011
    Posts
    12
    I included the book snippet and the cmd interface

    http://i.imgur.com/rPrnM.jpg


  12. #12
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    yes, the results are not as you expect/desire; but do you understand why?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  13. #13
    Join Date
    Mar 2011
    Posts
    12
    id be guessing if i said something to do with not connected correctly or not provided permissions.

    but i dont want to guess so ill go back to try and understand

  14. #14
    Join Date
    Jan 2011
    Posts
    19
    This user may have been invented to make anacedent go insane.

    Kapows might I suggest if you're just trying to learn to install Oracle EX. Might be a little easier on you.

  15. #15
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Oracle "EX"?

Posting Permissions

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