how to start Oracle databse server

[riyaz udeen]

hye everybody, i want to know
1.how to start oracle database server in windows platform.
2. what has to be typed in under sql plus prompt - username: ??, password:??, host string: ??? .
3.how can i know the version of the oracle installed in my machine.

thanks in advance

[Nicolas Stern]

Hi,

You must start the service for the instance. (Name can be something like "OracleSeviceXYZ" - XYZ being the name of the instance.

You must also start the listener - either by starting the service, or by typing lsnrctl start in a dos console.

You can check if the listener is running by pinging : enter "tnsping XYZ" in a dos prompt. (XYZ being - again- the name of the instance).

Did you install the thing yourself ? Which version ? on older versions (ante 10g), you can try log in to the instance with SQLPLUS using the default passwords for the SYSTEM and SYS accounts

sqlplus SYS/CHANGE_ON_INSTALL@XYZ AS SYSDBA
or
sqlplus SYSTEM/MANAGER@XYZ

On 10g, AFAIK, you define to the passwords during installation process.

Can I send you first a gentle RTFM ?

Cheers - Nic

[Nicolas Stern]

First reply sent to early.

If you can't login, and if you did not install the server yourself (and can't ask anyone who had done it) you can check the installation log.

Or eventually, run the installer from the ORACLE_HOME. The complete list of the installed products will appear.

If you can log in, the product name and version appear after login.

You can also query the data dictionary views (select * from v$database)

[riyaz udeen]

thanks nicolas for your instant response. i am trying to contact the person who has installed oracle in mean time can you please help me out regarding :

I need what are the things to be filled in the place of '?' for mysql 4.1, oracle 9i,9.0,8i.

Class.forName("???");
DriverManager.getConnection("???");

moreover there are connector.jar files for oracle and mysql. so where we have to place them under which directory.

Thanks in advance.