Tag Info

New answers tagged

1

The physical standby database must be physically the same as the primary database and this means the versions must be identical. A logical standby database can be any version, depending on how it is implemented. With 3rd party tools you can go from v10 to v12 and back. The restrictions here are on the data types that are to be replicated. If this is for an ...


1

when you are installing oracle database you can install all oracle example schemas like scott, HR, oe ... you can install these in step "Specify Database Config Details".click the last tab page "Sample Schemas" then check the check box "create database with sample schemas" as displayed bellow in screenshot. if you already installed database you can ...


-1

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 ...


-1

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.



Top 50 recent answers are included