RAC & Failsafe :: Cannot Change Owner Of Cifs Mount On Linux
Nov 6, 2008
We are configuring NAS device on linux for RAC installation.
ISSUE: I had mounted NAS device to Linux server.As root user I can create directory but cannot change owner of cifs mount.It say permission denied.When I try to change permission it doesn't work.The mount point show the uid and gid as 33 and permissions drwxr-xr-x
I had mounted using the following command
#mount -t cifs storage:/ocr1 /u02/ocr1 -o username=XXXX,password=XXXX,uid=oracle,gid=dba
Permission denied
[root@SSIPL-WRKST-116 u02]# chown -R oracle:dba ocr1
chown: changing ownership of `ocr1': Permission denied
chown: changing ownership of `ocr1/ss': Permission denied
[root@SSIPL-WRKST-116 u02]#
Change owner
[root@SSIPL-WRKST-116 u02]# ls -lrt
total 0
drwxr-xr-x 3 33 33 0 Dec 4 2006 ocr1
[root@SSIPL-WRKST-116 u02]# chmod -R 777 ocr1
[root@SSIPL-WRKST-116 u02]# ls -lrt
total 0
drwxr-xr-x 3 33 33 0 Dec 4 2006 ocr1
[root@SSIPL-WRKST-116 u02]#
View 2 Replies
ADVERTISEMENT
Feb 7, 2011
I am configuring RAC with two nodes. I have mapped iscsi targets successfully. I am unable to mount the ocfs2 filesystem.
mount -t ocfs2 -o datavolume,nointr -L "oracrsfiles" /u02
When execute the above command, it displays the follwing error:
ocfs2_hb_ctl: Device name specified was not found while reading uuid
mount.ocfs2: Error when attempting to run /sbin/ocfs2_hb_ctl: "Operation not permitted"
View 2 Replies
View Related
Jun 8, 2012
We have one primary oracle database 10.2 and standby by database with no data guard. Initially we have 2 redo log group in primary and standby database.
We have recently add 2 more redo log and increase the size of log member from 50m to 200m in primary database. We don't have any problem in primary database.but in standby database we face a problem because we cannot open it. It always in mount stage in which . How we change the size of current redo log because we can't run. Alter system switch logfile command in mount stage.
View 3 Replies
View Related
Mar 9, 2011
provide me the online material or some links where i can follow the instructions step by step to configure 10G RAC on LINUX 5.0 machine.
I have 3 separate machines having Linux 5.0 . I want to do this for R&D purpose.
View 1 Replies
View Related
Dec 22, 2010
How to get a RAC running in an EC2 environment?
It isn't possible to use one EC2 machine for each RAC node because EC2 can't handle the virtual IPs, but I had thought that I could use one EC2 machine to host several Linux VMs using Virtual Box (the same way that I use Virtual Box on a Windows host). But I can't get Virtual Box working on EC2. The only relevant advice I can find on this is comments to the effect that running any virtualization product with a Xen machine as host is not a good idea.
I do realize that this isn't a 100% Oracle question, but if set up a RAC on an Amazon Cloud machine,
View 1 Replies
View Related
Jul 3, 2013
how to change the cluster interconnection from public to private.
View 6 Replies
View Related
Sep 13, 2010
I am trying to select the owner of a certain object, only knowing the name of the object and the user calling it.
Problem is this object might exist in more than one schema with the same name, and I only need the one that is called by the active user, which himself/herself might have access to other schemas containing their own copy of the object.
Example:
SELECT OWNER
INTO v_schema_name
FROM ALL_OBJECTS
WHERE OBJECT_NAME = p_object_name;
This works fine, until the object exists in more than one schema to which the current user has access.
View 4 Replies
View Related
Dec 9, 2010
On the database instance where you want to install Coeus, create a user who will be the owner of Coeus schema. This user should have at least the following privileges. CREATE TABLE, CREATE VIEW, CREATE PROCEDURE, CREATE PUBLIC SYNONYM, CREATE USER, CREATE ROLE, CREATE SEQUENCE, CREATE SESSION CREATE TRIGGER, AND CREATE TYPE. If you choose, you can grant DBA role to this user.
Note: Coeus Schema owner should have CREATE USER and ALTER USER right explicitly granted to it, not through a role like DBA.
View 3 Replies
View Related
Mar 21, 2012
I got query to investigate, how table owner is changed.
SQL> conn test/test
Connected.
SQL> create table guri(name varchar2(9));
Table created.
SQL> select table_name from user_tables;
no rows selected
SQL> conn /as sysdba
Connected.
SQL> select owner,object_name,object_type from dba_objects where object_name = 'GURI';
OWNER OBJECT_NAME OBJECT_TYPE
---------- ----------- ------------
CISREPLICA GURI TABLE
View 8 Replies
View Related
Aug 27, 2012
I am trying to upgrade 10.2.0.4 DB to 11.2.0.3 using DBUA.10g oracle is owned by user ora10gr4 and 11g oracle is owned by user ora11203.I started DBUA from 11g/bin path and while selecting DB i want to upgrade I am getting following error.
Oracle home owner check failed:-PRKH-1014.Current user "ora11203" is not the owner user "ora10gr4" of oracle home "/oracle/ora10gr4"..I cannot give the ownership of both oracle home for same user because of project criteria.
View 2 Replies
View Related
Jun 12, 2013
We are exporting our apex application inside the database in the Export Repository. what owner and table name are those export located exactly?
View 1 Replies
View Related
Jan 15, 2013
i am not able to mount my database created today. I uninstalled the RDBS software and all peoplesoft database content to start from a fresh again. But now i am not able to mount my DB. I am working on 11g. The error is -
SQL> startup
ORACLE instance started.
Total System Global Area 744910848 bytes
Fixed Size 1374696 bytes
Variable Size 226493976 bytes
Database Buffers 511705088 bytes
Redo Buffers 5337088 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 2192
Session ID: 5 Serial number: 1
SQL>
View 11 Replies
View Related
Jun 10, 2013
While I was trying to configure an Oracle DB called "NW6" using the Database Configuration Assistant, I have Oracle 11.2 database installed on a Windows 2008 Server, the configuration wizard thrown an error : ORA-01507:database not mounted
So I am not able to successfully complete the DB configuration. Also I tried to test the service using the net configuration assistant, it throws an error: ORA-27101 shared memory realm does not exist.
View 9 Replies
View Related
May 20, 2013
I recovered dbf and ctl files, how to mount that database again. Using oracle 9i.
View 1 Replies
View Related
May 7, 2012
I started database in mount state;startup mount; alter tablespace users offline;
I tried to make tablespace offline In another case online but showing error database not open same for command alter tablespace begin backup; do think we can make tablespace offline in mount...
View 1 Replies
View Related
Feb 3, 2013
i encoutered lately on such statement:
Table D-7 shows a hierarchical file mapping of a sample OFA-compliant installation with two Oracle home directories and two databases. The database files are distributed across three mount points, /u02, /u03, and /u04. URL....
why three mount points (/u02, /u03, and /u04) for datafiles? don' understant this. isn't it better to store all datafiles in one mountpoint?
View 4 Replies
View Related
Oct 24, 2012
We are Using ACFS File system for DBHOME and its Called "/u01/app/oracle". I would like to know, can i use RMAN to backup my oracle home?
View 4 Replies
View Related
Apr 1, 2009
I want to shutdown the database using shutdown immediate and startup the database using startup mount.
1.)My system is client system if I connect start--> program -->Accessories --> communication --> Remote Desktop connection (connect server system) , open Run type cmd after
Shutdown immediate (database is shutdown)
Startup mount (database is mounted no problem it's working fine)
2.) But if I, open Run type cmd in client system If I run same command, I'm getting below error (ORA-12560: TNS:protocol adapter error).
C:>set oracle_sid=dbadb
C:>sqlplus / as sysdba
SQL*Plus: Release 10.1.0.2.0 - Production on ╘± ╠ß± 31 18:09:27 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
[code].....
3. If I run same command in Sql Plus I'm getting below error(ORA-12514: TNS:listener does not currently know of service requested in connect descriptor).
SQL*Plus: Release 10.1.0.2.0 - Production on Ôñ Ìáñ 31 18:23:13 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
[code].....
View 14 Replies
View Related
May 3, 2011
which commands only we can use in database mount mode?
View 7 Replies
View Related
Apr 28, 2003
How i create Standby Database in Same HOST, we using SUN OS 5.8.
I read form Oracle DOC that i can create Standby Database in Same HOST and follow the tutorial , but when i try to mount standby database using ALTER DATABASE MOUNT STANDBY DATABASE EXCLUSIVE; i got a error message ORA-01102: cannot mount database in EXCLUSIVE mode
View 6 Replies
View Related
May 10, 2002
I performed Shutdown Immediate in Oracle 8I and now I am unable to mount the database.I'm getting the following message: ORA-01102 Cannot mount database in Exclusive mode/I only have one database running on this machine. It was automatically created by Oracle installer upon installation of Oracle software. I can no longer connect via SQL * Plus,Only through Server Manager (connect internal)
View 8 Replies
View Related
Jun 30, 2008
I'm trying to create a physical standby database on my Oracle9i DB runing on WinXP.
Note: I have both Primary and Standby on the same system.
Actually everything went well .... I did created the standby DB but the problem is I can not start my primary DB if my standby DB is mounted. I get this error:
ORA-01102: cannot mount database in EXCLUSIVE mode
And when I read about the error message I learnt that I should start my DB in compatible mode ...
View 5 Replies
View Related
Sep 21, 2010
I am trying to create the Physical StandBy Database in the same server. Till last 2 Final steps, everything went on well. In the final steps, when I try to open the StandBy Database, it throws the following Error:
*******************************************************
SQL...> alter database open;
alter database open
*
ERROR at line 1:
ORA-01154: database busy. Open, close, mount, and dismount not allowed now
*******************************************************
I tried creating the Physical Standby with the following Steps.
Environment: Oracle Release 10.2.0.1.0 / Windows 2003 Server Enterprise Edition SP2
Primary DB = 'PrimDB'
StandBy DB to be created ='StBy1DB'
In the same Server, location for
PrimDB datafiles='F:oracleproduct10.2.0oradataPrimDBData',
StandBy Datafiles='E:StandBy_DBData'
PrimDB Control Files='F:oracleproduct10.2.0oradataPrimDBControl'
StandBy Control Files= 'E:StandBy_DBControl'
[code]....
Step 1 Create the Oracle Service for StandBy DB "StBy1DB' and Create the Standy DB Password file.
ORADIM -NEW -sid StBy1DB -intpwd passwd -startmode manual
Step 2 Shut down the primary database.
SQL> SHUTDOWN IMMEDIATE;
Step 3 Copy the datafiles to 'E:StandBy_DBData'. (including Temp01.dbf is it Right?)
Step 4 Restart the primary database.
Restart the primary database:
SQL> STARTUP;
Step 5 Create a Control File for the Standby Database (Should this command be given in Mount Status or Open Status?)
From Primary database,
SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS 'E:StandBy_DBControlStByControl01.ctl';
Step 6 Prepare the Initialization Parameter File to be Copied to the Standby Database
SQL> CREATE PFILE='E:StandBy_DBPFileinitStBy1DB.ora' FROM SPFILE;
Step 7 Set Initialization Parameters on a Physical Standby Database
db_cache_size=444596224
java_pool_size=4194304
large_pool_size=4194304
shared_pool_size=150994944
streams_pool_size=0
[code]....
Now When I type the following command, it throws an error:
SQL...> alter database open;
alter database open
*
ERROR at line 1:
ORA-01154: database busy. Open, close, mount, and dismount not allowed now
View 2 Replies
View Related
Feb 15, 2013
I am in need to find archive log mount point space detail usage through sqlplus on multiple instance. Is there any view in oracle which can give me the detail.
I know one method using external table but that is cumbersome for RAC.
can i get some command like this.
select inst_id,mountpoint,space_usage,space_available,total from GV$table --> returns
View 4 Replies
View Related
Aug 14, 2012
Recently, We moved our production environment from Solaris - oracle 11g RAC to Suse linux - Oracle 11g RAC. After this migration, We are facing the poor performance issues where the simple select query joining 4-5 tables was almost running for more than 10 hrs without any result. Finally, We had to kill the session and restart.Actions which we have taken so far :
1) We analyzed the tables involved. ( No improvements)
2) Rebuild the indexes. ( No improvements)
3) Rebuild the table - This resolves the issue and job completed in the expected time without any issue.
But again some other jobs are having the same problem but my guess would be rebuild all the tables is not the permanent solution. There could be some issue in the background like Datablock corruption etc.
View 4 Replies
View Related
Oct 8, 2012
We are planning Database Migration From Windows to Linux Using RMAN..We required Oracle database 10.2.0.4 for Linux 64 bit.
View 3 Replies
View Related
Mar 31, 2008
Where to get the Metalink Doc-ID for Migration from windows 2000 to Linux.
View 14 Replies
View Related
Jan 20, 2011
I am unable to configure EM(Oracle 11.2g) on Redhat Linux 5 Enterprise edition(32 bit). Environment variables are set to correct SID. If I try to run dbca the wizard does not display the Enterprise manager configuration screen. I have tried to create repository by using emca -config dbcontrol -db config.
But it throws exception that database instance is unavailable?
View 5 Replies
View Related
May 4, 2013
First of all, I'm not a DBA, and when I try to import the dmp file generated on AIX with Oracle 10G on a RHEL6 11G machine I got a lot of issues, how to do this?
View 3 Replies
View Related
Sep 29, 2010
i am new to linux os . the step by step process of oracle database 10gR2 and oracle 10g client installation in linux os
View 6 Replies
View Related