Server Administration :: How To Get Disk List On Any DB Instance That Uses ASM Instance

Mar 16, 2011

My context on our servers is the following one:

- one ASM instance
- X DB instances
- each DB instance uses 2 or more dedicated diskgroups from the ASM instance
- there is one diskgroup named FREEDISK that contains spare disks

On each DB instance you can see:

- the list and global parameters of all diskgroups using v$asm_diskgroup view
- the list and parameters of all disks the instance is using with v$asm_disk view

So my question is: how (if this is possible) to know the list of (spare) disks in FREE DISK disk group?

View 6 Replies


ADVERTISEMENT

Server Administration :: Idle Instance?

Sep 8, 2013

[oracle@localhost /]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Sun Sep 8 19:10:30 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to an idle instance.
--------------------------------------
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '/home/oracle/app/oracle/product/11.2.0/dbhome_2/dbs/'
ORA-27037: unable to obtain file status
Additional information: 5

What seems to be a problem here? I've been trying to fix this for few weeks.

View 24 Replies View Related

Server Administration :: How To Create ASM Instance Using DBCA

Jul 15, 2010

I am learning to create an ASM (Automatic Storage Management) instance using dbca.

View 3 Replies View Related

Server Administration :: DBMS-SCHEDULER For Particular Instance?

Apr 29, 2013

How to create DBMS_SCHEDULER job for particular instance,we have 3 instance we want to schedule few jobs in Instance 2,how to schedule in Particular instance.

View 3 Replies View Related

Server Administration :: ASM Instance Did Not Access Raw Devices

Sep 28, 2011

I've to install Oracle 10g on Solaris 10, Sparc. I prepared anything successfully, but, when I gone to create ASM instance, I found the Create new bow did not show any disks into. I take brief something:

1- Sparc & disks preparation:

# isainfo
sparcv9 sparc
# ls -lL /dev/rdsk/c4t50060E800570B715d0s6
crw-rw---- 1 root sys 336, 14 Sep 28 14:08 /dev/rdsk/c4t50060E800570B715d0s6
# ls -lL /dev/rdsk/c4t50060E800570B715d2s6
crw-r----- 1 root sys 336, 62 Sep 28 14:09 /dev/rdsk/c4t50060E800570B715d2s6
# ls -lL /dev/rdsk/c4t50060E800570B715d3s6

[code]....

Those 6 partitions disks above were supplied to ASM, so, I make mknod to link them.

# ls -lrt /asmdisks
total 0
crw-r--r-- 1 oracle dba 336, 110 Sep 28 15:35 disk6
crw-r--r-- 1 oracle dba 336, 94 Sep 28 15:39 disk5
crw-r--r-- 1 oracle dba 336, 78 Sep 28 15:39 disk4
crw-r--r-- 1 oracle dba 336, 30 Sep 28 15:39 disk3
crw-r--r-- 1 oracle dba 336, 14 Sep 28 15:39 disk2
crw-r--r-- 1 oracle dba 336, 62 Sep 28 15:39 disk1

Well, I go to ASM, but And nothing on Available Disk Groups.

View 2 Replies View Related

Server Administration :: Connect To Idle Instance

May 11, 2011

Getting the below message even after doing the

oracle@ttlwaurd001:~$ ps -ef | grep pmon
oracle 7779 1 0 Feb08 ? 00:00:07 ora_pmon_WGRGOLD1
oracle 10155 1 0 Feb20 ? 00:30:48 ora_pmon_DPTLS01
oracle 12354 1 0 Feb20 ? 00:00:53 ora_pmon_DOEMS01
oracle 17902 1 0 Feb20 ? 00:00:13 ora_pmon_DREPS01
oracle 23745 23360 0 19:51 pts/4 00:00:00 grep pmon
oracle@ttlwaurd001:~$
oracle@ttlwaurd001:~$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.1.0 Production on Wed May 11 19:49:54 2011

Copyright 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.

oracle@ttlwaurd001:~$ echo $ORACLE_SID
DPTLS01

View 15 Replies View Related

