Oracle Advanced Networking Option Administrator's Guide
Release 8.0.3

A54084_01

Library

Product

Contents

Index

Prev Next

12

Connecting to an Oracle Database in DCE

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.

This information includes the following:

12.1 Starting the Network Listener

To start the Net8 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
    % lsnrctl start LSNR_DCE
    
    

    To make sure the server registered its binding handler with rpcd,enter:

    % rpccp show mapping
    
    

    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"
    
    

    For example:

    % 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[]
    

12.2 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:

  1. After externally-identified accounts have been set up, you can take advantage of DCE authentication to log into Oracle without providing any username/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
    
    
    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:

    % sqlplus /@service_name
    
    

    where service_name is the database service name.

    For example:

    % sqlplus /@ORADCE
    
    

    Refer to "Creating and Naming Externally-Identified Accounts" for information, and to Oracle8 Server Distributed Databases for information on external authentication.

  2. From a client, you can still connect with a username/password:
    % sqlplus username/password@service_name
    
    

    where service_name is the Net8 service name.

    For example:

    % sqlplus scott/tiger@ORADCE
    



Prev

Next
Oracle
Copyright © 1997 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index