Server Administration :: Oracle 10gR2 RAC - Moving Archivelog Location

May 25, 2010

We have oracle 10gR2 RAC with ASM running on HP-UX. The archivelogs are located in a NFS filesystem and we want to move this into ASM.

View 1 Replies


Server Administration :: Migration Of Oracle 10gR2 To 11gR2?

Jun 23, 2010

I am migrating an oracle 10g to 11gR2. i am a bit confused. The developers in my work place have a tablespace for storing table and a different tablespace for storing indexes.

For the migration i am using exp and imp. My question is how i am going to migrate the indexes from 10g to 11gR2?

OS; solaris sparc 10

Oracle 10g:

oracle 11g:

View 1 Replies View Related

Server Administration :: Automated Shell Script For Renaming Oracle DB 10gR2

Nov 8, 2011

Provide automated shell script for renaming oracle DB 10gR2. Now it is a daily manual job for us.

View 4 Replies View Related

Server Administration :: Write Bangla Language In Oracle 10gR1 / 10gR2 And Express

May 17, 2012

I tried more to write Bangla in Oracle 10gR1, or 10gR2 or Express but failed. When I write bangla in the "emp_name" field for employee name this can be save, But when I execute to see the data again then the data comes with a big change like some symbol for some character.

View 3 Replies View Related

Archivelog Location In Separate Date Format

Nov 10, 2013

archive logs to be stored in its own "date formatted" separate folders.I have already configured flashrecovery area and I dont want to change it as backups are stored there.How can I achieve this without changing the flash recovery area location ? db_recovery_file_dest is set to G:log archive dest is set to F

View 8 Replies View Related

Moving Trace Files To Archive Location?

Aug 20, 2012

I am using Oracle RAC 11gR2.I am planing to move my old trace files to an archive location.

I have the below questions concerning the users and groups used by Oracle RAC when moving the trace files.It is related to the permissions but it is about oracle behavior.

The trace files of database (oracle user) are created as below:

284 -rw-r-----    1 oracle   asmadmin     283571 Aug 20 18:08 PPRD1_mmon_13893716.trc
   4 -rw-r-----    1 oracle   asmadmin        125 Aug 20 18:10 PPRD1_gcr0_11730998.trm
   4 -rw-r-----    1 oracle   asmadmin       2833 Aug 20 18:10 PPRD1_gcr0_11730998.trc
580 -rw-r-----    1 oracle   asmadmin     588489 Aug 20 18:12 PPRD1_lmhb_15859792.trm


when moving the files using the oracle user it will be created as oracle:oinstall and not oracle:asmadmin since asmadmin is not a group of the oracle user.

1. How oracle created my trace and log files with permission oracle:asmadmin?

2. How should I move these files? I moved it using the Oracle user and it was created as oracle:oinstall with Operating system error "unable to duplicate owner and mode after move"

View 5 Replies View Related

Server Administration :: Configure Archivelog Stored Inside ASM Diskgroup

Sep 16, 2011

I'm new on 11g, due to my limit storage with mounted internal disk, so I think, may I can store archivelog in ASM without FRA? However, I did not find any document to verify.

View 5 Replies View Related

Server Administration :: Location Of A DB Block?

Feb 7, 2011

) How to find out, whether my Query return the output from the block of BUFFER CACHE or from DATAFILES?

2) How to calculate the no of data blocks were used to return a single output.

View 2 Replies View Related

Server Administration :: Installed 10gr2 And Implemented 3GB - Database Hang?

Jan 26, 2010

My server RAM is 12GB. i installed 10gr2 and implemented /3GB also. Eventhough my database is giving problem.

View 20 Replies View Related

Server Administration :: Moving OMF Files In ASM

Mar 13, 2013

The steps to move OMF files in ASM. I tried the following and was not successful.

RMAN> switch database to copy;