Automatic Storage Management :: Diskgroup With Normal Redundancy One Disk Is Failed Then 2nd Instance Down

Mar 27, 2013

My cluster have two node.Data diskgroup uses normal redundancy.Priamry disks are located in one storage.Fail group disks are located in another storage.When we close the failgroup disks' storage the 2nd instance restart.After automatically restarted everything goes well.I want to know why does the 2nd instance restart?Is it normal?

View 2 Replies View Related

Server Administration :: Ora 01092 Oracle Instance Terminated

Jan 31, 2012

i got an error while creating database manually

View 26 Replies View Related

Server Administration :: To Configure New ASM Instance As Root User

Mar 2, 2013

I am trying to configure a new ASM instance. I am getting error " -bash: crsctl: command not found" .. where should i actually look for the error. crsctl command not found.... I am doing this as a root user .

View 5 Replies View Related

Data Guard :: Possible To Use Dataguard From Single Instance To RAC Instance?

Jul 1, 2010

Is it possible to use oracle dataguard from single instance to RAC instance ? Does Oracle dataguard support this ?

View 1 Replies View Related

Server Administration :: Install Oracle 11.2.0.2 Single Instance Database On AIX 6.1?

May 4, 2011

I want to install oracle 11.2.0.2 single instance database on AIX 6.1, does oracle recommend separate OS user for grid infrastructure and for oracle install? how many groups I need to have for these users like oinstall, dba etc?

View 1 Replies View Related

Server Administration :: Organize Or Group Schemas Inside Instance?

Jul 8, 2011

I have a lot of shemas inside an instance... How to organize them?

What I see is a long list of schemas which could be difficult to manage if number of schemas grows up... For example, I'd like to group Schema_1, Schema_2 and Schema_3 in something like Group_1, so it could be seen more organized.

Group_1
Schema_1
Schema_2
Schema_3

Sometimes a java or .net application uses 3 or 4 schemas... these schemas are in the same instance which has other schemas for other applications.

View 2 Replies View Related

Server Administration :: Creating ASM Instance Using DBCA / ORA-01012 Not Logged On

Jul 14, 2010

create an ASM (Automatic Storage Management) instance using dbca. At first try I mistakenly skipped the part where I click on ASM Parameters to add /dev/raw/raw* as my asm_diskstring so it created an ASM instance. When I get to the next page ASM Disk Groups, I selected Create New and I did not have the desired display, because of the step I missed.

I went back to do some cleaning up as follows:

1) Edit the oratab file to remove the ASM entry

2) backed up these files by renaming to old-<filename>
old-ab_+ASM.dat
old-hc_+ASM.dat
old-lk+ASM
old-orapw+ASM
old-spfile2+ASM.ora

3) killed the following processes (kill -9):

oracle 1590 1 0 22:52 ? 00:00:00 asm_pmon_+ASM
oracle 1592 1 0 22:52 ? 00:00:00 asm_psp0_+ASM
oracle 1594 1 0 22:52 ? 00:00:00 asm_mman_+ASM
oracle 1596 1 0 22:52 ? 00:00:00 asm_dbw0_+ASM
oracle 1598 1 0 22:52 ? 00:00:00 asm_lgwr_+ASM

[code]....

4) Run the following as root:

/u01/app/oracle/product/10.2.0/db_1/bin/localconfig delete

5) Restarted the database

Now when I try to go through the steps to create an ASM instance, at the point after I enter my ASM Parameters, I get the following prompt:

"DBCA will now create and start the ASM instance. After the ASM instance is started you can create the diskgroups to be used as storage for your database."

I click OK. Then I get the error message:

ORA-01012 not logged on

View 12 Replies View Related

Server Administration :: How To Monitor Instance Status And Log Switch Summary

Apr 27, 2012

how can i monitor the instance status and log switch summary.

View 8 Replies View Related

Server Administration :: New Instance Not Starting / ORA-12547 / TNS / Lost Contact

Mar 29, 2011

I have successfully installed Oracle R12 on my machine but after rebooting I can not start.

This is what I did

/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addlnctl.sh start listener

/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addbctl.sh start

You are running addbctl.sh version 120.1

