Thread: Login pb

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Germany
    Posts
    6
    Rep Power
    0

    Login pb


    Hi,

    I am installing Oracle 9i under win xp.
    when i try to lunch the SQL plus or any services he requerds username and password and host or service.

    username:System
    password:manager
    host:localhost

    but it does not work.
    i d'ont no where i start the oracle documentation is very big .
    let me just now in wich chort way can i create database and i do my sql statment.
    I am trying to use TOAD but i get the same pb username etc.
    any Helpe please.
    Thanks

    sany.
    Last edited by WebWorker; January 26th, 2004 at 12:43 PM.
  2. #2
  3. No Profile Picture
    Senior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Canada
    Posts
    308
    Rep Power
    12
    (1)When you were installing Oracle9i, did you craete oracle database or not?, if not then first create the database using Oracle Enterprise Manager (OEM).
    (2)If you have already created a database then you should check the Oracle service is running or not, if not then start it.
    (3)You might be experiencing some connectivity problem check your connection or recreate it.
    (3)Which user you are using to connect with oracle database? if SYS/password then connect AS SYSDBA like that:
    SYS/password AS SYSDBA.

    For quick response and correct solution try to post the specific error number and message.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Germany
    Posts
    6
    Rep Power
    0
    I have installed Oracle with the 3 services.

    and then I lunch the Entriprise Manager Console.
    I try to create a Database and it looks ok but when i lunch create it now then he aske for password and user.

    where can i type "SYS/password AS SYSDBA"?

    i deinstall ist now and i will start from beging.

    tel me please how can i crate database.
    and use the TOAD to create my tables etc.
    Thanks for your responce!
    sany.
  6. #4
  7. No Profile Picture
    Senior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Canada
    Posts
    308
    Rep Power
    12
    OK, first deinstall the Oracle9i from your computer using Oracle Univeral Installer (OUI), remember it does not clean out the some directories that is created by the oracle at installation time, remove it manually. Now start installing oracle9i, during the installation it will ask you to create a database, select that option then it will ask you to provide the password for SYS and SYSTEM users, enter desired password (write it down in your note book), keep continue installation, at the end oracle will create not only database also it service for you, you have to just make sure yourself that this service is running or not, run the follwoing command to check it:

    C:/> NET START

    This command will show you all services those are running in your system, try to find out the Oracle service, look like following:

    Syntax:
    OracleService<SID>

    For example you SID is set to TEST then service should be look like that:

    OracleServiceTEST

    If your service is not running start it using the following command:

    C:/>net start OracleServiceTEST

    If you find it up and running then try to connect with database using SQL*Plus as SYS or SYSTEM AS SYSDBA.
  8. #5
  9. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Germany
    Posts
    6
    Rep Power
    0
    Thank now it works but i stil not geting connection to my database via TOAD.

IMN logo majestic logo threadwatch logo seochat tools logo