Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [oracle9i]

23 questions
3
votes
1 answer

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!
Summer_More_More_Tea
  • 153
  • 2
  • 2
  • 7
2
votes
1 answer

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 here is putty ssh tunnel settings L1521 …
zak
  • 21
  • 2
2
votes
4 answers

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 translate to a decrement in disc space…
Oh Chin Boon
  • 225
  • 1
  • 4
  • 9
2
votes
1 answer

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.
Amir
  • 143
  • 1
  • 9
2
votes
3 answers

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 upgrade process that can be gone through?
AJM
  • 179
  • 4
2
votes
1 answer

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 couple of folders (around 60 Mb) and 17.000 files…
wurlog
  • 333
  • 1
  • 4
  • 17
2
votes
1 answer

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?
Summer_More_More_Tea
  • 153
  • 2
  • 2
  • 7
2
votes
1 answer

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 connections. We got this box set up by our IT department…
malaverdiere
  • 173
  • 1
  • 2
  • 6
1
vote
0 answers

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.168.1.10 added to Server_A for "High Availability"…
Dave M
  • 71
  • 2
  • 11
1
vote
5 answers

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 that I could use as a base for this project.
Roy
  • 4,376
  • 4
  • 36
  • 53
1
vote
2 answers

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: table or view does not exist EXP-00000: Export…
Max
  • 23
  • 4
1
vote
1 answer

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 just to calculate the execution plan!) and I've…
Álvaro González
  • 245
  • 3
  • 7
  • 25
1
vote
1 answer

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 performance issue reported by a client but I can't figure…
Álvaro González
  • 245
  • 3
  • 7
  • 25
1
vote
2 answers

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?
Steven
  • 175
  • 2
  • 10
0
votes
1 answer

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 need to do a full export. From what I understand, a…
sambomartin
  • 151
  • 1
  • 2
  • 12
1
2