The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
39 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 ...
2
votes
1answer
548 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 ...
0
votes
1answer
366 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
168 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
153 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
487 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 ...
0
votes
1answer
167 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 ...
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
127 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. ...
1
vote
1answer
451 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 ...
0
votes
1answer
159 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.
2
votes
1answer
465 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
1answer
669 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 ...
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
422 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: ...
0
votes
1answer
380 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 ...