RMAN :: Unable To Configure FSA (11g R1 Windows)

Jun 26, 2012

I've been asked to configure RMAN on an existing Oracle 11g R1 database running on Windows Server 2003 (32-bit) & when I connect using RMAN client to the database instance, I'm getting the following error setting the Fast Recovery Area and don't know why:

C:>rman target /

Recovery Manager: Release 11.1.0.7.0 - Production on Mon Jun 25 14:39:45 2012
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
connected to target database: ORCL11G (DBID=825621007)

RMAN> shutdown immediate;

using target database control file instead of recovery catalog

database closed
database dismounted
Oracle instance shut down
[code]....

RMAN-01007: at line 1 column 1 file: standard inputAccording to Oracle documentation, I appear to be entering the correct command sequence but it's not working for some reason..

View 6 Replies


ADVERTISEMENT

RAC & Failsafe :: Unable To Configure SSH For RAC

Dec 30, 2010

I am trying to install oracle 10g RAC on CentOS release 5.4 (Final), But when I am not able to configure SSH between oracle users on both node.

Node 1
--------
[oracle@node1 ~]$ id
uid=600(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)
[oracle@node1 ~]$ date
Thu Dec 30 05:14:10 IST 2010
[oracle@node1 ~]$
------------
Node2
----------
[oracle@node2 ~]$ id
uid=600(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)
[oracle@node2 ~]$ date
Thu Dec 30 05:15:32 IST 2010
[oracle@node2 ~]$
---------
OS
----------
[oracle@node2 .ssh]$ cat /etc/redhat-release
CentOS release 5.4 (Final)
[oracle@node2 .ssh]$ date
---------
Host for both node
--------
[oracle@node2 .ssh]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
# Public
10.1.1.10 node1
10.1.1.11 node2
#Private
20.1.1.10 node1-priv
20.1.1.11 node2-priv
#Virtual
10.1.1.21 node1-vip
10.1.1.22 node2-vip
------------------------
I am using the command to configure SSH provide in the link

[URL].......

View 7 Replies View Related

Windows :: Cannot Configure Listener

Aug 31, 2013

I've been trying to rebuild our Oracle 11g server. I started off by wiping Oracle completely and kicked off the install again. The install goes smoothly, but does not create the Listener. I've been trying to use netca to create it myself. The below is the output from netca:

Listner Control complete.
Listener start failed.

Looking in the netca trace file, I see the following error (note I'm only including the error with a few lines before):

[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:91] NativeResult: The String obtained is1|SUCCESSFUL
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:99] The status string is: 1
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:112] The result string is: SUCCESSFUL 1
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [WindowsSystem.deleteService:787] _WS_: deleting service2 OracleRemExecService on AUSYD5756 ignoreNotExist = true
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [WindowsSystem.deleteService:793] _WS_ deleteService2: node AUSYD5756 Service OracleRemExecService result: 0|Access is denied.
[code]....

The OracleRemExecService services does not exist. I've tried re-installing the whole instance a number of times but each time I hit this error.

View 12 Replies View Related

Configure RMAN Backup To Disk?

May 27, 2011

Am trying to configure rman to backup to a directory to a linux server on the network. Database is on windows server. Here is the parameter changes

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '\\204.47.240.126\bexdisk\backup\%U'
;
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oraback/rman/sde_backups/%U';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

