jmk
  • Member for 8 years
  • Last seen more than a week ago
  • NDS, Germany
Will exporting tables in one db server to another db server release space in server?
1 votes

Short answer: probaply not. Longer answer: It depends. If they have their own tablespace and you drop the tablespace also, then yes. If your test tables are in a tablespace that holds other data and ...

View answer
Oracle 9i to 12c Replication
1 votes

Please consult the Oracle Update and Migration Guide There is no direct upgrade path, for your data a export/import might work. Your old Forms application will not work, Oracle 10.1 was the last ...

View answer
Need to choose ASM performance for production database
0 votes

I think you should read the Oracle Admin Guide. One of the points there: The number of LUNs (Oracle ASM disks) for each disk group should be at least equal to four times the number of active I/O ...

View answer
Would installing 32 bit packages on the existing 64-bit VM be an option to run Oracle 9.2?
2 votes

It is possible, I had to do it myself once. BUT: It is not enough to just to install 64 bit packages on any new linux distribution. You need a supported version (that is supported by 9.2). just ...

View answer
Restore or reset Oracle database (No Flashback features)
0 votes

If takeing a rman backup, remember that is has to be an offline backup. Expdp/impdp is an option only if your data is not too big. You could do filesystem/VM snapshoting depending on your environment. ...

View answer
Common practices to determine what database technology to use
1 votes

Adding a no-answer as I don't know of a formal method for choosing a database architecture (remember you buy a architecture with special backup requirement, HA feature, hardware requirements). ...

View answer
Is it a bad backup strategy in Oracle to have only Level 0 backups and Archive Logs in between with no incremental?
1 votes

The most important question is: Why are the backups done the way they are done? Are there special reasons for takeing full backups every six hours? You can do - depending on your database edition - ...

View answer
Oracle Client sessions keep disconnecting
0 votes

In addition to Dave's answer: Speaking of DCD, with 12c the DCD mechanism changed and does not use SQL*Net probes anymore. Our application aware firewalls were not able to detect the connections ...

View answer
Copying Oracle datafiles to a system clone
Accepted answer
1 votes

Of course you can, if you can cleanly shut down your old database and it is consistent. A little reading of the documentation or googele-fu would have helped. Searching this site would have provided ...

View answer
/oracle is 91% what to delete?
Accepted answer
1 votes

Assuming that you have a recent (>11.2) release of Oracle, my bet is the diag destination usually located in $ORACLE_BASE/diag. Database logs are kept in the rdbms/$DATABASE/$INSTANCE directories, ...

View answer
How to connect from local computer (mac) to remote Oracle DB and execute script and save results to CSV?
0 votes

In addition to Balazs‘ answer you might want to try the newer SQL shell sqlcl available on the Oracle sqldeveloper website. With this tool you have a lot of output options including CSV and Shell ...

View answer
Knowing if Oracle account has been locked?
1 votes

If you don't have admin rights you probably won't be able to troubleshoot the issue without your DBAs. Some hints for troubleshooting (again, with your DBAs) If the user is locked after some time (...

View answer
Oracle 11gR2 Installation on Oracle linux 7 - Prerequisite condition failed for OS kernel parameter "semmni"
1 votes

One point you should be aware of is that in Oracle Linux 7 (or redhat for that matter) you don't only have a sysctl.conf but a directory /etc/sysctl.d with various configuration files (depending on ...

View answer
Audit kernel module usage in Oracle
1 votes

I don't think this question can be answered without further details but some general thoughts: What kernel are you talking about? If it's the OS Kernel then there are a few different ways depending ...

View answer
Query not showing in dba_hist_active_sess_history
Accepted answer
2 votes

Afer checking that you are indeed on the correct database and if ASH- and AWR reports for both instances don't show any long running queries it's time to get in touch with your application developers. ...

View answer
Getting an error when trying to start the database (end-of-file on communication channel)
1 votes

If your database is in archive log mode and you don't need it, disable it. This prevents that archive logs are written. Check with archive log list. If Automatic archival ist enabled, and you don't ...

View answer
How can I free space in oracle mount point (/u01/app/oracle/)?
Accepted answer
3 votes

If your oracle installation is on your root volume you should have a look at the DIAG_DESTINATION, e.g. /u01/app/oracle/diag/. If there's a lot of old trace files in there you can safely remove them ...

View answer
Oracle RAC Maintenance
1 votes

It is actual quite easy if you are obvious of some caveats: configure your services to run on one node only: srvctl modify service -db $DATABASE -service $SERVICENAME -preferred $INSTANCE1 -available ...

View answer
Oracle Online Patching -- How To Exclude Tables in a Custom Schema
1 votes

@Jeff As your database is 12c, you can query dba_objectes and check the the oracle_maintained column, e.g. select OWNER, OBJECT_NAME, OBJECT_TYPE, STATUS, ORACLE_MAINTAINED from dba_objects where ...

View answer
Oracle Database Remote Connection
1 votes

Your connection string is wrong. With easy connect you need to provide a hostname and servicename/SID. In your case you would provide sqlplus user/"SomePass"@HOSTNAME:$PORT/servicename If you want to ...

View answer
Could we delete old database and grid version?
Accepted answer
0 votes

Oracle provides a deinstallation tool starting with Oracle 11. It's located in $ORACLE_HOME/deinstall/ (in your case the old Homes). It takes care of the inventory and remote hosts in case of a RAC....

View answer
How to retrieve Oracle Key Performance Indicators in 5 minute intervals within a time range
0 votes

Your best shot without any fancy licenses or third-party tools would be STATSPACK/PERFSTAT. It comes with you Oracle Installation, the documentation can be found in $ORACLE_HOME/rdbms/admin/spdoc....

View answer
how to check whether Oracle database is accessed or not?
1 votes

If you don't have any database internal mechanisms like auditing in place, you could also look at the listener log. You can even search it via SQL if you use it as external table – Have a look at The ...

View answer
Oracle 11g not allowing to connect to. Error ORA-01122: database file 1 failed verification check
1 votes

Did you do anything like renaming datafiles or moving them around in the filesytem? The ORA-01122 indicates that the information in the controlfile does not match your environment. So if you do a ...

View answer
Discover the original OS of a datafile from a oracle backup
0 votes

[Can some moderator please make this answer a comment to Balazs Papp`s answer?] I'm not sure if the above solution works across different endianesses. I tried to copy a cold backup of a 64bit SPARC ...

View answer
How do I tell the actual IOPS used by Oracle?
1 votes

There is no short answer to this question, the ways to monitor the behavior of an Oracle database depend on the tools available, your database edition, your database version, do you use ASM or a ...

View answer
Oracle SQL Developer 4: how to tell under which user I connected
1 votes

You can check your environment with a statement like SELECT username, osuser, machine, schemaname FROM gv$session WHERE sid= ( SELECT sys_context('userenv','sid') FROM dual ); Without ...

View answer
How to use Oracle Installation Prerequisites on Redhat Linux 6.5?
0 votes

As said before the package is for Oracle Linux. Main point is, it depends on the UEK kernel, not on the stock kernel. Either you resolve the dependencies manually or have a look at the blog entry on ...

View answer
Identify in details the consumption of memory from a specific session
2 votes

You could check which statement is executed and what it does. Way to go is to get SQL_ID from v$session and join it with v$sqlstats. You can use DBMS_XPLAN to check the execution plan of your ...

View answer
Help about Oracle licensing
0 votes

First thing to do is to determine what kind of the above licences do you really need. Based on the features you need you can determine what kind of licence fits you best. In short: NUPs if you have ...

View answer