 rman target xxx/xxx@tnsname [message #529603] |
Wed, 02 November 2011 02:41  |
 |
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
