Questions tagged [oracle9i]
The oracle9i tag has no usage guidance.
24
questions
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
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
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
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
1
answer
2k
views
What's in the rdbms folder of my oracle database?
I have here a database which should be quiet small. There should be around 350.000 lines of textonly data but the rdbms folder is around 50 GB. Seems way too huge to me.
I found in the rdbms folder a ...
- 333
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?
2
votes
1
answer
2k
views
connect-to-oracle-db-9i server-using-ssh-tunnel-via-putty
I am trying to connect ORACLE DB behind NAT so i choose SSH TUNNEL via putty so here is the information
Global i p example: 122.54.34.12
LAN i p example : 192.168.3.103
ORACLE DB_PORT : 1521
and ...
- 21
2
votes
1
answer
743
views
Oracle 9i Session Disconnections
I am in a development environment, and our test Oracle 9i server has been misbehaving for a few days now. What happens is that we have our JDBC connections disconnecting after a few successful ...
- 173
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
1
vote
2
answers
143
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,476
1
vote
2
answers
669
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
1
vote
0
answers
3k
views
Slower response to AIX Virtual IP
Server_A is an AIX 5.3 server assigned 192.168.1.8.
TNS Ping to it's Oracle 9i DB instance was 120 msec.
A month later, Server_B with identical specs was built assigned 192.168.1.9.
Virtual IP 192....
- 71
1
vote
1
answer
259
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
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
0
votes
1
answer
280
views
equivelant tool in oracle 11g to the Oracle Enterprise manager (OEM) that came with oracle 9i?
Is there equivelant tool in oracle 11g to the Oracle Enterprise manager (OEM) that came with oracle 9i?
pointers on where to download/install/access would be greatly appreciated.
- 1,381
0
votes
1
answer
141
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
584
views
Are there any issues in applying Oracle 9.2.0.8.0 patch set on Windows 2003 server?
I'm going to apply an Oracle 9.2.0.8.0 patch to an existing 9.2.0.7.0. The server has Windows 2003 Enterprise Edition SP1.
Are there any issues/problems you encountered after applying this 9.2.0.8.0 ...
0
votes
0
answers
32
views
which Linux operating system will go for long term usage [duplicate]
Looking replacement of centos7
centos7 will expire on 30Th June 2024. so I am looking alternative like RHEL9. I dont know why, but rhel usage is low?
0
votes
0
answers
289
views
AWE memory configuration
I am configuring Oracle 9i to make use of AWE memory configuration on Windows 32-bit.
I am facing error
ORA-27102: out of memory
OSD-00022: Message 22 not found; product=RDBMS; facility=SOSD
...
- 101
0
votes
1
answer
247
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
0
votes
1
answer
244
views
Linked SQL Server to Oracle
Getting this error when executing SQL Server query only when connected via remote Desktop.
When running the query from desktop, no problem. Is this a tsnNames issue?
Linked server to Oracle 9i
...
- 1
0
votes
1
answer
106
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
778
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