Tag Info

New answers tagged

0

I found correctly solution. you need to do some steps: Step 1. Create user Scott with pass tiger create user scott IDENTIFIED by tiger; grant dba to scott; grant coneect to scott; Run above codes on sql plus to avoid restrict of oracle( not Run on administation tool) Step 2. Download scott database from link: ...


2

That is the Oracle Cluster Registry (OCR) where information about clusterware components is stored. http://docs.oracle.com/cd/E11882_01/rac.112/e41959/intro.htm#CWADD90952 Its size is 256 MB, or 0.26GB, you can check this with ocrcheck: # ocrcheck Status of Oracle Cluster Registry is as follows : Version : 3 ...


0

You could try following this http://www.oracle-base.com/articles/misc/manual-oracle-uninstall.php guide. Worked for me in the past (sometimes). Other than that you, if you have access to the computer running the DB you could try checking the logs there (see 2nd post https://community.oracle.com/thread/913826) if there is anything going in from your pc. ...


0

Your plan of adding three datafiles on different mounts will not work well. Oracle doesn't stripe optimally within tablespaces. It just allocates extents in a reasonably efficient manner. The method you suggested is striped better than one disk, but it's not even close to optimal. Basically, you can't have really good striping without ASM or an external disk ...


5

Several things might be going on here and might be difficult to pin down but here's a few things. After Oracle crashes, it must do some type of recovery (as in media or crash recovery) to bring the database back to a consistent state. Depending on what you were doing (and whatever else was going on in the instance at the time of the crash) transactions may ...


2

Is this a permanent condition? Or a temporary one? My first guess is that if you crashed midway through the load, Oracle has to go through the instance recovery process once the system comes back up. Part of that will involve undoing the transaction that was in progress when the system crashed. That, in turn, will involve reading the UNDO vector and ...


2

Oracle by default does not cache query and function result, but both cache do exist. http://www.oracle.com/technetwork/articles/sql/11g-caching-pooling-088320.html The importance of these: there is more than caching blocks. Even if you process everything in memory, why process the same requests again and again, if you already know the answer? What you are ...


1

There is no "result cache". There is the database buffer cache. Oracle stores recently-accessed data blocks in memory so that it doesn't have to go to disk every time for hot blocks - those chunks of data which are most frequently accessed. Function and query results are not stored, only the data blocks which are in demand. See here: ...


0

Thank you very much - I found the solution. First, the output encoding of the Oracle command line tools can be controlled by either the NLS_LANG environment variable (in my situation, a value of GERMAN_GERMANY.AL32UTF8 was needed) or through the registry by the key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\NLS_LANG Thank you very much for all - I leave this ...


2

See the disk status of "Member"? These disks are already part of an ASM disk group and cannot be added to another. You need to drop those disks from your existing diskgroup (or drop the diskgroup).


1

You should check if it is not a ownership issue. The disks should be owned by Oracle. A common workaround to this issue is to delete and recreate the disks from scratch.


1

For that purpose you can download the pre-built virtual Machines (VMs) provided by Oracle. They only need Oracle Virtual Box in order to check them out (https://www.virtualbox.org/wiki/Downloads). You can download them here: http://www.oracle.com/technetwork/community/developer-vm/index.html This is the best solution for learning Oracle DB, without ...


2

No, it can not be done, because 00:00 is a valid time. That you use it to represent "no time available" in your application is your own decision and you have to take care of the consequences yourself. You could store date and time in separate columns and show only the date if the time is NULL.


1

I am fairly sure this can't be done. You have to explicitly change the date format if you want it to change conditionally. There is no date format that does what you want out of the box.


0

Your options are function based indexes, virtual columns(if you are using 11g version), triggers, application changes... But there is no simple switch to accomplish what you want.


0

Use a unique function-based index: CREATE UNIQUE INDEX countryname_unique ON country (LOWER(countryname)); Much better than messing with collations.


0

You have lots of different options for doing this: http://docs.oracle.com/cd/B25329_01/doc/admin.102/b25107/impexp.htm I would recommend using Oracle Datapump as this is the most powerful solution, and would represent the best opportunity for instruction on how this is done in an enterprise environment.


1

You most likely need to set the ORACLE_SID environment variable. This error usually means you are trying to connect to a database that doesn't exist. Also check that ORACLE_HOME is set correctly. If that doesn't fix it, check if the database service is started. If it is, check the alert log for error messages.


0

Physical: "Differences between the primary server(s) and the standby server(s) are always supported as long as the Oracle software installed on all servers is of the same Oracle Platform as defined above, is certified to run on each server, and is the same Oracle Database Release and Patch Set." Logical: "Differences between the primary server(s) and the ...


1

Get all privileges from AAA SELECT DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT','AAA') FROM DUAL; SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','AAA') FROM DUAL; SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','AAA') FROM DUAL; Change the DDL commands with the user 'BBB' and execute.


1

expdp userid=system directory=DATA_PUMP_DIR dumpfile=AAA.dmp schemas=AAA impdp userid=system directory=DATA_PUMP_DIR dumpfile=AAA.dmp remap_schema=AAA:BBB or make use of dbms_metadata user_ddl.sql


1

you should review your query, missing s.sid = sl.sid. Besides, wher yout lokk at v$session_longops and find many rows, they all meet the other conditions - sl.elapsed_seconds > 25*60 and sofar<>totalwork ?



Top 50 recent answers are included