Tag Info

New answers tagged

1

Datapump is one answer. Look at http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_export.htm#i1007524 - specifically "Transportable Table mode". Moves the metadata, but not the data. You can choose which schemas to include with the SCHEMAS switch, along with the INCLUDE/EXCLUDE parameters.


0

You may need to reset the "dbsnmp" user's password from the database. Then update the password of dbsnmp user in OEM: Targets --> Select database and press "Configure".


1

You may need to resecure the agent. Here is a link that should help. http://jhdba.wordpress.com/2008/12/10/clearing-an-enterprise-manager-agent-that-fails-to-upload/


1

Oracle might be binary, but it will still initiate system commands which in term could involve shells. On UNIX systems, the ulimit command controls the limits on system resource, such as process data size, process virtual memory, and process file size. It is also mostly the users processes affect parent processes. So the parent processes manage the users. ...


0

If the Universal Installer included with 11gR2 did not ask for a password, it is likely that the option to create a database was not selected during installation. Solution? Create a database with the dbca tool and supply a sys password when prompted. With older versions, perhaps including Oracle Database XE (11g), you might have luck with one of the ...


0

Oracle here warn you from dropping datafile because it contain amount of data, to make sure the datafile is completely empty please execute the following command col tablespace_name format A30 heading tablespace col file_name format A40 col tot_KB format 99,999,999 col tot_freeKB format 9,999,999 col Kb_max format 9,999,999 select f.tablespace_name ...


0

It's the moment of the last redolog archival, before some point in time during the RMAN duplicate command. You can test this easily, if you either manually provoke redolog switches (and thus subsequent archivals), or even better: write some script to provoke very frequent and unnecessary redolog switches. In which you perform some insert/update/delete, to ...


0

It COULD be simple, but then it's down to luck, more than to anything else. The way of working is very simple : get all processes listed of the main database, ignore the ones from the standby. Then, do the same with the standby database : collect all process info. What is important here, is that you capture this while all is normal. Then you compare both ...


1

Ok, so I had some time to waste, and this is just for the "fun" or "interesting" factor. It's nowhere near that I would use in a real scenario, I have played with it in my lab environment on x86-64 Linux platform, with a few 10g, 11g and 12c databases. At least you can do this even if the database is shut down. When you do a controlfile dump with: alter ...


2

You can try using: ps -ef | grep -v grep | grep ora_pr Or if data guard is in use: ps -ef | grep -v grep | grep ora_rsm


0

I would move the old records (closed incidents) to another table, not to another partition in the same table. Why ? Because if there is a LOGICAL reason, in my mind it makes more sense to put them as much seperate as possible, on a physical level. Consider this : you can store incidents, but your data schema can also store "open incidents" and "closed ...


0

Definately, exporting that many rows to a tool like Excel, sounds like the worst solution to what sounds like a normal action. This being : updating data. In the opening post, I don't see any reason why the data has to leave the Oracle database. Certainly not to a tool like Excel.


5

A Fast Method A probably faster way to do this is the following: Provide the data in a database table Execute a MERGE statement that merges the data from this table into the source table To provide the data in a database table you can use sql loader or [external tables]. http://docs.oracle.com/database/121/SQLRF/statements_9016.htm#SQLRF01606 create ...


1

Instead of thousands of updates, you could insert the data into temporary source table and then run merge against the target table. merge into target_table t using source_table s on (t.id = s.id) when matched then update set t.column1 = s.column1, t.column2 = s.column2, ...;


2

You should be fine; the rowid would be a show-stopper if you were using it Temporarily, there would be "holes" in the data files, but Oracle will fill them in without any intervention. Ensure you have automatic tablespace management enabled. You can invoke that command but no need to; let Oracle take care of it The person that stated that probably meant ...


0

RMAN allows you to either try to fix the file (recover) or to recreate the file (restore). Before you give up (if ever), you should be at least trying both of these options.


1

The size needed in a temporary tablespace depends on the data volume manipulated, but including potentially other actions also requiring temporary space. What you should be doing is this : monitor temporary tablespace usage, (temporarily) expand the temporary tablespace. Maybe, you need to recreate your temp tablespace. That is, if there is corruption of ...


0

I do not have any clear explanation for this problem solution. However I used SID instead of service name in connection string and it worked.


0

connect / as sysdba SQL>SHUTDOWN Go to folder oracle home\flash_recovery_area\YourDatabaseName rename the file CONTROL02.ctl to CONTROL01.ctl and Copy it to folder oracle home\oradata\YourDatabaseName CONNECT / AS SYSDBA STARTUP


3

Yes, that's fine: All software downloads are free, and most come with a Developer License that allows you to use full versions of the products at no charge while developing and prototyping your applications, or for strictly self-educational purposes. The full Developer License can also be found on OTN, including: Oracle grants You a nonexclusive, ...


0

The issue could be because of remote location of Oracle Installer. Copy the installer into location drive and run the installer as Administrator should resolve the issue.


0

It is possible to check if an index using a number of columns exists. WITH index_cols AS ( SELECT table_name, index_name, COLLECT(column_name) AS column_names FROM all_ind_columns WHERE table_name = '&table_name' GROUP BY table_name, index_name ), ...


2

To answer some of your questions, firstly read this: http://www.oracle.com/technetwork/indexes/downloads/index.html and this http://www.oracle.com/technetwork/licenses/standard-license-152015.html. These are your licencing restrictions. All the manuals are available here: http://docs.oracle.com/cd/E11882_01/index.htm. Read the installation guide, ...


3

Maybe those files are not cataloged by RMAN? I would CATALOG them and then DELETE OBSOLETE once again.


2

Most of your questions are covered in official documentation. http://docs.oracle.com/cd/E11882_01/nav/portal_11.htm Read the installation guide (NOT the "quick installation" one). I don't recommend using "pre-built" virtual machines - try to install OS and db from scratch. The process is the same as installing on "real" hardware. Use CentOS as mentioned in ...


0

I found the answer myself after reading through loads of documentation from Oracle. The answer comes in two parts. First, my original question can be solved by using XMLTable: SELECT x.ID AS "MEASUREMENT_ID", x.GUID AS "MEASUREMENT_GUID", a.COLUMN_VALUE AS "MESSAGE" FROM SPERF_XML_RAW x, ...


-1

if you have administrator permission, after entering "sqlplus sys as sysdba" command press the enter. and press the Enter again for password will let you query the database ! and then you can change the password for sys from $ Tables. hope this help


1

@mbonaci sqlplus / as sysdba then issue command startup; to start the database Also on Linux with this error, you can check first if Oracle background processes are up with ps aux | grep pmon. Pmon is process monitor, or check some other background process. If they are not running then the database is not running.


1

The lazy answer: You can use the Segment Advisor recomendations. Can be viewed in OEM, DBA_ADVISOR_RECOMMENDATIONS, o DBMS_SPACE.ASA_RECOMMENDATIONS procedure. https://docs.oracle.com/cd/E18283_01/server.112/e17120/schema003.htm You can also build your own script gathering data, joining, and do calcs from several storage related dictionary views, but, ...



Top 50 recent answers are included