OraFAQ Forum: Backup & Recovery » RMAN.exe file path

Home » RDBMS Server » Backup & Recovery » RMAN.exe file path

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN.exe file path [message #204000]

Fri, 17 November 2006 05:14

kamalakar_ora
Messages: 30
Registered: October 2006
Location: Bangalore

Member

Hi All,

I want to know how can we get RMAN.exe file path from all the versions of Oracle i.e, Oracle 9i, Oracle 10g...etc.

Is there any table or view which holds this path?

Is there any other way?

Please help me.

Regards,
Kamalakar.

Report message to a moderator

Re: RMAN.exe file path [message #204007 is a reply to message #204000]

Fri, 17 November 2006 05:24

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

It is always in $ORACLE_HOME/bin

Report message to a moderator

Re: RMAN.exe file path [message #204017 is a reply to message #204007]

Fri, 17 November 2006 06:08

kamalakar_ora
Messages: 30
Registered: October 2006
Location: Bangalore

Member

Hi Mahesh,

How can I get the full path of "$ORACLE_HOME/bin"?

May I know how can we resolve the $ symbol on Windows?

I have tried locating the path by placing the above path in at run but couldn't do that.

Regards,
Kamal

Report message to a moderator

Re: RMAN.exe file path [message #204024 is a reply to message #204017]

Fri, 17 November 2006 06:26

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

ORACLE_HOME is something you defined.
You can get it from your environment variable. Use the SET command in command prompt.
Or may even from the registry. I am not a windows guy and may be wrong.

Report message to a moderator

Re: RMAN.exe file path [message #204115 is a reply to message #204017]

Fri, 17 November 2006 22:39

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

May I know how can we resolve the $ symbol on Windows?

if is *nix prompt ( normal user) it is not related to windows.

I have tried locating the path by placing the above path in at run but couldn't do that.

try this way
cmd ( command prompt on windows platform.)

cmd>set oracle_sid="put_ur_database_sid"
cmd>rman ( enter) see what happen ... if run successfullly then i will ask you for user id and password.

hope this helps.
Mohammad Taj.

Report message to a moderator

Re: RMAN.exe file path [message #204128 is a reply to message #204115]

Sat, 18 November 2006 00:54

kamalakar_ora
Messages: 30
Registered: October 2006
Location: Bangalore

Member

Hi Taj,

It gave me the RMAN command prompt as following:

C:\Documents and Settings\Administrator>set oracle_sid="STREAMDB"

C:\Documents and Settings\Administrator>rman

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN>

Regards,
Kamalakar.

Report message to a moderator

Re: RMAN.exe file path [message #204129 is a reply to message #204128]

Sat, 18 November 2006 00:56

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi
so now ur problem is solved?

regards
taj.

Report message to a moderator

Re: RMAN.exe file path [message #204132 is a reply to message #204129]

Sat, 18 November 2006 01:13

kamalakar_ora
Messages: 30
Registered: October 2006
Location: Bangalore

Member

Hi Taj,

It's not been solved. I am getting the following error when I try to connect to the database.

RMAN> connect target/

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12560: TNS:protocol adapter error

RMAN>

Regards,
Kamalakar.

Report message to a moderator

Re: RMAN.exe file path [message #204134 is a reply to message #204129]

Sat, 18 November 2006 01:15

kamalakar_ora
Messages: 30
Registered: October 2006
Location: Bangalore

Member

Hi Taj.

The problem hasn't been resolved. I am getting the following error when I try to connect to a database. What can I do?

RMAN> connect target/

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12560: TNS:protocol adapter error

RMAN>

Regards,
Kamal

Report message to a moderator

Re: RMAN.exe file path [message #204135 is a reply to message #204132]

Sat, 18 November 2006 01:16

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi ...
try this way.

cmd>set oracle_sid="put_ur_database_name"
cmd>rman target=sys (enter)
or
cmd>rman target=sys@"put_ur_dbname"

first check target database services is start...

hope this helps
MOhammad Taj.

Report message to a moderator

Re: RMAN.exe file path [message #204138 is a reply to message #204135]

Sat, 18 November 2006 01:25

kamalakar_ora
Messages: 30
Registered: October 2006
Location: Bangalore

Member

Hi Taj,

I got it and the it gave the following result.

C:\Documents and Settings\Administrator>rman target=sys@streamdb

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

target database Password:
connected to target database: STREAMDB (DBID=1529088765)

RMAN>

But I wanted get the RMAN.exe path.

Q1). Is there any table or view which holds RMAN path?

Q2). Is there any unique value in the registry using that I can get RMAN?

Regards,
Kamalakar.

Report message to a moderator

Re: RMAN.exe file path [message #204139 is a reply to message #204138]

Sat, 18 November 2006 01:35

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

HI
Q1). Is there any table or view which holds RMAN path?

NO.. in Oracle No..( As far as i know)

Q2). Is there any unique value in the registry using that I can get RMAN?

rman.exe is executable file and all executable files in Oracle Stored in Oracle-home / bin folder...but i you want to reallocate .exe location...through PATH enviourment variable.

bcoz PATH enviourment variable Oracle find all executable files.

C:\>set oracle_sid=orcl

C:\>rman target=sys
'rman' is not recognized as an internal or external command,
operable program or batch file.

C:\>set PATH=c:\test

C:\>rman target=sys

Recovery Manager: Release 10.1.0.2.0 - Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

target database Password:
connected to target database: ORCL (DBID=1134346023)

RMAN>

i am just give example. oracle-home/bin is default path in Oracle for all executable files so plz. don't do that...

and in registary i was not get any "key" related to RMAN.

hope this helps.

MOhammad taj.

Report message to a moderator

Previous Topic:	impbp question
Next Topic:	Password file errors after RMAN duplication

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 10:27:49 CDT 2024