473,503 Members | 10,245 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to connect with rman

5 New Member
SIR AS IAM USING ORACLE 10G RELEASE 2 IN RED HAT LINUX AS4,
AS I CREATED ONE DATABASE NAMED AS <BSNL>..AND THE DEFAULT DATABASE IS ORCL.
I ALREADY SET BSNL IN TNSNAMES.ORA AND ALSO IN LISTENER.ORA.
PLZ TEL ME VERY STARTING PROCEDURE TO CONNET TO RMAN.
IF IAM ENTERING AS
$rman
iam getting as cant open target database...
please help me.
Nov 26 '09 #1
9 11396
jsmithstl
14 New Member
make sure your environment is setup correctly.

set your ORACLE_SID to the database you wish to connect to:

export ORACLE_SID=BSNL

rman
connect target /
Nov 28 '09 #2
prabukrishnan
3 New Member
Check
1. whether you are able to tnsping the target DB
2,if yes check you are able to login using sql plus
Dec 1 '09 #3
mdfaraz
5 New Member
HELLO,
I HAVE TWO DATABASE NAMED AS
1.AIRTEL
2.BSNL
BOTH ARE IN ARCHIVE LOG MODE
AT LISTENER I ENTERED THIS
-----------------------------------------------------------------------------------------------------
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME= bsnl)
(ORACLE_HOME=/opt/oracle)

)
(SID_DESC=
(SID_NAME= airtel)
(ORACLE_HOME=/opt/oracle)

)
)
Listener =
(DESCRIPTION_LIST=
(DESCRIPTION =
(Address= (Protocol= TCP) (Host = localhost.localdomain)(Port= 1521))
)
)
--------------------------------------------------------------------------------------------------
AT CLIENT
-------------------------------------------------------------------------------------------------------

bsnl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (Protocol = TCP)(Host=localhost.localdomain)(Port = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME= bsnl)
))
airtel =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (Protocol = TCP)(Host=localhost.localdomain)(Port = 1521))

(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME= airtel)
)
)
.................................................. ............................................
when iam entering $tnsping bsnl
its throughing an error TNS:12533 : TNS :ILLEGAL ADDRESS PARAMETRES

PLEASE CHECK THE ABOVE ONE
Dec 2 '09 #4
prabukrishnan
3 New Member
can you post the result of the command "lsnrctl service"
Dec 2 '09 #5
mdfaraz
5 New Member
WHEN I ENTER
LSNRCTL>service bsnl
TNS-12541: no listener
TNS-12560: protocal error
TNS-00511: no listener
Dec 2 '09 #6
mdfaraz
5 New Member
linux error:111: connection refused
Dec 2 '09 #7
prabukrishnan
3 New Member
seems there is no listener ...
create the listener and start it..
Dec 2 '09 #8
mdfaraz
5 New Member
sir how to create listener...
Dec 2 '09 #9
jsmithstl
14 New Member
Once you put the entries in your lsnrctl.ora file, did you stop and restart the listener?

lsnrctl stop
lsnrctl start

Once you've restarted the listener, do as Prabukrishnan suggested. Run the following from the command line and paste the output in here.

lsnrctl services

Also, can you paste the contents of your sqlnet.ora file as well?
Dec 2 '09 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

3
11085
by: sunilwarrier | last post by:
I found a few documents on this topic, but didn't resolve my issue. I am trying to restore an RMAN backup to a different host (with a differnet instance name) from where the backup was taken. ...
1
4631
by: steve | last post by:
Hi, I am using the java database manager on oracle 9i linux , to monitor and modify my oracle 9i system. there is a wizard that allows the setting up of an rman job. I had setup a backup...
1
5075
by: RYAN | last post by:
Hi All, I am new to Oracle and I have some question that I hope that someone out there can help me. I have heard the Oracle Rman can do replication of Archives logs. In this way, one can...
2
2488
by: Tho Nguyen | last post by:
Hi, folks! I am new to RMAN and now trying to configure it. There is one issue concerning me. Let's say I backup the target database every 6:PM and the database generates about 100 archived...
0
2910
by: TX-DBA | last post by:
#####Background 1) CRONJOB runs 2 RMAN shell scripts at 3AM backup_begin.sh- export and rman backups report_begin.sh- list rman reports My report_begin.sh script, which was messed up, was...
2
3344
by: Alex | last post by:
Hi all Is possible with RMAN recover only one table of my db? Where can i find some infromation about this? If is not possible , where can i find products to make this? Is possible to restore...
0
1052
by: rmli | last post by:
Duplicating a Database using RMAN http://quickdba.blogspot.com/2006/05/duplicating-database-using-rman_22.html
0
1201
by: gohel | last post by:
I have cofigured rman on linux with oracle 9i (catdb) as revecory catalog db and target db is on win XP with oracle 9i in archive log mode , Now problm is I want backup of target DB (targdb)...
0
3998
by: gunsbong | last post by:
hello again everybody.. i just copied the backup file from production to another server with the same config with the production...when i restore the copied backup file this message appears......
0
7067
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7316
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6975
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7449
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5562
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
3160
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3148
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
728
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
371
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.