Oracle Advanced Security Administrator's Guide Release 9.0.1 Part Number A90150-01 |
|
This chapter describes how to connect to an Oracle database after installing Oracle DCE Integration, and configuring both DCE and Oracle to use Oracle DCE Integration.
This chapter contains the following topics:
To start the listener, do the following:
% dce_login principal_name password
% lsnrctl start listener_name
For example, if the listener name is LSNR_DCE in the listener.ora file, enter the following:
% dce_login oracle orapwd
% lsnrctl start LSNR_DCE
% rpccp show mapping
Look for the line that includes the dce_service_name
that is part of the listener address.
dce_service_nam
e as follows:
% cdscp show object "/.:/subsys/oracle/service_registry/dce_service_name"
For example:
The following command shows you the mapping in the CDS namespace that the listener has chosen for the endpoint:
% cdscp show object "/.:/subsys/oracle/service_registry/dce_svc"
SHOW
OBJECT /.../subsys/oracle/service_registry/dce_svc
AT 1999-05-15-17:10:52
RPC_ClassVersion = 0100
CDS_CTS = 1999-05-16-00:05:01.221106100/aa-00-04-00-3e-8c
CDS_UTS = 1999-05-16-00:05:01.443343100/aa-00-04-00-3e-8c
CDS_Class = RPC_Server
CDS_ClassVersion = 1.0
CDS_Towers = :
Tower = ncacn_ip_tcp:144.25.23.57[]
Connect to an Oracle server in the DCE environment using one of the following methods:
After externally-identified accounts have been set up, you can take advantage of DCE authentication to log into Oracle without providing any user name/password information. To use this single sign-on capability, just log in to DCE using a command like the following:
% dce_login principal_name password
For example:
% dce_login oracle orapwd
You can now connect to an Oracle server without using a user name or password. Enter a command like the following:
% sqlplus /@net_service_name
where net_service_name is the database service name.
For example:
% sqlplus /@ORADCE
From a client, you can still connect with a user name/password:
% sqlplus username/password@net_service_name
where net_service_name is the Oracle Net service name.
For example:
% sqlplus scott/tiger@ORADCE
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|