Question Locked

error oracle in xp

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
After the Instalation of Oracle 8i on windows xp sp2, for the first time iam able to get the SQL prompt,but once i restart the system i will get error message "Oracle not Available",could any tell me why this error fires

4 replies

by locolobo

It looks like Oracle doesn't support Oracle 8i on XP. Try this article on Oracle's site.

http://download-west.oracle.com/docs/pdf/A97675_02.pdf

You will probably have to uninstall Oracle first. There are some patches to install on XP for Oracle. I didn't test the links to see if the patches were still there.

Other options would be to install 9i on XP or install 8i on W2K?

Good Luck

by lazy lurker

If you are receiving an "ORA-1034: Oracle not Available" error (which it sounds like you are), you are not connecting to the instance. This usually has one of two causes:

1) you are not pointing to the instance correctly
2) the instance is not there

To take the second point first, check the following:

- Is the Windows for the instance running? If not, try starting it.
- Is the instance started in the service? Try connecting to the instance as SYSDBA or SYSOPER and issuing a startup:

sqlplus /nolog
connect / as sysdba
startup

If your instance is up but you cannot connect, ... well, the possibilities are legion. Here are just a few options:

- check that the listener is running (another Windows service)
- check that you can resolve the network name with TNSPING (e.g. "tnsping my_db" where my_db is a service name of your instance)
- try setting %ORACLE_SID% to the name of your instance
- try setting %TWO_TASK% to a service name of your instance

BTW, this is not a username/password issue. That would be a different error.

by vy_vikas

in the ligin dialog box write "/ as sysdba" without "". it will take you to sql prompt.
type
sql> startup force
the database will startup
sql> conn Scott/tiger
it will show connected
sql>
now your DB is started and you can oprate it

This discussion is closed to new replies.