0
votes
0answers
4 views

ORA-01219: database not open: queries allowed on fixed tables/views only [migrated]

I Am using oracle 11g and SQL developer tool. When i tried to retrieve rows from db i am getting error message as :- ORA-01219: database not open: queries allowed on fixed tables/views only) I looked ...
0
votes
1answer
108 views

Oracle Linux 6 download files?

I want to download Oracle Linux 6 for basic use to install on my laptop to use oracle 11g r2 database since this is one of only few linux distros which is supported. When I go to the downloads section ...
0
votes
1answer
208 views

Cannot connect to oracle

While trying to connect to the oracle from my application(Windows). I am getting this error. Cannot connect to ORACLE: -1 : 0 The server used is Oracle 11g and the client is also Oracle 11g
0
votes
1answer
647 views

how to permanently set hostname for sqlplus?

I have the following situation: a windows 7, 64-bit OS; in which I have an Oracle 10g setup; on top of Win 7 - XP Mode; in which I have Oracle 11 client. As I try to connect to the Oracle ...
1
vote
1answer
357 views

Oracle - strange behavior - why?

I had to setup an Oracle environment. The stage is as follows: there are Oracle 11.2 client and 10g express server, the OS is Windows 7, 64-bit. I have the ORACLE_HOME, ORACLE_SID and PATH env. ...
1
vote
1answer
3k views

How can I connect to an Oracle database through a shell script?

I have tried to connect to an Oracle database using the below command: sqlplus -s LOGIN/PASSSWD@SERVERNAME:ORA_PORT/SERVICE_NAME However I couldn't connect. It was throwing the following error: ...
1
vote
3answers
13k views

OS X Lion - Installing Oracle 10g Standard Edition

Im trying to install oracle 10g on to OS X Lion, I have previous achieved this on snow leopard with the following ...
0
votes
2answers
7k views

Oracle 10g Client for Windows 7?

I downloaded the Oracle 10g Client Release 2 from this link, the one that says it is compatible with Vista, Windows Server, and Windows 7. However, when I run the installer, it says that the ...