Server Administration :: What Are ASMlib Devices And How To Find Group Permission Of It
Jan 18, 2013what are ASMlib devices and how to find the group permission of it ?
View 1 Replies
ADVERTISEMENT
Server Administration :: ASM Instance Did Not Access Raw Devices
Sep 28, 2011I'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.
Server Administration :: Setting Up ASM Using ASMLib On Native Linux Multipath Mapper?
Nov 8, 2010I've been trying to setup ASM disks for two node cluster using ASMLib. It's a multipath environment
Quote:multipath -ll
mpath2 (36842b2b000528f8d0000029b4ccead44) dm-1 DELL,MD32xx
[size=280M][features=3 queue_if_no_path pg_init_retries 50][hwhandler=1 rdac][rw]
\_ round-robin 0 [prio=100][active]
\_ 1:0:0:1 sdc 8:32 [active][ready]
\_ round-robin 0 [prio=0][enabled]
\_ 1:0:1:1 sdl 8:176 [active][ghost]
[code]....
I've been following Metalink note 602952.1, 309815.1 and 605828.1
metalink note 602952.1 states Quote:Note: Keep in mind for ASMLIB disks you will need to use the /dev/dm-* disks instead of the /dev/mapper/mpath* devices since they are present in the partition table ==)> /proc/partitions and ASMLIB will look at that file during the disk discovering phase. If you do not use the disks located at /dev/dm-* then ASM will not be able to discover them. and to create ASM disks with Quote:/etc/init.d/oracleasm createdisk DISK1 /dev/dm-<disk><partition> Also further stating Quote:NOTE: When scanning, only the device names known by the kernel are scanned. With device-mapper, the kernel sees the devices as /dev/dm-XX. The /dev/mapper/XXX names are created by udev for human readability. Any configuration of ORACLEASM_SCANORDER or ORACLEASM_SCANEXCLUDE must use the dm prefix.My environment is RHEL5 and towards the end of the note it says Quote:Note: On release RH 5 the /dev/dm-N devices are not persistent, starting, these devices are no longer created by udev. So release RedHat 5 you can create the ASMLIB disks on the /dev/mpath/<partition> or /dev/mapper/<partition>
Example:
# /etc/init.d/oracleasm createdisk VOL1 /dev/mpath/sata01p1
Or
# /etc/init.d/oracleasm createdisk VOL1 /dev/mapper/mpath2p1
Therefore I created a ASM disk using /dev/mapper path and it is only visible on the node it was created. Even after scandisks on other node it is still not visible when listdisks/oracleasm-discover
I've also tried creating the asm disks with dm-12 option and the same, disk get created but not visible on the other node.
Moreover if I restart the oracleasm restart the disk disappears from the node that it was visible Quote:
[root@db2 ~]# /etc/init.d/oracleasm createdisk vol1 /dev/mapper/mpath6p1
Marking disk "vol1" as an ASM disk: [ OK ]
[root@db2 ~]# ls -l /dev/oracleasm/disks/*
brw-rw---- 1 oracle dba 253, 12 Nov 8 10:22 /dev/oracleasm/disks/VOL1
[root@db2 ~]# /etc/init.d/oracleasm scandisks
Scanning the system for Oracle ASMLib disks: [ OK ]
[code]....
But disk lable is there and could be seen from both nodes on the same partition Quote:
head /dev/mapper/mpath6p1
VOL1ORCLDISKVOL1
My suspicion is on multipath configuration. I've tried both (not at the same time) combinations given below.
Quote:ORACLEASM_SCANORDER="dm"
ORACLEASM_SCANEXCLUDE="mpath mapper sd sda sdb"
and
Quote:ORACLEASM_SCANORDER="mapper"
ORACLEASM_SCANEXCLUDE="mpath dm sd sda sdb"
But still the problem is there, (disks disappears when asm is restarted and never visible on the "other" node).
Server Administration :: Database Directory Permission
Feb 4, 2011My database is running in oracle 10g. I have more than 25 oracle directories which are being used for batch/reporting jobs. I found read and write privileges are missing for 7 Dirs. I checked the last ddl time, it shows Jan 26th.
I want know how to check which userid revoked it.
Server Administration :: Organize Or Group Schemas Inside Instance?
Jul 8, 2011I 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.
Server Administration :: ASM / Dropping A Newly Created Disk Group?
Apr 6, 2012I was setting up disks groups and I accidentally created one group (DATA) with "NORMAL" redundancy but wanted it to be "EXTERNAL". I tried using asmca to remove disks from the group, drop the group, change the redundancy..... All of this failed because there was an spfile on the disk group.
I finally got it to work with using this procedure:
sqlplus '/ as sysasm'
SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 5 08:58:19 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> drop diskgroup DATA;
drop diskgroup DATA
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15053: diskgroup "DATA" contains existing files
[code]....
In summary, I am not sure why changing the redundancy would be so difficult if there is data on the disk group.
Server Administration :: ORA-29702 / Error Occurred In Cluster Group Service Operation
Aug 12, 2010I have deinstalled Oracle database, ASM and oracle software. I installed the oracle software, ASM and database. I have seen the error in the ASM trace called
Errors in file /opt/oracle/admin/+ASM/bdump/+asm_gmon_10518.trc:
ORA-29702: error occurred in Cluster Group Service operation
ORA-29702: error occurred in Cluster Group Service operation
Server Administration :: Unable To Find Server Process In Oracle Database For Specific Application / Client
Feb 13, 2013I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.
1. My database runs on different server.
2. I invoked "sqlplus" from another unix box to login to the database.
3. I found that the process id (ps -ef |grep sqlplus).
4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?
SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID,
SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM,
SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID
FROM
SYS.GV_$PROCESS, SYS.GV_$SESSION
WHERE
SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST'
and SYS.GV_$SESSION.MACHINE like '%hostname%'
Server Administration :: Find Or Set New Oracle Instance Name On Backup Server
Sep 22, 2010We 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?
Server Administration :: How To Find Unused Columns
Nov 9, 2011is there a way to find out which unused columns in oracle?
View 8 Replies View RelatedServer Administration :: How To Find Updated Table
Mar 9, 2012how to find a table is updated and when the table is updated.
View 1 Replies View RelatedServer Administration :: Find Whether Database Link Is Being Used?
Jul 26, 2011I am having database A and database B and I am inserting into database b by selecting some records from database a using db link.Is there any way to find whether database link is being used?
View 6 Replies View RelatedServer Administration :: How To Find When The Datafile Was Resized
Jan 17, 2012We need to find when any datafile was resized ( if at all)in a tablespace. Actually, by noting the created date from v$datafile , we used to know the data growth in a tablespace. Now as the number of datafiles have increased, we want to resize them. This diagnostinc have to be done without changing/adding anything in DB.
View 12 Replies View RelatedServer Administration :: Where To Find Alert Log Errors
May 10, 2010where i can find an alert log errors so whenever they occur in my RAC so i can comprehend them very well. I am trying to know that what can be the errors when u have RAC with ASM and SAN .
View 3 Replies View RelatedServer Administration :: Cannot Find SQL Plan For Insert Statement
Dec 27, 2011I can not find the sql plan for insert statement,why?
Select sql_text From v$sql a
Where a.SQL_ID = '0yungrk19a277';
-------------------------------
INSERT INTO OS_USERBILL_ACTV_READ_MON_DT
(MONTHNO, MAILCODE, OPERTYPE, PROVCODE, AREACODE, DAY_TOTALCOUNT, TOTALCOUNT,
CREATETIME, MODIFYTIME, SENDER_TYPE, SENDER_DOMAIN)
VALUES
(:B9 , :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , SYSDATE, SYSDATE, :B7 , :B8 )
[code]....
Server Administration :: Find Last Run Duration Of Job Which Was Scheduled Using DBMS_JOB
Jun 20, 2010Is there any way to find the last run duration of a job which was scheduled using DBMS_JOB?
View 3 Replies View RelatedServer Administration :: How To Find The Base Table Of A View
Aug 15, 2011How to find the base table of a view,such as a view:
create or replace view vw_test as select * from tb_test;
Is there dic view to get the base table of view?
Server Administration :: How To Find The Size Of Individual Folder In ASM 10g
Mar 16, 2012Would like to know, how to find the size of individual folder in ASM 10g !
Also I am not able to find the PATH/name of the raw devices in ASM 10g !
Server Administration :: ORA-01555 / Unable To Find Sql_id
Jan 25, 2012I am getting below ORA-01555 error in alert log everyday.
ORA-01555 caused by SQL statement below (SCN: 0x09ad.86a4562a):
Sat Jan 21 08:39:45 2012
SELECT (NVL(MAX(BLOCK_ID + BLOCKS ),0) * :b1 ) / 1024
FROM DBA_EXTENTS WHERE TABLESPACE_NAME = :b2 AND FILE_ID = :b3
I cannot able to find the sql_id here. So how can I find from which process or session this query is firing? before increasing the undo size, I need to analyze as why it is occuring?
undo_management string MANUAL
undo_retention integer 900
undo_suppress_errors boolean FALSE
undo_tablespace string
Server Administration :: Find Database Is Corrupted Or Crashed
Mar 3, 2012how will you find your db is Corrupted or crashed. how will u recover it.
View 2 Replies View RelatedServer Administration :: How To Find Which Table Or Index Needs To Be Reorg
Apr 21, 2009How to find which table or Index needs to be reorg..??
IS there any Query!!!.
Server Administration :: Find Out Used Space Of A Specific Datafile
Mar 21, 2012post some script which will find out the used space of a specific datafile.
View 5 Replies View RelatedExport All Schema And User Permission - Then Import To New Server?
Nov 2, 2010I have database in 9.2.0.3 on windows 2003 R2 one server and i have serve with 10.2.0.4 64 bit on windows 2008 R2 64 bits. I want to move database from 9.2.0.3 to new server on 10.2.0.4.
!)should i do the cold backup of 9.2.0.3 and then create db instance on new server and then use dimutility to create new instance and then run the patch upgrade.
!!) I would like to do export all schema and user permision (is if possible?)export and then import to new server?
Server Administration :: Find SID From Current Session As It Make Connection With DB
Dec 27, 2011How to find the sid from v$session of my current session.
I want to ask:
Let say I have open 10 TOAD session and only in one toad session i have fired a sql query ( the rest 9 session are just blank), then the rest 9 status are in active status. Now, how i can figure out which sid ( from v$session ) belongs to which session as all the 9 session having nothing to run.
Quote: My main intention is to find out the current session sid as soon as it make connection with DB.
Server Administration :: Find Out Active Schemas In 9i Oracle Database?
Dec 9, 2010findout and to fill up the excel which lists down the Database schemas and states whether they have in active / or not.
Active state may be determined whether it has been used for the last 3 months or so. The last updated time may be a good indicator of the same.
Server Administration :: Query To Find Hostname For Oracle Session
May 20, 2010How I can find the hostname for an oracle session id?
View 4 Replies View RelatedServer Administration :: To Find Out The Database Is Using Cost Based Analyzer
May 23, 2012How to find out the database is using Cost based analyzer?
Currently database is set to ALL_ROWS.
SQL> show parameter optimizer_mode
NAME TYPE VALUE
------------------------------------ ----------- -----------
optimizer_mode string ALL_ROWS
SQL>
SQL>
Server Administration :: Find Tablespace Usage Including Datafiles
May 25, 2010I am looking for a script to find the tbs usage including datafiles. Tablespaces Datafile Size Used Free Used% Free% Max MB
Need all the data in MB and all the datafile space in every tablespace.I have searched internet,but couldn't find this type of format.
SQL & PL/SQL :: Find Maximum Value Within A Group For Corresponding Types
Oct 25, 2010Test data for the problem is as follows.
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for 64-bit Windows: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
SQL> with t
2 as
3 (
4 select 1 id, 12 compid, 1 rel_type, null enddt from dual union all
5 select 1, 13, 1, to_date('31.12.1993','dd.mm.yyyy') from dual union all
6 select 1, 14, 1, to_date('12.06.1996','dd.mm.yyyy') from dual union all
7 select 1, 15, 1, to_date('23.04.2003','dd.mm.yyyy') from dual union all
[code].......
I want to find the the latest compid for individual types 1 and 2 only within a list of ids. Latest compid is defined as the compid associated with the latest end date (null is treated as the latest end date).
So in the above example for rel_type = 1, compid : 12 is latest, for rel_type : 2, compid : 6 is latest.
Datatype for the tables are :
Id : Number
compid : Number
Rel_Type : Number
enddt : Date
Server Administration :: Find Out Difference Of Data For Some Tables Between Current And Previous Day
May 26, 2011We want to find out difference of data for some tables between current day & previous day. We can use query with minus operation but it will take lot of time since table size is in range from 200 to 500 GB. We have to do this exercise every day.
View 5 Replies View Related