Connecting to an Oracle Database in DCE
Connecting to an Oracle Database Server in the DCE Environment
This chapter shows how to connect to an Oracle database after having installed Oracle DCE Integration, and having configured both DCE and Oracle to use Oracle DCE Integration.
Starting the SQL*Net Version 2 Listener
To start the SQL*Net V2 listener, do the following:
1. To start the listener, enter the following commands:
% dce_login principal_name password
% lsnrctl start listener_name
For example, if the listener name is LSNR_DCE in LISTENER.ORA, enter the following to start the listener:
% dce_login oracle orapwd
To make sure the server registered its binding handler with rpcd, enter:
In the computer response, look for the line that includes the dce_service_name that is part of the listener address.
2. To make sure the service has been created, search for the dce_service_name as follows:
% cdscp show object "/.:/subsys/oracle/service_registry/dce_service_name"
% cdscp show object "/.:/subsys/oracle/service_registry/dce_svc"
This shows you the mapping in the CDS namespace that the listener has chosen for the endpoint. For example:
SHOW
OBJECT /.../subsys/oracle/service_registry/dce_svc
AT 1995-05-15-17:10:52
RPC_ClassVersion = 0100
CDS_CTS = 1995-05-16-00:05:01.221106100/aa-00-04-00-3e-8c CDS_UTS = 1995-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[]
Connecting to an Oracle Database Server in the DCE Environment
To connect to an Oracle server in the DCE environment, do one of the following:
% dce_login principal_name password
% dce_login oracle orapwd
Note: You only need to enter the dce_login command once. If you are already logged into DCE, you do not need to log in again.
You can now connect to an Oracle Server without using a username or password. Enter a command like the following:
where service_name is the SQL*Net service name.
2. From a client, you can still connect with a username/password:
% sqlplus username/password@service_name
where service_name is the SQL*Net service name.
% sqlplus scott/tiger@ORADCE
