Tagged Questions
0
votes
1answer
68 views
Logging and saving user activity
Database:Oracle 11gR2
OS: Windows 2008 Server R2
I'm not trained DBA, just have to run things on an Oracle database temporarily, which is used to perform OLAP processes.
I need to automatize user ...
1
vote
1answer
72 views
Unable to start Oracle Database Server : Get an error as I try to start it
I just installed Oracle Database Express Edition 11g Release 2 for windows.It created a short cut icon on the desktop :
but as I click this icon I see this dialog box :
What is it ? How do I ...
1
vote
2answers
132 views
Why Oracle 11g installs in folder C:\app\<name_of_user>
Just curious, now Oracle 11g installs by default in folder C:\app\
Why? Before, Oracle was installed by default in folder C:\oracle... Why now is created "app" folder?
0
votes
1answer
516 views
Error when installing Oracle 11.2.0.3 in Windows Server 2008 R2 64 bits
I downloaded Oracle 11.2.0.3 installer:
p10404530_112030_MSWIN-x86-64_1of7.zip
p10404530_112030_MSWIN-x86-64_2of7.zip
p10404530_112030_MSWIN-x86-64_3of7.zip
p10404530_112030_MSWIN-x86-64_4of7.zip
...
1
vote
0answers
223 views
Restoring Oracle prod backup to test server with new database name
I need to restore an Oracle production database (aaprod) to a test server that already is home to a test database (aatest) under a new name (bbtest). I have a cold backup of the production database
...
2
votes
0answers
188 views
Ports necessary for Oracle 11g Replication across a firewall?
We have two Oracle 11g Enterprise Edition servers that need to replicate data via Oracle streams. However, the two servers are on untrusted domains and connect via a VPN. On end of the connection is ...
2
votes
1answer
1k views
How do I create a database+tablespace+user in Oracle 11gR2?
Good evening,
I'm trying to figure out how to create a database+tablespace+user in Oracle 11g.
I've tried some tutorials, but nothing seems to work.
I cannot find Database Configuration Assistant ...
5
votes
1answer
576 views
Case Behavior Changed Between 11.2.0.1 and 11.2.0.2
I have a case open with Oracle and they say they can't reproduce this. Running the following in 11.2.0.1 or lower produces two rows from both of these queries, but in 11.2.0.2 the second query ...
5
votes
3answers
643 views
How can a datapump export have its resource usage limited on windows?
Doing an export of a number of users causes high CPU and I/O usage. I can mitigate the effects of the CPU usage using Resource Manager and setting the export session to a low priority group, but how ...
