Questions tagged [oracle9i]
The oracle9i tag has no usage guidance.
6
questions with no upvoted or accepted answers
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
255
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
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
245
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
243
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
90
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