Starting the database VIS ...

SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 29 21:02:42 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
addbctl.sh: exiting with status 9
/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addbctl.sh start

[code]....

BTW I have not set $ORACLE_HOME, $ORACLE_BASE, $ORACLE_SID yet.

View 18 Replies View Related

Server Administration :: Find Or Set New Oracle Instance Name On Backup Server

Sep 22, 2010

We performed image copy of production Oracle server (OS and instances) to a backup server. After a few weeks, we try to restore a latest Oracle database backup from production server to backup server. As we know, Oracle instance must be unique on the network.

Even we log on to backup server and bring up the instance, I think that still point to production instance since all init file, TNSNAMES.ora and listener file are still same. If we restore the database, we will end up bring down the production instance and restore on top of productions. How to change instance name on backup server including TNSNAMES, sqlnet, listener files in order for us to restore Oracle database from production to backup server?

View 2 Replies View Related

Server Administration :: ORA-01092 - ORACLE Instance Terminated - Disconnection Forced?

Dec 20, 2011

I am still getting the erros.

C:>set oracle_sid = sidname C:>set oracle_sid oracle_sid = sidname
C:>sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 21 01:49:06 2011 Copyright (c)

[code]....

View 2 Replies View Related

Server Administration :: ORA-01092 - ORACLE Instance Terminated - Disconnection Forced

Mar 19, 2010

I got this error after i patch to 10.2.0.4.0. Before patch, database running smooth.

I shutdown as usual using shutdown only.

View 8 Replies View Related

Server Administration :: Script To Automate Startup / Shutdown Of Multiple Instance In One Database

Jun 24, 2010

Find an appropriate script to automate Oracle DBs in one server? This db server have 6 instances. We always done the starting up and shutting down manually, although we have a reference script that does this but in Oracle v7.3.4. We do want to include the automatic start/stop of dbconsole for accessing it via OEM.

View 1 Replies View Related

Server Administration :: Instance Name On Imaged Server?

Sep 22, 2010

We imaged production Oracle Server ( OS and Oracle and everything) to a backup server. I guess my question shall be how do we access the local instance via this backup server. When we log on to this backup server, we ran sqlplus and connected to the instance but it ended up to connect to production instance. Shall we stopped local Oracle services and change init.ora, tnsname, or listener files in order not conflict with production instance?

View 1 Replies View Related

ASM Disk Groups Creation After ASM Instance Creation

Jul 9, 2012

During ASM Disk Groups creation after the ASM instance creation, receive the following error: Disk Group ORAASMGROUP2 already exists. Cannot be created again

The Grid infrastructure was deinstall one time and still the same issue.

View 4 Replies View Related

Server Administration :: Multiple Database With Multiple Instance On Same Machine?

Mar 16, 2011

can we have multiple database version running in a single machine with multiple instances provided there are enough resources.Can we do in RAC only?

View 15 Replies View Related

Server Administration :: Checkpoint Information And Interval Of Checkpoint For Instance

Jan 27, 2011

I wanted to know the checkpoint information and the interval of checkpoint for my instance.I have checked alert.log file for the same.

Is there is any other way or any view exists to get that information?

View 5 Replies View Related

Server Administration :: Disk Group With Two Disk For Normal Redundancy

Jan 16, 2013

I Configured an ASM instance and a disk group with two disk for normal redundancy.

> Here .. each disk is 2gb

The disk group has two disks...

SQL> select group_number, name, type, total_mb, free_mb
2 from v$asm_diskgroup;

GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB
------------ ------------------------------ ------ ---------- ----------
1 DATA NORMAL 4000 3898

as the group has two way mirroring (Normal redundancy) How much data (2 GB or 4 GB) can i keep in the disk group? My conception is I can keep 2 GB data in the disk group... (as the disk group keeps every extent in another disk as mirror)

View 3 Replies View Related

Application Express :: Manage Workspace Instance Settings In APEX Administration

Jul 23, 2013

I would like to change the printing settings in my workspace Instance settings. But, I can't find the "Manage Instance" option mentioned in the tutorials.

View 4 Replies View Related

