Home » RDBMS Server » Backup & Recovery » rman target xxx/xxx@tnsname (HP-UX Bsstest2 B.11.31 U ia64 Release 10.2.0.4.0 )
icon4.gif  rman target xxx/xxx@tnsname [message #529603] Wed, 02 November 2011 02:41 Go to next message
OracGPS
Messages: 17
Registered: April 2011
Junior Member
1.
$Bsstest2/oracle>tnsping ngtest

TNS Ping Utility for HPUX: Version 10.2.0.4.0 - Production on 02-NOV-2011 15:25:34

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:
/oracle/app/oracle/product/10.2.0/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (description= (address_list= (address=(protocol=tcp)(host=135.193.7.159)(port=1521))) (connect_data= (service_name=test)))
OK (0 msec)
$Bsstest2/oracle>sqlplus scott/tiger@ngtest

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Nov 2 15:26:04 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from session_privs;

PRIVILEGE
----------------------------------------
CREATE SESSION
UNLIMITED TABLESPACE
ALTER SESSION
CREATE TABLE
CREATE CLUSTER
CREATE SYNONYM
CREATE VIEW
CREATE SEQUENCE
CREATE DATABASE LINK
CREATE PROCEDURE
CREATE TRIGGER
CREATE TYPE
CREATE OPERATOR
CREATE INDEXTYPE

14 rows selected.

SQL> select * from session_roles;

ROLE
------------------------------
CONNECT
RESOURCE

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$Bsstest2/oracle>rman target scott/tiger@ngtest

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Nov 2 15:26:33 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

$Bsstest2/oracle>



---------------------------------------------------------------
2.
$ tnsping ngbilxx

TNS Ping Utility for HPUX: Version 10.2.0.4.0 - Production on 02-NOV-2011 15:27:37

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:
/oracle/app/oracle/product/10.2.0/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 135.193.7.138)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ngbilxx)))
OK (0 msec)
$ sqlplus billgto/billgto@ngbilxx

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Nov 2 15:28:01 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from session_privs;

PRIVILEGE
----------------------------------------
CREATE SESSION
UNLIMITED TABLESPACE
CREATE TABLE
CREATE CLUSTER
CREATE SEQUENCE
CREATE PROCEDURE
CREATE TRIGGER
CREATE TYPE
CREATE OPERATOR
CREATE INDEXTYPE

10 rows selected.

SQL> select * from session_roles;

ROLE
------------------------------
CONNECT
RESOURCE

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$ rman target billgto/billgto@ngbilxx
Recovery Manager: Release 10.2.0.4.0 - Production on Wed Nov 2 15:28:45 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: NGBIL (DBID=964462177)

RMAN>





i don't know why the second can connect rman with @tnsname .

anyone know this?

thanks.

i know when i grant sysdba to scott, the user scott can do this
: rman target scott/tiger@ngtest

but i can't grant sysdba to billgto, so why user billgto can connect like this : rman target billgto/billgto@ngbilxx
Re: rman target xxx/xxx@tnsname [message #529614 is a reply to message #529603] Wed, 02 November 2011 03:22 Go to previous messageGo to next message
OracGPS
Messages: 17
Registered: April 2011
Junior Member
in the second db ,I create another user t1. i can't connect like this: rman target t1/t1@ngbilxx .

It's magic!
Re: rman target xxx/xxx@tnsname [message #529637 is a reply to message #529614] Wed, 02 November 2011 04:34 Go to previous messageGo to next message
OracGPS
Messages: 17
Registered: April 2011
Junior Member
i found the reason.
when the SYSDBA privs to user . at the view SESSION_PRIVS and SESSION_ROLES we can't found.
we can found it with: strings orapw$SID.
Re: rman target xxx/xxx@tnsname [message #529638 is a reply to message #529637] Wed, 02 November 2011 04:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
or, better, query v$pwfile_users

Regards
Michel
Re: rman target xxx/xxx@tnsname [message #529652 is a reply to message #529638] Wed, 02 November 2011 05:09 Go to previous messageGo to next message
OracGPS
Messages: 17
Registered: April 2011
Junior Member
thanks. i know.
Re: rman target xxx/xxx@tnsname [message #529654 is a reply to message #529652] Wed, 02 November 2011 05:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So why do you mention a "hack" way to get the information if you know the correct one?

Regards
Michel
Re: rman target xxx/xxx@tnsname [message #529694 is a reply to message #529654] Wed, 02 November 2011 09:43 Go to previous message
OracGPS
Messages: 17
Registered: April 2011
Junior Member
before i don't remember v$pwfile_users.

it's you remand me. thanks.
Previous Topic: My question about incremental backup
Next Topic: set newname vs db_file_name_convert
Goto Forum:
  


Current Time: Thu Mar 28 08:23:41 CDT 2024