Home » RDBMS Server » Backup & Recovery » RMAN.exe file path
RMAN.exe file path [message #204000] Fri, 17 November 2006 05:14 Go to next message
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.
Re: RMAN.exe file path [message #204007 is a reply to message #204000] Fri, 17 November 2006 05:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It is always in $ORACLE_HOME/bin
Re: RMAN.exe file path [message #204017 is a reply to message #204007] Fri, 17 November 2006 06:08 Go to previous messageGo to next message
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
Re: RMAN.exe file path [message #204024 is a reply to message #204017] Fri, 17 November 2006 06:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: RMAN.exe file path [message #204115 is a reply to message #204017] Fri, 17 November 2006 22:39 Go to previous messageGo to next message
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.
Re: RMAN.exe file path [message #204128 is a reply to message #204115] Sat, 18 November 2006 00:54 Go to previous messageGo to next message
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.
Re: RMAN.exe file path [message #204129 is a reply to message #204128] Sat, 18 November 2006 00:56 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi
so now ur problem is solved?

regards
taj.
Re: RMAN.exe file path [message #204132 is a reply to message #204129] Sat, 18 November 2006 01:13 Go to previous messageGo to next message
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.
Re: RMAN.exe file path [message #204134 is a reply to message #204129] Sat, 18 November 2006 01:15 Go to previous messageGo to next message
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
Re: RMAN.exe file path [message #204135 is a reply to message #204132] Sat, 18 November 2006 01:16 Go to previous messageGo to next message
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.
Re: RMAN.exe file path [message #204138 is a reply to message #204135] Sat, 18 November 2006 01:25 Go to previous messageGo to next message
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.


Re: RMAN.exe file path [message #204139 is a reply to message #204138] Sat, 18 November 2006 01:35 Go to previous message
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.
Previous Topic: impbp question
Next Topic: Password file errors after RMAN duplication
Goto Forum:
  


Current Time: Sat Dec 10 04:59:07 CST 2016

Total time taken to generate the page: 0.09348 seconds