Printable View
I have installed oracle8i on my home machine.I am using Windows XP OS. When iam installing it asks for hostname , i dont know what to be entered there.
What all to be set in tnsnames file. If i leave it blank and try to start SQL
then it gives [ORA-12560 TNS:protocol adapter error].
Also is it possible to successfully install ORACLE 8I on WINDOWS XP OS?????
Also please tell me all the changes to be made, if any in sqlnet file , host file etc.
Please tell me all the changes to be made.
:D
Hi vmshenoy,
[B]In Hostname, enter the Machine ID [/B]on which the oracle is been installed.
[B]TNSNAMES.ORA [/B]is very important for the database connectivity.
A tnsnames.ora file provides the ability to reference oracle databases by a simple alias.
The tnsnames details has given below,
[Code]
[service_name] =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = [hostname])(PORT = 1521))
)
(CONNECT_DATA =
(SID = [oracle_SID])
)
)
[/Code]
Instead of Hostname, the Server IP can also be given in the HOST value.
As far as to my knowledge, Windows XP does not support Oracle 8i very well.
[B]For Windows XP, its better to go for either Oracle 9i or 10g version.[/B]
Probably it will be appreciable if we get comments from others who have used Oracle 8i in Windows XP.
I had Oracle 8i in my machine (It's windows XP.) It went on fine.
Oh! vmshenoy will be happy to hear that :-)
Barbie, the installation was fine & is it working fine?
Hi vmshenoy,
Checked out the Oracle OTN site, if u want to go for Oracle 9i or 10g version, the database downloads are available.
I'm not sure about the download conditions for 9i, but very sure that the 10g download was for free, so u can try any of them.
[URL="http://www.oracle.com/technology/software/products/oracle9i/index.html"]Oracle9i Database Downloads[/URL]
[URL="http://www.oracle.com/technology/software/products/database/xe/index.html"]Oracle10g Database Downloads[/URL]
My friend has installed the 10g from OTN & it was working fine.
If u install the Database, give your suggestions about the download & installation over here, so that it will be helpful for others.
hi ,
when you are installing oracle 8i it does not ask for host name .
it may ask for global database name and system id (SID) .(plz check it)
and give the [B]unique[/B] name in the global database name as u wish (let sct.domain)
and in the SID (let sct --automatically taken).
from
samarendra mishra
india:)
Hi friends,
the default password for oracle 8i is internal/oracle
Hi friends,
the default password for oracle 8i is internal/oracle