General discussion

  • Creator
    Topic
  • #2080023

    ORACLE DB Question

    Locked

    by unixlvr ·

    I’m at a loss. My firm does not have the manuals and those that know are not willing to share knowledge. However, I really need this info to complete a project. The platform is UNIX. I can log onto the system as the oracle id, but I cannot find the command or correct syntax to create a DB or instance and bring it up. I’m using version 7.x – 8.x and know how to startup the server and listener as well as bring them down. Anyone who knows what books I could purchase and/or the correct syntaxwould be hero for life.

All Comments

  • Author
    Replies
    • #3901799

      ORACLE DB Question

      by outlaw4 ·

      In reply to ORACLE DB Question

      If the documentation set was isntalled on your server during the install of the server software, you should find it in the directory DOC under your Oracle Home. If it was not loaded down, it can be found on the install CD for the server. Other options are to go to http://www.oracle.com and go to the Oracle Store. There they have Documentation for sale. Also Osborne publishers put out a variety of Oracle PRESS manuals which put out a condensed set of manuals on a variety of Oracle topics (go to http://www.osborne.comr). If you have a CSI # regarding your purchase of the server software, you can also get the server documentation from the web site.

      • #3792716

        ORACLE DB Question

        by unixlvr ·

        In reply to ORACLE DB Question

        The question was auto-closed by TechRepublic

    • #3903400

      ORACLE DB Question

      by sonalsejal ·

      In reply to ORACLE DB Question

      Get the dba handbook from oracle press.
      The syntax for setting up the oracle instance is
      set oracle_sid=
      This is true for NT. I guess the variable is $oracle_sid in Unix.
      For creating the database,
      CREATE DATABASE
      LOGFILE ‘D:\orant\database\log1.ora’ size 5M reuse,
      ‘D:\orant\database\log2.ora’ size 5M reuse,
      ‘D:\orant\database\log3.ora’ size 5M reuse,
      ‘D:\orant\database\log4.ora’ size 5M reuse
      MAXLOGFILES 32
      MAXLOGMEMBERS 2
      MAXLOGHISTORY 1
      DATAFILE ‘d:\orant\database\Sys1.ora’ SIZE 25M
      MAXDATAFILES 254
      MAXINSTANCES 1
      CHARACTER SET WE8ISO8859P1
      NATIONAL CHARACTER SET WE8ISO8859P1;

      Alter the values of the parameters as per your need.
      Hope this is a help.Sonal

      • #3792717

        ORACLE DB Question

        by unixlvr ·

        In reply to ORACLE DB Question

        The question was auto-closed by TechRepublic

    • #3792715

      ORACLE DB Question

      by unixlvr ·

      In reply to ORACLE DB Question

      This question was auto closed due to inactivity

Viewing 2 reply threads