MrProgrammer
Programmer
Hi everyone,
I am faced with a complicated problem in recent days!
After handling many problems, I finally installed Oracle8 Server for Digital Unix (8.0.4) on my Digital Unix machine. Then I have created a database named TAH (its SID is also TAH). I created control files, redo logs, rollback segments, tablespaces etc. and configured a listener. Everything looks fine. the listener starts without error, database can also be mounted or opened without error. In other words, on local machine (Digital Unix) I can do anything well (such as creating tablespaces, tables, indexes; opening or closing database etc).
But here is the problem:
I want to connect to the database from a Windows XP machine on the same LAN using Net8 assistant. Even though I make the configuration correctly (correct IP address, correct port number, correct SID etc) I'm always getting "Oracle not available" message. Default logon settings is scott/tiger. I also try system/manager and sys/change_on_install options but nothing changes. On the other hand, I tried to connect using DBA studio (on windowsXP). In DBA Studio, I can login to oracle server.
(Both as system or sys user). But when I select the database option under instance group, the database state seems closed (shutdown) but I'm sure that the database is open. Anyway when I try to change the database state to "open", I'm getting "insufficient privileges" message eventhough I've logged on as DBA...
There is another Digital Unix machine and the same version of Oracle Server installed on that. I can connect to this second server from windows XP machine. Configuration parameters except from some particual ones (such as SID, listener name etc) are completely same..
What should I do in this situation.. Do you have any idea???
I am faced with a complicated problem in recent days!
After handling many problems, I finally installed Oracle8 Server for Digital Unix (8.0.4) on my Digital Unix machine. Then I have created a database named TAH (its SID is also TAH). I created control files, redo logs, rollback segments, tablespaces etc. and configured a listener. Everything looks fine. the listener starts without error, database can also be mounted or opened without error. In other words, on local machine (Digital Unix) I can do anything well (such as creating tablespaces, tables, indexes; opening or closing database etc).
But here is the problem:
I want to connect to the database from a Windows XP machine on the same LAN using Net8 assistant. Even though I make the configuration correctly (correct IP address, correct port number, correct SID etc) I'm always getting "Oracle not available" message. Default logon settings is scott/tiger. I also try system/manager and sys/change_on_install options but nothing changes. On the other hand, I tried to connect using DBA studio (on windowsXP). In DBA Studio, I can login to oracle server.
(Both as system or sys user). But when I select the database option under instance group, the database state seems closed (shutdown) but I'm sure that the database is open. Anyway when I try to change the database state to "open", I'm getting "insufficient privileges" message eventhough I've logged on as DBA...
There is another Digital Unix machine and the same version of Oracle Server installed on that. I can connect to this second server from windows XP machine. Configuration parameters except from some particual ones (such as SID, listener name etc) are completely same..
What should I do in this situation.. Do you have any idea???