DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: How to create new database

  1. #1
    Join Date
    Mar 2004
    Posts
    5

    How to create new database

    Hi to all the experts and all the member ..
    I just started to learn the oracle last week...I need alot of help
    My question is how to create a new database and how to create new table and the step taken to just the job done ..

    I need the step ...
    Can some one help me ....

    Thanks alot ..
    From newbie

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447

  3. #3
    Join Date
    Mar 2004
    Posts
    5
    thanks alot But now the problem is how to create the listener
    When i try to craete the connection to the database but the system just pop me and message that no listener
    Please help me ...
    This is urgent thank alot

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Code:
    cat /u01/app/oracle/product/9.2.0/network/admin/listener.ora 
    
    # LISTENER.ORA Network Configuration File: /u01/app/oracle/product/9.2.0/network/admin/listener.ora
    # Generated by Oracle configuration tools.
    
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
          )
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = rac1)(PORT = 6969))
          )
        )
      )
    
    SID_LIST_LISTENER =
      (SID_LIST =
        (SID_DESC =
          (SID_NAME = PLSExtProc)
          (ORACLE_HOME = /u01/app/oracle/product/9.2.0)
          (PROGRAM = extproc)
        )
        (SID_DESC =
          (GLOBAL_DBNAME = lnx920)
          (ORACLE_HOME = /u01/app/oracle/product/9.2.0)
          (SID_NAME = lnx920)
        )
        (SID_DESC =
          (GLOBAL_DBNAME = rman920)
          (ORACLE_HOME = /u01/app/oracle/product/9.2.0)
          (SID_NAME = rman920)
        )
        (SID_DESC =
          (GLOBAL_DBNAME = rmandg)
          (ORACLE_HOME = /u01/app/oracle/product/9.2.0)
          (SID_NAME = rmandg)
        )
      )
    just edit listener.ora and start the listener, the sample I pasted is listening for 4 services (databases)

  5. #5
    Join Date
    Mar 2004
    Posts
    5
    At the first time I can connect to the database but now when i try to connect to the database the system give me TNSacket reader failure and some time ORA-12541: TNS:no listener how to solve this problem
    Thank alot for the help
    Can you please explain to me what the code do and what should i do if I am using diffrent version??
    Thank for the help ...

    From newbie
    Thank alot

  6. #6
    Join Date
    Mar 2004
    Posts
    5
    This is the error:
    Building Oracle HOMES List
    HOME Name OraHome90 added to list.
    Found multiple homes, searching each HOMEx for valid PATH
    searching in SOFTWARE\ORACLE\HOME0
    Oracle_Home found in SOFTWARE\ORACLE\HOME0 IS in system path!
    oci.dll found
    Thank alot
    From New bie

  7. #7
    Join Date
    Nov 2002
    Posts
    47
    Originally posted by ~Boon++~
    This is the error:
    Building Oracle HOMES List
    HOME Name OraHome90 added to list.
    Found multiple homes, searching each HOMEx for valid PATH
    searching in SOFTWARE\ORACLE\HOME0
    Oracle_Home found in SOFTWARE\ORACLE\HOME0 IS in system path!
    oci.dll found
    Thank alot
    From New bie
    Please Wait for your answer. Pando is finding out asnwer for your question. Stecal, Tarry,Marist89, Jmodic, Jovery, Sambavan..... all of them are preparing answer for you.

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Maybe the listener isn't started. Look at your services to see if it is or not, as a first step.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  9. #9
    Join Date
    Mar 2004
    Posts
    5
    I restart the listener and try to connect to the database again but it still can not ..
    My tomcat can not start after i start the toad is there any thing to do with oracle database connection ??

    Can you please help me I currently I am working on jsp so I need the tomcat and the database at the same time so what can I do ...

    what can I do ??
    Is the http server tomcat in the oracle same to the tomcat??

    Please help me ??
    Thanks alot for the help and also sorry about the message that i post before the reply ..
    so so so.... sorry about that

    From newbie.....

Posting Permissions

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


Click Here to Expand Forum to Full Width