oracle 8i installation on xp

[yrakesh78]

hi friends

plz help me how to install oracle 8i on xp systems after installing i given scott and tiger password and system,manager but its not working plz tell me procedure

[Faun]

see if there is any process named TNSLNR.exe running in task manager

[bluepearl]

what are u using to login rakesh?
SQL Plus ?
did u provide any password during installation?

[yrakesh78]

no after installation is completed i given the user name first time its connects next time onwards unable to connect........

[sandeepk]

What is the error message? Something like unable to connect..?

[Faun]

Originally Posted by yrakesh78

no after installation is completed i given the user name first time its connects next time onwards unable to connect........

hey buddy u didnt replied to my question ?
I ask again is there any process named "Tnslsnr.exe" is running in Task Manager, if not then please take the pain to start the "Tnslsnr" service.

Can u be more specific what error code is displayed?

[dOm1naTOr]

me too haf trouble after installation
I installed both ones including client nd server.

Now which one shud i open for performing SQL Plus?

And the usermane pass which i geve during installation dun work.
And whats is this 'host string' which is asked during login?

[Faun]

Originally Posted by aravind_n20

me too haf trouble after installation
I installed both ones including client nd server.

Now which one shud i open for performing SQL Plus?

And the usermane pass which i geve during installation dun work.
And whats is this 'host string' which is asked during login?

Is it oracle 9i ??
You should hav gone with standard install.

FATALITY is the database name that will be having tables created by u.

scott/tiger is the default username/password, it should work.

no need to enter host string.
Host string is use for client accesing oracle on network

[dOm1naTOr]

@T159
its version 8.1.6.0.0
scott/tiger is not workin.

[Faun]

Originally Posted by aravind_n20

@T159
its version 8.1.6.0.0
scott/tiger is not workin.

whats the error code ?

[bluepearl]

check the installation folder or start menu for something like start database or start service then try logging in !!

guys if u gonna use Oracle just for study purposes,
use Oracle10g XE (200 MB)
it is very simple and light weight !!
it works thr browser as well as cmd line

[Faun]

Ok try out this

Click on "Start" -> "Run" and enter "cmd"

sqlplus scott/tiger@FATALITY

where SID is FATALITY in case of aravind_n20

[gary4gar]

use 9i or any later version the latest being was recently revealed by oracle is oracle 11g, it offers many benefits over previous versions. if i correctly remember it supported grid computing. and is altogether faster than previous versions. also you can try MySql.its also nice.

Also oracle 8i is supported on windows 2000.
and oracle 8 personnel edition of win 98

[Faun]

Originally Posted by gary4gar

use 9i or any later version the latest being was recently revealed by oracle is oracle 11g, it offers many benefits over previous versions. if i correctly remember it supported grid computing. and is altogether faster than previous versions. also you can try MySql.its also nice.

Also oracle 8i is supported on windows 2000.
and oracle 8 personnel edition of win 98

yeah 9i and above are best, JAVA JDBC connectivity is much easier.

My SQL is good one but then in our college Oracle 9i is installed.

My SQL doesnt support procedures and subqueries.