All Questions
66
questions
0
votes
1
answer
158
views
Dockerfile Works Locally But Fails on EB (Elastic Beanstalk) Deploy (PHP 7.3 with OCI8 extension)
Good day, fellow developers!
I have been searching for 2 weeks now on how to install the OCI8 PHP extension on Elastic Beanstalk using .ebextensions but sadly I can't search for similar ones.
Before I ...
1
vote
0
answers
99
views
Export data from Oracle Lite 10gR1 odb file
I hope you can help me with this one. Years ago (2005) someone way before me set up a server with WinXP and a custom-written Java/Tomcat-whatever application for monitoring some sensors, the database ...
1
vote
1
answer
2k
views
How to export database from Oracle 10g
I'd like to export database with all the triggers, indexes, grants and user accounts from Oracle 10g database. Problem is I only have SYSDBA access to the server, so I can't access the servers files ...
0
votes
2
answers
1k
views
Oracle 10g queries very slow and CPU usage very high after applying patch
So I recently updated an Oracle Database 10g from 10.2.0.3.0 to 10.2.0.4.0, as advised by Oracle Support, due to stability issues (a known issue under some systems where the instance would freeze ...
2
votes
3
answers
463
views
Change local admin password. Impacts on Oracle and Citrix?
I need to change the local admin password on some Citrix and Oracle servers. These servers are in production.
Then we will start using a secure password procedure, and change them every X month.
...
4
votes
2
answers
49k
views
oracle lsnrctl TNS-12545: Connect failed because target host or object does not exist
I am trying to connect to my oracle database. I can't get the listener started. Here is what I have tried.
$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 20-JAN-2012 08:19:...
0
votes
1
answer
505
views
Where to create directory for importing over network link?
While using data pump import over network link in Oracle:
impdp test/test@db10g tables=SCOTT.EMP network_link=REMOTE_SCOTT
directory=TEST_DIR remap_schema=SCOTT:TEST
Where are we creating ...
1
vote
1
answer
112
views
How can I tell how my oracle databases configurations' differ?
I have two databases with the same data, running on the same physical server.
They are performing differently (one is twice as fast as the other).
I've compared the Initialization Parameters and ...
1
vote
0
answers
66
views
Equivalent of SQL Server trace for Oracle 10g?
I've got a bad code duplication problem where we cannot tell which versions of packages/procedures are being used. i.e. I have different packages with procedures of the same name and I need to be ...
4
votes
1
answer
1k
views
Are there any performance differences between Oracle Entreprise and Oracle Standard editions?
Someone has asserted to me that the reason why one database is performing better than another (50-100%) is because one has Enterprise Edition and the other has Standard Edition.
Given the same ...
0
votes
2
answers
4k
views
Oracle Data Pump - export from Enterprise Edition to Standard Edition
I am migrating from an Enterprise Edition of Oracle 10g to a Standard Edition of Oracle 10g and I was wondering if anyone has experience doing this. I've searched around and I can't really find a ...
3
votes
1
answer
2k
views
How to prevent remote login for SYS
Is it possible to prevent the remote logins for the SYS user? Oracle 10g.
1
vote
1
answer
548
views
Oracle Internet Directory implementation questions?
I got frustrated in managing the TNSNAMES.ORA for more than 300+ users using various Oracle DB versions 9i up to v11, usually I send email for all of the users to manually copy and update the TNSNAMES....
3
votes
2
answers
8k
views
How to diagnose frequent "500 Internal Server Error" on Oracle Apex
I have an Oracle 10g XE database running on OEL 5 on an Amazon EC2 instance. On it I run a public website (actually, 2 web sites) written in Oracle Application Express 4.0.1.
Most of the year, the ...
3
votes
1
answer
5k
views
what is causing oracle archive log files to be growing fast
in the last few days our Oracle DB has been generating a large amount of archive log files. How would I find out what DML activity has been causing such a spike in log file generation?