Questions tagged [oracle9i]

The tag has no usage guidance.

6 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
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....
1
vote
1answer
242 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 ...
0
votes
0answers
264 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 ...
0
votes
1answer
233 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 ...
0
votes
1answer
224 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 ...
0
votes
1answer
41 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 ...