| ORA-01219: database not open: queries allowed on fixed tables/views only [message #75618] |
Mon, 14 February 2005 01:51  |
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 #75620 is a reply to message #75619] |
Wed, 16 February 2005 00:20  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