CPU Usage On Server Steadily Grows After Instance Startup

Mar 4, 2013

We have Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production on AIX platform. We've noticed that the CPU usage on the server is slowly but steadily grows since instance restart: after the instance restart the maximum CPU usage is about 25-30%, and a month later with the comparable transactional load it's about 60-65%. In the top I see a lot of Oracle sessions each of which use about 1% of CPU, so I cannot find the one "CPU eater".

View 4 Replies View Related

Cons Of Running 8 Production Database Instance On One Windows Server

Dec 3, 2010

We are planning to consolidate our Oracle Production DB into one server. We are basically a windows shop. Is it feasible to run 8 production Oracle DB in one windows server. All the DB are not really transaction intensive DB. 2 DB in the size of 300GB and others all DB falls under average size of 40GB.

I can take care of the HD slicing so Oracle does not enter into IO bottleneck. We are planning to go for external NAS or SAN for storage.

My main concern is on processor usage. The processor we are thinking about is Intel Xeon Quad Core x 2nos. Will there be a processor bottleneck or is there way in Oracle to assign processor usage(I belive there is no much tweaking options here)

View 6 Replies View Related

Networking And Gateways :: Maintaining Single Listener In Multi-instance Database Server With 3 Different Oracle Home

Sep 29, 2011

We've been administering a multiple instance production dB server with 3 different versions of Oracle installed.Currently, each of Oracle version had corresponding listener.Oracle 9i had 2 instances, 10g 6 instances & 11g 2 instances also.how I can integrate this 3 listeners into 1.

View 2 Replies View Related

Single Instance Non-Grid To Single Instance Grid Database

Aug 27, 2012

I'm trying to test moving a single instance 11202 database to single instance w/ grid infra.

Here is what I've done:

1. Install a database (11202), single instance and create a database
2. Install Grid Software only (user: grid)
3. start the cluster
4. "srvctl add database -d orclsidb -o $ORACLE_HOME" to register the database with grid.
4.1> I was able to start/stop the database with srvctl command here onwards
5. configure disks using asmlib and start the asm
6. "srvctl add asm" to register asm with grid.
7. PROBLEM ... when I try to "backup as copy database format '+ASM_DATA_DG';" from oracle user it errors out as below:

RMAN> backup as copy database format '+ASM_DATA_DG';

Starting backup at 24-AUG-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00011 name=/fs0/oracle/oradata/orclsidb/sjc883p_indx_large_01.dbf
RMAN-00571:

===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/24/2012 08:53:29
ORA-19504: failed to create file "+ASM_DATA_DG"
ORA-12547: TNS:lost contact
ORA-15001: diskgroup "ASM_DATA_DG" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contactConsidering "TNS: lost contact" I tried to see if grid listener is aware of ASM instance:

[Code]....

All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=usracdb03.rwcats.com)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                22-AUG-2012 06:08:53
Uptime                    2 days 2 hr. 50 min. 48 sec
Trace Level               off

[Code]....

View 10 Replies View Related

Server Administration :: Adding Disk In ASM

Oct 16, 2012

I checked and found we have disk that is assigned with 0 disk GROUP_NUMBER. What does that mean ? how to check if disk T1_ASM05 is been part of any disk group or not.?

SQL> select GROUP_NUMBER,NAME from v$asm_diskgroup;

GROUP_NUMBER NAME
------------ ------------------------------
1 DATA
2 FRA
SQL>
SQL> select GROUP_NUMBER,name,PATH from v$asm_disk;

GROUP_NUMBER NAME PATH
------------ ------------------------------ -------------------------
1 T1_ASM01 ORCL:T1_ASM01
2 T1_ASM02 ORCL:T1_ASM02
0 ORCL:T2_BACKUP01
0 ORCL:T1_ASM04
0 ORCL:T1_ASM03
0 ORCL:T1_ASM05

6 rows selected.

SQL> !
/home/oracle > /etc/init.d/oracleasm listdisks
T1_ASM01
T1_ASM02
T1_ASM03
T1_ASM04
T1_ASM05
T2_BACKUP01
/home/oracle >

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved