Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

unable to transfer files using ASMCMD in Oracle 11g Rel 2

707498Aug 3 2010
Gettin the followin error when using ASMCMD to transfer file to remote ASM instance in a different diskgroup.

ASMCMD> cp -ifr data/dbase/spfiledbase.ora sys@dbase_dr.1521.ASM:+DATA2/dbase
Enter password: *********
ORA-12545: Connect failed because target host or object does not exist (DBD ERROR: OCIServerAttach)
ASMCMD-08202: internal error: [asmcmdvol_error_msg_05] [8201]


Also tried to trace the error using export DBI_TRACE=1 getting the following messages

[grid@rac1 admin]$ asmcmd
DBI 1.602-ithread default trace level set to 0x0/1 (pid 17884) at DBI.pm line 273 via asmcmdshare.pm line 180
-> DBI->connect(dbi:Oracle:, , ****, HASH(0x8d51278))
-> DBI->install_driver(Oracle) for linux perl=5.010000 pid=17884 ruid=1100 euid=1100
install_driver: DBD::Oracle version 1.20 loaded from /u01/app/11.2.0/grid/perl/lib/site_perl/5.10.0/i686-linux-thread-multi/DBD/Oracle.pm
<- STORE('ShowErrorStatement', 1)= 1 at Oracle.pm line 62
<- install_driver= DBI::dr=HASH(0x90513d0)
<- DESTROY(DBI::st=HASH(9058b88))= undef at Oracle.pm line 234
<- connect('', '', ...)= DBI::db=HASH(0x9058ac8) at DBI.pm line 637
<- STORE('PrintError', 0)= 1 at DBI.pm line 689
<- STORE('AutoCommit', 1)= 1 at DBI.pm line 689
<- STORE('Username', '')= 1 at DBI.pm line 692
<> FETCH('Username')= '' ('Username' from cache) at DBI.pm line 692
$h->{'ora_session_mode'}=32768 ignored for invalid driver-specific attribute
<- STORE('ora_session_mode', 32768)= '' at DBI.pm line 692
<- FETCH('ora_session_mode')= undef at DBI.pm line 692
<- connected('dbi:Oracle:', '', ...)= undef at DBI.pm line 698
<- connect= DBI::db=HASH(0x9058ac8)
<- STORE('dbi_connect_closure', CODE(0x90585a8))= 1 at DBI.pm line 707
<- prepare('/* ASMCMD */ select version from v$instance')= DBI::st=HASH(0x88b46e0) at asmcmdshare.pm line 2438
<- execute= '0E0' at asmcmdshare.pm line 2462
<- fetchrow_hashref= HASH(0x87f1300)1keys row1 at asmcmdshare.pm line 2488
<- finish= 1 at asmcmdshare.pm line 2509
<- DESTROY(DBI::st=HASH(9058ae8))= undef at asmcmdcore line 388
ASMCMD> cp -ifr data/dbase/spfiledbase.ora sys@dbase_dr.1521.ASM:+DATA2/dbase/
Enter password: *********
-> DBI->connect(dbi:Oracle:host=dbase_dr;port=1521;sid=+ASM, sys, ****, HASH(0x9058ca8))
connect using '(DESCRIPTION=(ADDRESS=(HOST=dbase_dr)(PROTOCOL=tcp)(PORT=1521))(CONNECT_DATA=(SID=+ASM)))' !! ERROR: '12545' 'ORA-12545: Connect failed because target host or object does not exist (DBD ERROR: OCIServerAttach)' (err#0)
<- connect('host=dbase_dr;port=1521;sid=+ASM', 'sys', ...)= undef at DBI.pm line 637
DBI connect('host=dbase_dr;port=1521;sid=+ASM','sys',...) failed: ORA-12545: Connect failed because target host or object does not exist (DBD ERROR: OCIServerAttach)
ORA-12545: Connect failed because target host or object does not exist (DBD ERROR: OCIServerAttach)
ASMCMD-08202: internal error: [asmcmdvol_error_msg_05] [8201]
<- DESTROY(DBI::db=HASH(9058a38))= undef at asmcmdshare.pm line 410
!! ERROR: '12545' CLEARED by call to disconnect_all method
<- disconnect_all= (not implemented) at DBI.pm line 716
! <- DESTROY(DBI::dr=HASH(9058238))= undef during global destruction


Please help resolve this
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2010
Added on Aug 3 2010
0 comments
1,262 views