All Questions
15
questions
0
votes
1
answer
109
views
Oracle RMAN full backup due to gaps in ARCHIVE LOGs
I've recently recovered a Data Guard configuration. Simple setup that syncs from primary to standby using Data Guard.
Because it's been on-line for a sustained period, some logs are missing and I ...
- 151
0
votes
1
answer
145
views
Oracle 9i - Data guard target DB - lost control files, can I recreate from primary database?
I'm dealing with a problem whereby a I have a database that is managed using data guard using Redo Apply, so redo logs are copied to the target database, applied and kept in sync ready for fail over.
...
- 151
0
votes
1
answer
785
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: ...
- 103
0
votes
1
answer
250
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 ...
- 101
1
vote
1
answer
260
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 ...
- 249
1
vote
1
answer
1k
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 ...
- 249
2
votes
4
answers
12k
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 ...
user66296
2
votes
1
answer
8k
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.
- 143
2
votes
3
answers
151
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 ...
- 179
0
votes
3
answers
9k
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.
...
- 215
3
votes
1
answer
1k
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!
2
votes
1
answer
11k
views
What's the difference between an instance and a server process in Oracle database?
What is the difference between an instance and a server process, and what are their respective lifecycles?
1
vote
2
answers
144
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?
- 193
1
vote
5
answers
7k
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 ...
- 4,486
1
vote
2
answers
670
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: ...
- 23