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

RAC & Failsafe :: Unable To Mount Ocfs2 Filesystem

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

Server Administration :: Change Current Redo Log Size In Oracle Mount Stage

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

RAC & Failsafe :: Configure 10G On LINUX 5.0 Machine

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

RAC & Failsafe :: Using One EC2 Machine To Host Several Linux VMs Using Virtual Box

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

RAC & Failsafe :: Change Cluster Interconnection From Public To Private?

Jul 3, 2013

how to change the cluster interconnection from public to private.

View 6 Replies View Related

SQL & PL/SQL :: Selecting Owner For Currently Called Object?

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

How To Create A User (Owner Of Coeus Schema)

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

Server Administration :: How Table Owner Is Changed

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

Upgrade :: DBUA-PRKH-1014 Current User Is Not Same As Owner

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

Application Express :: Exporting Inside Database In Export Repository - Owner And Table Name?

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

Unable To Mount The DB?

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

11.2 - How To Mount Oracle Database

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

How To Mount A Database From Dbf And Ctl Files

May 20, 2013

I recovered dbf and ctl files, how to mount that database again. Using oracle 9i.

View 1 Replies View Related

Make Tablespace Offline In Mount State?

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

Server Administration :: Why 3 Mount Points For Datafiles

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

RMAN BACKUP ACFS Mount Point That Are Used For DBHOME?

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

Server Administration :: Error In Startup Mount After Shutdown Immediate?

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

Server Administration :: Which Commands Only Can Use In Database Mount Mode

May 3, 2011

which commands only we can use in database mount mode?

View 7 Replies View Related

Data Guard :: ORA-01102 / Cannot Mount Database In EXCLUSIVE Mode

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

Server Administration :: ORA-01102 Cannot Mount Database In Exclusive Mode

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

Data Guard :: Oracle 9i - Cannot Mount Database In EXCLUSIVE Mode

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

Data Guard :: ORA-01154 / Database Busy - Open / Close / Mount And Dismount Not Allowed Now

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

Real Application Clusters :: Check Archive Mount Point Size From Sqlplus Prompt?

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

11g On Suse Linux

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

Required Database 10.2.0.4 For Linux 64 Bit

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

Migration From Windows To Linux

Mar 31, 2008

Where to get the Metalink Doc-ID for Migration from windows 2000 to Linux.

View 14 Replies View Related

Oracle 11g EM Not Working (Linux OS)

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

Expdp On 10G AIX / Impdp 11G Linux?

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

Database Installation In Linux Os?

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







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