oracle8i instal on nt2000 prof

[igallacher]

Installed Oracle 8i (8.1.7.0.0) on an WIN2000 Profession file
server. Chose Typical install and let it run. Installed successfully and could log on into database via SQl plus
Imported user databse and could run applications ok.

Machine was re-set and when tried to connec to Oracle came up with message that Ocacle was not available. Couldnt get oracle to start.

Re-installed with Custom option to install minimum required.
Could then log into Oracle via SQlplus.

Reset Machine and when came back up hit exactly the same problem - Oracle not available.

Ran lsnrctl to see what was set up. Only 1 service was alloacted to my SID. On my laptop, with same intall have 3 service hanlders against SID, one of which is a despatcher.
( database comes up automatically on my Laptap running under XP )

Could get the database on file server active by using database admin assistant to change to configuration of the database. ( didnt really change anything ).
Couild then log into database via SQL

Then found that clients could not log into database. came up with TNS failure lookup. At this point i gave up.

Sorry for the long story, but has anybody any idea why working fine on XP laptop but not on WIN2000 Prof. Server

Thanks
IAN

 

[sem]

Do your oracle services start automatically? They may be started by installation utility but as they were installed as Manually Started services, they're lost after reboot.

As of your client problems, they should add TNS aliases pointing to your new database to their local tnsnames.ora files. This may be done by the same Assistance.