Here is my rman script

ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
run
{
crosscheck archivelog all;

[Code]....

instead its backups but to my ORACLE_HOME\database directory..

how to configure rman to backup to this location

View 1 Replies View Related

RAC & Failsafe :: Windows 2003 X 64 Using NAS - How To Configure Shared Storage

Aug 14, 2008

we don't have system or storage admin available..I have to create the development environment. I have 2 Dell 2950 Power Edgde Servers and 500 GB Buffalo NAS with Windows 2K3 X64 EE, tell me whether I can install Oracle RAC with this kit.

If yes , how can I configure shared storage and present it to OS so that both nodes can see it.

View 6 Replies View Related

Windows :: Unable To Install Oracle 10g Client On 64bit Windows 2008

Jul 16, 2008

We have a .NET application on windows server 2008 32bit using the stored procedures on an Oracle 10g environment. We are trying to deploy the .NET application onto a 64bit x86 Windows server 2008.

We face an error trying to install the x64 version of the Oracle 10g client on windows 2008. The error we get is Problem signature:

Problem Event Name: APPCRASH
Application Name: javaw.exe

Is the x64 version of the Oracle 10g client certified for Windows 2008? Has anyone successfully installed the 64bit version of the oracle client on win2008?

We have a workaround in place with 32 bit version of the client running with the 32 bit version of the .NET application on x64 win2008. However to maximize the infrastructure we need to use the 64 bit version or we would have to turn to MSSQL Server .

View 4 Replies View Related

Enterprise Manager :: Configure Data Guard Setup - Oracle 10gR2 And Windows XP

Jan 18, 2011

i want to configure my present Data Guard Setup with Enterprise Manager...and on the Enterprise Manager grid control page i am not seeing any Data Guard option.....i am using oracle 10gR2 and Windows XP.

How to use enterprise manager for configuring Data Guard.

View 9 Replies View Related

Recovery Manager (RMAN) :: Script / Daily Incremental Backups With Configure Commands For Oracle 11g Database

Aug 29, 2012

the rman backup script for weekly full backup and daily incremental backups with configure commands for oracle 11g database.

View 10 Replies View Related

Backup & Recovery :: How To Configure RMAN For Specific Backup Strategy

Jan 11, 2012

We have production database.We would like to have 15 last online full backups (sheduled once a day) and to be possible to restore database to a point in time only between last backup and current time.

If I configure retention window for 15 days, archive redo logs in last 15 days are also backed up, and this consumes lot of space, which is a problem here (database files and arhive logs are of a huge size).(There is enough space for 15 full backups and archive log for one day though)

How to configure RMAN for this?I was thinking about configuring retention policy for 15 days and adding this lines at the and of a daily RMAN cronjob:

backup archivelog all not backed up;
CROSSCHECK BACKUP DEVICE TYPE DISK;
DELETE NOPROMPT ARCHIVELOG ALL;

View 6 Replies View Related

Backup & Recovery :: Configure RMAN To Work With Net Backup?

Jul 25, 2013

I have one question about oracle 10g data guard :

1.What is net backup team and how to configure RMAN to work with net backup?

View 3 Replies View Related

Windows :: Unable To Install Oracle 10g On Win 7

Jan 8, 2011

Is oracle 10g availble for Windows 7, I downloaded oracle 10g from ORACLE'S website. The name of the file is "10203_ vista_ w2k8_ x86_ production_ db.zip" but when I m installing it, I m getting error at the very beginning regarding the system requirements failure.

below is the message which i receive at the PRODUCT-SPECIFIC PREREQUISITE CHECK
======================================
Checking operating system requirements ...

Expected result: One of 5.0,5.1,5.2,6.0
Actual Result: 6.1
Check complete. The overall result of this check is: Failed <<<<
Problem: Oracle Database 10g is not certified on the current operating system.
Recommendation: Make sure you are installing the software on the correct platform.
=======================================================================
[code]....

View 6 Replies View Related

Unable To Create Database On Windows 7

Apr 3, 2013

I installed Oracle 10g XE on windows7 to create a database i opened "start database command interface" and created an SID and followed some steps afterwards i am facing "TNS ADAPTER NOT FOUND"

View 7 Replies View Related

Windows / .NET :: Unable To Connect Database From SQL Dev

Nov 21, 2012

Am getting the following error while connecting db from sql dev "network adapter could not establish connection vendor code 20"

FYI - database is up and running fine in sqlplus, and am not able to find the service in lnsrctl. As am using OIM db as service name while its showing CLRExtProc.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Prod
ction
Start Date 21-NOV-2012 20:28:48
Uptime 0 days 0 hr. 27 min. 32 sec
Trace Level off
[code].....

View 2 Replies View Related

RMAN :: Unable To Take Backup After Upgrade From 10g To 11gr2

Dec 5, 2012

After upgrading db from 10 g to 11g ,unable to take rman backup.catlog also upgraded.SCAN listsner alos running

ps -ef |grep tns
oracle 13235 13215 0 13:23:55 pts/3 0:00 grep tns
oracle 2968 1 0 Dec 2 ? 0:47 /crshome_new/oracle/11.2.0/grid/bin/tnslsnr LISTENER_SCAN3 -inherit
oracle 2997 1 0 Dec 2 ? 0:51 /crshome_new/oracle/11.2.0/grid/bin/tnslsnr LISTENER_SCAN2 -inherit
oracle 19844 1 0 Dec 3 ? 0:30 /orahome_new/oracle/product/11.2.0/bin/tnslsnr LISTENER_DB -inherit
[code]....

View 2 Replies View Related

RMAN :: Duplicate On New Windows Box With Different Dir Structure?

Aug 17, 2012

duplicate rman on new windows box with different dir structure

View 9 Replies View Related

Enterprise Manager / Unable To Work On Windows?

Apr 21, 2011

I attempt to log to the Enterprise Manager via --> [URL] but I only receive the 'Page not found' error

As this is on a windows server I attempt to restart the service to no avail Also I try to start emctl start dbconsole - whcih also does not work

The Listener is up and running

If I issue a emctl status oms - I receive error Oracle Enterprise Manager 10g Grid Control not installed. Request Ignored.

with --> emctl status dbconsole

output is Oracle Enterprise Manager 10g is not running.

Logfiles:

Logs are generated in directory D:\oracle\product\10.2.0\db_1/ukedgas71.pcroot.com_OEMREP/sysman/log

Logfiles:

Directory of D:\oracle\product\10.2.0\db_1\UKEDGAS71.pcroot.com _OEMREP\sysman\log

20/04/2011 15:06 10,297 emagent.log
05/06/2009 09:48 0 emagentfetchlet.log
05/06/2009 09:46 0 emdctl.log
20/04/2011 15:05 6,363,995 emoms.log
20/04/2011 15:14 29 OracleDBConsoleOEMREPexit.log
20/04/2011 15:14 188,284 OracleDBConsoleOEMREPsrvc.log
05/06/2009 09:46 4,383 secure.log
7 File(s) 6,566,988 bytes

Tracefiles:

Directory of D:\oracle\product\10.2.0\db_1\UKEDGAS71.pcroot.com _OEMREP\sysman\log

20/04/2011 15:14 1,418,777 emagent.trc
05/06/2009 09:48 0 emagentfetchlet.trc
28/11/2009 16:21 8,360 emagent_perl.trc
21/04/2011 11:12 2,060,670 emdctl.trc
20/04/2011 15:05 1,649,464 emoms.trc
5 File(s) 5,137,271 bytes
0 Dir(s) 3,274,207,232 bytes free

View 14 Replies View Related

Windows :: Unable To Install Oracle Client?

Jan 4, 2012

We are unable install oracle 10g client it is showing error error in writing directory c:Docume~1admin~1locals~1emporainstall2012-01-04_08-05-38PM. ensure that this directory is writable and has atlest 45MB of disk space . Installation cannot continue

View 3 Replies View Related

Windows :: Unable To Connect SQLState IM004

Jan 10, 2007

I installed 10.2 client on Windows 2000 Terminal Server. I created the system dsn odbc connection. When connected to the terminal server via RDP as a domain administrator, the odbc connection functions appropriately. When connected to the terminal server console as a standard user, the odbc connection functions appropriately.When connected to the terminal server via RDP as a standard user, I get the error: "Unable to connect SQLState= IM004 [[Microsoft]][[ODBC Driver Manager]] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

I have reviewed the numerous other posts regarding this error and I've executed the following recommendations: My oracle_home is defined first in my path environment variable (path - c:oracleclientin;). I select my folder options (there is no security tab, windows 2000) I select sharing, then permissions. I allow 'Everyone' and 'Authenticated Users' full control, change & read permissions. I reboot the server.

View 4 Replies View Related

Windows :: Unable To Kill A Session Using Orakill

Sep 25, 2012

Iam unable to kill one database session, Today i killed one session

alter system kill session '418,12499'

but status shows as killed but process still exits in OSLevel

SQL> select sid,serial#,status from gv$session where sid=418;

SID SERIAL# STATUS
---------- ---------- --------
418 12499 KILLED

we all know we can kill by using ORAKIL but still we unable to kill

SQL> select spid from v$process a, v$session b where a.addr = b.paddr and b.sid = '418';

SPID
------------
5644

i killed using orakill

C:Documents and SettingsAdministrator>orakill oraci 5644

Kill of thread id 5644 in instance oraci successfully signaled. but still process exits in os level also i notice below error in alert log

orakill: ssthreadkill(tid=5644) unable to get the thread list mutex: err=0

View 3 Replies View Related

Windows :: Unable To Find DLL Library File

Nov 21, 2012

We are getting below error....Our one package called orawpcom.dll library file.

ERROR at line 1:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: Unable to find library
'/oracle9i/app/product/11.1.0.7.0inorawpcom.dll'.
ORA-06512: at "GFSAM.OAINVOKEDOUBLE", line 1
ORA-06512: at "GFSAM.ORDCOM", line 229
ORA-06512: at "GFSAM.ORDEXCELSB", line 450
ORA-06512: at line 43
ORA-06520: PL/SQL: Error loading external library
ORA-06522: Unable to find library

Attach this orawpcom.dll file?

View 1 Replies View Related

Enterprise Manager :: Configure Enterprise Manager In Windows 2003 Server?

Aug 21, 2010

I am having a database running in my windows 2003 server and I want to configure Enterprise manager for that database to check the resource utilization during the peak hours and also the number of transactions...

View 1 Replies View Related

Recovery Manager (RMAN) :: Unable To Register Database?

Aug 15, 2013

 RMAN> register database; RMAN-00571:

===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of register command at 08/15/2013 19:48:59RMAN-03014: implicit resync of recovery catalog failedRMAN-03009: failure of full resync command on default channel at 08/15/2013 19:48:59ORA-01580: error creating control backup file +ORALIN_RECO/snapcf_oralin.fORA-
[code][....

View 2 Replies View Related

RAC & Failsafe :: RMAN Backup / Unable To Open Database

Aug 31, 2013

I tried to run the duplicate script after transferring new rman backup to standby. Even after transferring the backup, duplicate command and was unable to open the database.

View 1 Replies View Related

Server Administration :: Unable To Connect Both SQL And RMAN Prompt?

Jul 21, 2011

now DB is hanging; i am not able to connect both SQL and RMAN prompt. Is it possibel to move some old archives using ASMCMD prompt to datafile mount point location? Once i got some free space, then i can try connect RMAN and fire my script manually to take the backup and delete the same. ....

ASMCMD [+QSTAGE_T1_BACKUP_01/QSTAGE/ARCHIVELOG] > ls -ltr
cdType Redund Striped Time Sys Name
Y 2011_07_15/
Y 2011_07_16/
Y 2011_07_17/
Y 2011_07_18/
Y 2011_07_19/
Y 2011_07_20/
i have free space at mount point : +QSTAGE_T1_DATA_01/QSTAGE/DATAFILE

i need to backup the archives first before deletion..as those are required for Streams.

backup script:

run {
backup archivelog all delete completed before 'sysdate-1';
}

note: i would like to remove the file which are older than one day

View 8 Replies View Related

Unable To Deleted Archive Log File On Windows Server?

Sep 20, 2010

version: 10.2.0.4
OS: windows server 2003

I am not able to delete one month old archive log file manually on windows which doesn't having info about the standby on v$archived_log view of primary database. the sequence were already applied to the standby database. It shows the status as deleted in v$archived_log. while deleting the file manually. it showing an error like another program or person is using it.

View 10 Replies View Related

Windows :: Unable To Continue Oracle 11g Release 2 Installation

Jul 24, 2013

I was prompted by an error in the middle of Oracle 11g Release 2 installation and unable to continue further.

The error was file not found e:product11.2.0.dbhome_3oc4jj2eeoc4j_applicationsapplications em.ear.

View 2 Replies View Related

Windows :: Unable To Install Oracle 11gR2 On Win 7 Professional?

Mar 28, 2012

I am trying to install Oracle 11g R2 on Windows 7 professional at the time of database creation they give error.

ORA-12638:Credential retrival failed.

View 9 Replies View Related

Windows :: Unable To Delete SMON Trace File?

Oct 4, 2012

In my database smon tracefile was huge,now we want to delete the same,I also tried with ordebug operation but no use, delete tracfile which Smon generates.

View 5 Replies View Related

Unable To Create Database (Oracle 12c R1 12.1.0.1.0 / Windows 2012 )

Aug 30, 2013

I have been trying out the new 12c on Windows 2012 Essentials with the same type of errors.  The OraDim step fails and cannot create the services.  It fails a bit differently if I choose "Create New Windows User", choose a "Use Existing Windows User", or choose the Windows Built-in user. 

View 3 Replies View Related

Backup & Recovery :: Windows RMAN - Bat File Using Variable?

Oct 16, 2012

I'm trying to write a bat file for the rman backups that can be used for any of our databases. I'm passing variables into the bat file and that is working fine (i.e. oracle_sid, drive letter, oracle_home), my problem is when the rman actually runs and calls the ctl file, the variables aren't being passed thru to that file.

View 3 Replies View Related







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