Oracle 8i Lite install and config 1

[Almarton]

Hi all,
I installed Oracle 8i Lite in a Toshiba Laptop running
W2K but I could not run SQL+ 8 because after entering
the default login:SCOTT and pwd:TIGER (as in the doc's)
and leaving the third box empty (HOST STRING??) the
program returns an error ...could not connect to the
host. I am a begginer with Oracle, what do I have to
config before and ODBC DSN? I think the server may not
be running that's why it does not connect to the sample database (POLITE) how to set it? Please help...
Thanks;

Alexandre @lmarton Marton
almarton@task.com.br

 

[jee]

I have not used Oracle Lite so this may not be the solution, but it works with Personal Oracle and Oracle Enterprise...

In your registry under:
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE

Define a string variable called ORACLE_SID and set its value to the SID of your database.

Reboot.

You should now be able to execute SQL*PLUS and omit the HOST STRING and it will connect to your local database by default. Otherwise it tries to use SQL*NET. You can still connect to a remote database by specifying a HOST STRING.

 

[Almarton]

Thanks for the help pal, appreciate. I will try
and do that but I don't know what is SID so I may fail... If it is not too much trouble can you tell me how to find my DB SID?

The curious thing about the problem is that I was trying to use the EXAMPLE DB that comes with Oracle (POLITE) it should be automatically set during the install, don't you think? Well in the docs there is nothing about HOST STRING, reading I supposed that it would be enough providing login and pwd! But seems not!

Was I supposed to do anything after the Oracle install as
NT administrator to set up something?? I know it is a sorry as question but I am really on the dark with Oracle...

Look forward hearing from you
[]s Almarton


Alexandre @lmarton Marton
almarton@task.com.br

 

[jee]

Does Oracle Lite use a parameter file? (Named INITxxx.ORA)? If so, look there for a paramter called INSTANCE_NAME - this is usually the same as the SID. You can also look at the view V_$DATABASE, NAME column (but if you can't connect to the database, that is sort of hard to do).

I am not much help since I haven't used Oracle Lite, perhaps someone else can shed some light on the subject.

 

[sem]

Try to use odbcolite as a connect string.

 

[Almarton]

Dear "sem"
I would like to show my respects and appreciation for your help, was straigth to the point odbcolite as HOST STRING will do it! CONNECTS FINALLY!!! I am grateful for you have solved this apparently simple doubt of mine but that was consuming my time and patience. Columbus' egg (and it was not in the docs, well I didn't find) Works, THANKS, THANKS.
Hope to retribute some time, maybe with java???
Regards
Almarton Alexandre @lmarton Marton
almarton@task.com.br