datafile 1 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/system.357.809972853"
datafile 2 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/sysaux.363.809972837"
datafile 3 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs1.365.809972737"
datafile 4 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/users.361.809972859"
datafile 5 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs2.360.809972761"
datafile 6 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs3.359.809972787"
datafile 7 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs4.358.809972811"

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 03/13/2013 16:30:05
ORA-01139: RESETLOGS option only valid after an incomplete database recovery

RMAN> alter database open;

so switch worked reset logs says can't use it there so I just try to open and it just hangs.

View 1 Replies View Related

Server Administration :: Moving IT_TO_DUM_LOADING Job From G1 Database To G2?

Jun 17, 2011

I want to move IT_TO_DUM_LOADING job from G1 database to G2 database.

I executed the below query and returned one row with jobname IT_TO_DUM_LOADING.



it returned the result with



I could not find this job in dba_jobs. how to move this job from one database to other database?

View 23 Replies View Related

Server Administration :: Moving Tables From Older To New DB?

Mar 23, 2013

I have problem with moving old DB to the new (the same DB 10.2.0 in Win 2003, first in 32 bit, second in 64 bit). I want move DB from 32 to 64 bit. Problem is that all objects in old DB were created in SYSTEM schema by SYS. I can't export that objets (with data) because impdp nor imp don't touch this objects (tables with indexes). I can't use export import procedure. I'm looking for another method to transfer data, which will be the best and the fastest? Maybe files copy on OS? I suppose it will be problems with configuration files, database have other tablespaces.

View 13 Replies View Related

Server Administration :: Moving 10 GB Data To 200 GB Database Server

Jun 22, 2011

We have an Oracle Server database of Size 50 GB having 10 GB Data. And Planning to have a new Database Server of 200GB . So my question is after moving all the 10 GB data to 200 GB Database Server, will the performance of the system come down? Will it reduce the speed?

View 9 Replies View Related

Server Administration :: Unable To Use Existing OraInventory Location During Installation?

Jan 5, 2010

i am installing oracle 11g rel2 ( o/s : hp ux 11.31 ). already we have 11g rel1 installed in the machine where oracle inventory location is /oracle/oraInventory where /oracle is ORACLE_BASE directory..

cd /oracle
ls -ltr
drwxrwxr-x 4 ora11gr1 dba 8192 Aug 30 00:19 oraInventory

now when i install oracle 11g rel2 on the same machine, it should use the existing oraInventory..but it is prompting us to enter the new location for oraInventory during installation....but as per the naming convention, we need to keep inventory directory under /oracle/oraInventory only..

when i select oraInventory location as /oracle/oraInventory from wizard, iam getting below error:

[INS-32055] The Central Inventory is located in the Oracle base.

[INS-32035] Unable to create a new central inventory at the specified location.

should i uninstall the exisitng oracle 11g rel1 and then should i install rel2 (i.e what iam trying to install now ) ?if so, after instlaling rel2, then should i install rel1 ?

View 4 Replies View Related

Server Administration :: Location Of Table In Tablespace / Data File

Jul 6, 2010

I was wondering if there is any way to know in which Tablespace and Datafile my Table is located. I have exported a table and about to delete it as i am partitioning it.

View 9 Replies View Related

How To Download Oracle 10gR2 To Windows 2008 Server R2

Jun 27, 2012

I'm trying to download Oracle RDBMS for Windows Server 2008 R2. But i don't see it on OTN or edelivery....i can't find any link...Have i to request a SR on metalink?

View 2 Replies View Related

Client Tools :: Oracle 10gR2 Database Server - Unable To Use Isqlplus?

Apr 11, 2007

I have installed Oracle 10gR2 database server recently in the Windows box. The database works fine. But I am unable to connect through the Internet Explorer. I found that the service for the isqlplus is not available. Do I need to run any script for creating the service?

View 12 Replies View Related

SQL & PL/SQL :: Moving Images From Server To Oracle Database?

