January 26th, 2004, 10:43 AM
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.
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.
Last edited by WebWorker; January 26th, 2004 at 11:43 AM.
January 27th, 2004, 07:57 AM
(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.
January 27th, 2004, 09:39 AM
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!
January 27th, 2004, 11:55 AM
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:
For example you SID is set to TEST then service should be look like that:
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.
January 28th, 2004, 02:37 PM
Thank now it works but i stil not geting connection to my database via TOAD.