How to create new database

[~Boon++~]

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

[pando]

http://download-west.oracle.com/docs...a96521/toc.htm

registration is free

[~Boon++~]

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

[pando]

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)

[~Boon++~]

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

[~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

[minhaz]

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.

[slimdave]

Maybe the listener isn't started. Look at your services to see if it is or not, as a first step.

[~Boon++~]

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.....