Jun 28, 2011

I have a problem(illega use of LONG) while moving image data from SQL Server 2005 database to Oracle10G table in BLOB.

insert into table
select [[mailto:.....tablename@odbc SQL|.....tablename@odbc_SQL]]

I am using HS connection and DBLink.

View 10 Replies View Related

Server Utilities :: Migrate 10gR2 To 11gR2 On Different Server

Jul 11, 2011

Here are the cards I've been dealt:

I've inherited a instance running on a windows 2003 box; running fine, no problems other than system has been in production since 2005 and has gotten pretty old and tired. This old box has one tablespace on it... called "gateway".

I've installed on a new (Windows 2008 R2 Enterprise 64-bit) server and created an empty database also called "gateway".

Now to move the data and views, objects, everything.

I've read up on a variety of migration techniques (oops, I mean "upgradation" LOL) and can follow the steps...

In short, I want to pull everything off of server a (10.2) and put it into production on server b (11.2). There seems to be quit a few options.

1. install 10.2 on my NEW server (server b), move the data over and get everything running, then install 11.2 and have it upgrade the database as part of the installation process.
2. drop the empty tablespace on server b, stop the database on server a, copy the files over from the old to the new home, run DBUA or set the compatibility attribute...
3. run some type of server a to server b utility that can bridge the two over the network. Some type of mirroring technique?
4. run file export scripts on server a, copy files to server b and run various import scripts

I tend to think that option 3 would be the best because both instances are in great health and are running right now. Is there a mechanism that allows the 11.2 instance to see and upgrade from a different server?

View 9 Replies View Related

Impdp Speed Differ From Location To Location

Oct 4, 2013

We have taken export expdp backup from prod database (primary database- Data Guard).

1.) Import impdp is very slow 10GB/Hrs on staging database (Data Guard MAXIMUM AVAILBILITY)Since Server configuration, database version and configuration, operating system everything are same as production. No blocking, locking or waiting sessions

2.)import impdp is fast 90GB/Hrs on Test standalone database and this test database is running in NOARCHIVE LOG mode with oracle standard version after that no more difference.

CPU,Memory,network and disk I/O are look normal while importing on both databases.why that much difference on import.

View 1 Replies View Related

SQL & PL/SQL :: Copy Some Archivelog Files Between 2 Database Server

Sep 27, 2011

I wanted to copy some archive log files between 2 DB Server.Steps:

1) Edited the Local and Remote DB's TNSNAMES file and modifyied like below.

bookstore =

2) Created a Source Directory --> DR1
3) Created a Target Directory --> DR2
4) Created a DB Link
CREATE DATABASE LINK LINK1 CONNECT TO <username of the Remote DB> IDENTIFIED BY <Password> USING '<Remote DB Name taken in the TNSFILE>.
5) In the Local Server I had written the below command.

create or replace procedure proc1 is
cursor c1 is select recid,substr(name,37) "ARCH_FILE" from v$archived_log;
var1 c1%rowtype;
open c1;
fetch c1 into var1;

It is working, but not coping the Files from Local To the Remote.

View 22 Replies View Related

Server Utilities :: To Import All Data From 8i To 10gR2

Apr 14, 2010

At my current organization there are two instances are running one is at 8i and another one is 10g. I want to migrate all the data from 8i to 10g. I have already taken the export from 8i with the below command:-

exp file=<<PATH>> full=y logfile=<<PATH>> compress=y

Now I want to import it to 10g DB. Can I do the import with that below command?

imp file=<<PATH>> full=y logfile=<<PATH>> ignore=y compile=y

View 3 Replies View Related

Oracle DB 10gR2 Installation

Jul 8, 2011

I try to install th a oracle 10gR2 database to a SuSe Linux 11.4.

I try to install to tha local machine, not to a remote host. But when I start the installation every time I get the next error message:

CODECan't connect to X11 window server using '' as the value of the DISPLAY variable.

Unable to start an interactive install session because of the following error:Can't connect to X11 window server using '' as the value of the DISPLAY variable. The DISPLAY environment variable should be set to <hostname or IP address>:<screen>, where the <screen> is usually '0.0'.

Depending on the Unix Shell, you can use one of the following commands as examples to set the DISPLAY environment variable:

- For csh: % setenv DISPLAY
- For sh, ksh and bash: $ DISPLAY=; export DISPLAY

Use the following command to see what shell is being used:

echo $SHELL
Use the following command to view the current DISPLAY environment variable setting:

- Make sure that client users are authorized to connect to the X Server. To enable client users to access the X Server, open an xterm, dtterm or xconsole as the user that started the session and type the following command:

% xhost +
To test that the DISPLAY environment variable is set correctly, run a X11 basedprogram that comes with the native operating system such as 'xclock':
% <full path to xclock... see below>

If you are not able to run xclock successfully, please refer to your PC-X Server or OS vendor for further assistance. Typical path for 'xclock': ''

I think that I don't need the x server when I install the product to the local machine. But every time I get this message.

View 6 Replies View Related

Download Full Oracle 10gR2 Documentation?

Nov 3, 2010

want to download full oracle 10gR2 documentation. I also navigated on [URL] but this link allowing me to download pdf one by one but I want to download all pdf's in single shot.

View 2 Replies View Related

Oracle 10gR2 Installation Failed On SLES10

Jul 15, 2008

While installing Oracle10gR2 on zlinux machine where the OS is SLES10 SP1 I got this error

In installActions2008-07-15_04-37-15PM.log

INFO: /usr/lib64/gcc/s390x-suse-linux/4.1.2/../../../../s390x-suse-linux/bin/ld: skipping incompatible /opt/oracle/10g/lib/stubs/ when searching for -ldl
/usr/lib64/gcc/s390x-suse-linux/4.1.2/../../../../s390x-suse-linux/bin/ld: skipping incompatible /opt/oracle/10g/lib/stubs/ when searching for -lm


View 1 Replies View Related

PL/SQL :: Creating PSP Reports In Oracle Database 10gr2?

Feb 6, 2013

I want to create the .psp(pl/sql ser pages) reports in the oracle database 10gr2.but i am unable to do it why because it needs http server(knew by going through some of the oracle docs but not able to understand) where i find this first of all details configuration needed for the .psp files.

View 8 Replies View Related

Oracle 10gR2 - OEM Database Control Configured For DBs

Jul 24, 2013

 I have multiple oracle (10gR2) databases running on a linux (5.8) server. How can I check that for which of the databases has the OEM Database Control been configured and on what port is it listening?

View 7 Replies View Related

Oracle Database Migration From 9iR2 / 10gR2 To 11gR2

Apr 22, 2013

Which is the best method for migration of database from Oracle 9iR2,10gR2 to 11gR2.

Current Environment
Operating System: Sun OS 5.10
Oracle Database: Oracle Database Enterprise Edition (32 bit)
Average Db Size: 600Gb
RAc Configuration: No
Operating System: Sun OS 5.10
Oracle Database: Oracle Database Enterprise Edition (64 bit)
Average Db Size: 600Gb
RAC Configuration: No

Proposed Environment
Server1 and Server2
Operating System: Sun Solaris 10
Oracle Database: Oracle Database Enterprise Edition (64 bit)
RAC Configuration: No
Hardware is New : Yes

View 2 Replies View Related

Forms :: Migrating Oracle 10gr2 From Windows To Linux

Feb 10, 2010

We are planning to migrate the forms application from windows to linux.

View 1 Replies View Related

Installation :: Oracle 10gR2 For Windows 7 64bit Processor?

Jul 10, 2012

I need to download Oracle 10g R2 for windows7 64bit processor. send the link

View 4 Replies View Related

Copyrights 2005-15, All rights reserved