- Mount Points created in ASM:
Visible through the user GRID and the ASM tool.
NOTE: not usual UNIX filesystems
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 25557 25505 0 25505 0 N ARCH/
MOUNTED EXTERN N 512 4096 1048576 66519 64931 0 64931 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 10197 10145 0 10145 0 N REDO/
So now the problem:
I will run a script that will create a bunch of tablespaces - among other things - for DPDB (script wasnt set for ASM use).
So I have to run these TS manually.
Basically a appl will have to access the tables inside these tablespaces using the DPDB.. but Im not sure how to create then for ASM...
I read this:
'You need to create your diskgroups in ASM, then create your tablespaces in the ASM diskgroup.
If you setup the instance with db_create_file_dest = ‘+<DISKGROUP>’ then you can simply do “create tablespace <TBLSPACE_NAME>;” '
Would it be the right way to do it? How could I create these diskgroups in ASM? This variable is necessary?
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
How to Create User-Defined Aggregates in Oracle
Before we begin creating these things, what are user-defined aggregates? They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE