Solution that worked for me. SQL> shutdown immediate ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 530288640 bytes Fixed Size 2131120 bytes Variable Size 310381392 bytes Database Buffers Continue reading… ORA-01194: file 1 needs more recovery to be consistent
Category: Oracle Tech
ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM
Recently I’m stuck with this error suddenly while writing data to this Oracle XE edition. Of course, it’s kind of frustrating to see this kind of errors in the middle of our tasks without even knowing the origin of these.Continue reading… ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM
SQL Loader: Import CSV to Oracle table
One of the very common task in oracle environment is export/import of CSV files to Oracle database. Export is pretty straight forward as many of oracle clients provide this as standard functionality for any query. But for import, we canContinue reading… SQL Loader: Import CSV to Oracle table
java.sql.SQLException: Non supported SQL92 token at position: 1
Seems like this is very common error in pl/sql programming. I know there are many last minute frustrations just because of this error which is no where related to any logic. This seems to be some format error in theContinue reading… java.sql.SQLException: Non supported SQL92 token at position: 1
Common BPEL Errors
Few common errors in BPEL of Oracle SOA suite are: 1. No domain available for the current user This occurs due to failure to contact Olite database instance while loading SOA suite in the system. As this db has theContinue reading… Common BPEL Errors
Adding new responsibility to an user
Choose the responsibility as System Administrator, 1. Navigate to Security -> User -> Define. 2. Search for the user for which you want to add new responsibility. 3. Bottom page shows the current responsibilities attached to current user. There youContinue reading… Adding new responsibility to an user