Home » Server Options » Replication » ORA-01219: database not open: queries allowed on fixed tables/views only
ORA-01219: database not open: queries allowed on fixed tables/views only [message #75618] Mon, 14 February 2005 01:51 Go to next message
Sohaib
Messages: 2
Registered: February 2005
Junior Member
I did Oracle 9.2.0.1.0 configuration with PlantSpace Design Series and it was configured successfully. After the configuration was done, the Design Series could be properly launched in the Oracle 9 project. But, when I restarted my machine, the Design Series was no longer able to be launched in the Oracle 9 project and prompted "Failed to connect to project database". Also, a message was prompted in Oracle Enterprise Manager which stated "ORA-01219: database not open: queries allowed on fixed tables/views only". Can somebody give me a solution for this problem as all my assignments are pending because of this single problem. I have tried changing SQLNET.AUTHENTICATION_SERVICES= (NTS) to SQLNET.AUTHENTICATION_SERVICES= (NONE) in sqlnet.ora file but the problem still persists.
Re: ORA-01219: database not open: queries allowed on fixed tables/views only [message #75619 is a reply to message #75618] Tue, 15 February 2005 20:51 Go to previous messageGo to next message
Sreedhar Reddy
Messages: 55
Registered: January 2002
Member
Are you able to connect to sql plus,

if you are not able to connect or able to connect.

just connect as sys/pwd as sysdba

shutdown
startup

if any error occours, take the appropriate actions.

I had faced this type of problem earlier.
Re: ORA-01219: database not open: queries allowed on fixed tables/views only [message #75620 is a reply to message #75619] Wed, 16 February 2005 00:20 Go to previous messageGo to next message
Sohaib
Messages: 2
Registered: February 2005
Junior Member
Thanks Sreedhar for such a comprehensive reply. I wrote the following string in the User Name field:

sys/pwd @SID as sysdba

This way I got connected to SQL Plus successfully. Afterwards, the commands I issued and their response is given below.

SQL> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
ORA-01991: invalid password file 'C:oracleora92DATABASEPWDams9i.ORA'

Please let me know how to figure this problem out.
Re: ORA-01219: database not open: queries allowed on fixed tables/views only [message #75621 is a reply to message #75620] Wed, 16 February 2005 01:18 Go to previous message
Sreedhar Reddy
Messages: 55
Registered: January 2002
Member
Run command on command prompt :

orapwd file='C:oracleora92DATABASEPWDams9i.ORA' password=mypasswd
Shutdown the database (SQLPLUS> SHUTDOWN IMMEDIATE)
Edit the INIT.ORA file and ensure REMOTE_LOGIN_PASSWORDFILE=exclusive is set.
Startup the database (SQLPLUS> STARTUP)
Previous Topic: Materialized Views with Mapping table option
Next Topic: ORA-12801(Error signaled in parallel query server)
Goto Forum:
  


Current Time: Thu Mar 28 12:42:23 CDT 2024