0
votes
1answer
322 views

Cannot open oracle 9i database: ORA-16038: log 4 sequence# 1781 cannot be archived

my server was unexpectedly rebooted. after the server boot up I received the following error when trying to start up the database: ORA-16038: log 4 sequence# 1781 cannot be archived ORA-19504: ...
0
votes
1answer
165 views

“Oracle initialization or shut down in progress” problem

I installed oracle 9i before 20 days, it was working fine till now but now when i try to login from scott user with correct password it is giving oracle initialization or shut down in progress error ...
1
vote
1answer
151 views

Alternative for OPTIMIZER_FEATURES_ENABLE

I've installed a PHP driven application in a client's 9i server (Oracle9i Release 9.2.0.1.0 - 64bit Production). Certain queries are having an awful performance (it can use from 15 minutes to hours ...
1
vote
1answer
448 views

How to change OPTIMIZER_FEATURES_ENABLE in Oracle 9i

I want to change the OPTIMIZER_FEATURES_ENABLE parameter in a local installation of Oracle 9i (32bit 9.2.0.1.0 Enterprise Edition running on Windows Server 2003) in an attempt to reproduce a ...
3
votes
4answers
3k views

How to delete data and free up disk space in Oracle DBMS 9i

I would like to know how usually one would delete data from an Oracle 9i DBMS which actually frees up disc space. Past scenario, we have had cases where clearing up 1-2 million rows of data does not ...
2
votes
1answer
4k views

how modify username in oracle

I create a username in oracle that has spelling mistake, I want to modify it now but I am not successful. would you please help me how I can modify my username in all_users table? I use oracle 9.
2
votes
3answers
126 views

Oracle Move from 9 to 11

I have an oracle 9 database. There is a requirement to move this to Oracle 11. What is the best way to achieve this. Is it enough to export the database on 9 and import it again on 11 or is there an ...
0
votes
3answers
5k views

How to move Oracle database to another PC without restoring backup?

Take this scenario: Suppose the customer has no backup of Oracle 9i or 10g database. The customer wants to move the database from one PC to another. The other PC has a fresh installation of Oracle. ...
2
votes
1answer
452 views

Difference between IDENTIFIED EXTERNALLY and IDENTIFIED GLOBALLY in Oracle

What's meaning of IDENTIFIED EXTERNALLY and IDENTIFIED GLOBALLY respectively? I'm now puzzled by their concepts. Thanks in advance. Kind regards!
1
vote
2answers
101 views

Single Oracle Session For Data Export

What is the standard way of only allowing a single login during an Oracle 9i database export to prevent others from modifying the database during or after the export?
1
vote
5answers
6k views

Open source scripts for Oracle health check?

I want to put together some scripts to run an automated health check of Oracle 9i and 10g databases. Before I start from scratch, I was wondering if anyone know of any available open source scripts ...
1
vote
2answers
411 views

Oracle9i export error

When I rut the following: set ORACLE_SID=orcl exp.exe 'SYS/system as sysdba' full=y log=exp.log file=mydump.dmp in the end i see the following: EXP-00056: ORACLE error 942 encountered ORA-00942: ...