4 replies
by jeet_com Accepted solution
by locolobo Accepted solution
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 Accepted solution
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 Accepted solution
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.
Trending Windows Forum posts
Sort by Trending