Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2011
    Posts
    9

    Unanswered: Pro*COBOL unable to log on to Oracle using OS Authentication

    To validate your embedded SQL you need to specify SQLCHECK={FULL|SEMANTICS}. With this you need to specify a userid to log on to the database in the cfg file.

    Code:
    USERID=username/password[@dbname]
    If I specify
    Code:
    USERID=/
    or
    Code:
    USERID=/@dbname
    or
    Code:
    USERID="/ AS SYSDBA"
    it returns

    COBPR0000S 000550:Unable to log on to ORACLE with "". ORACLE error number: 1017
    which I guess equates to

    ORA-01017: invalid username/password; logon denied
    And if I specify
    Code:
    USERID="/@dbname AS SYSDBA"
    it returns

    COBPR0000S 000550:Unable to log on to ORACLE with "". ORACLE error number: 12154
    which I guess equates to

    ORA-12154: TNS:could not resolve service name
    How do I get Pro*COBOL to log on using OS authentication?

    Mark.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    We need to understand from which Operating System/server you are trying to use Pro*COBOL
    relative to the DB Server system.

    Are you logged onto DB Server itself trying to use Pro*COBOL?
    If so, then no SQL*Net access is required.
    As which OS user are you logged onto OS?

    do as below so we can know complete Oracle version & OS name.

    Post via COPY & PASTE complete results of
    SELECT * from v$version;
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2011
    Posts
    9
    BANNER
    --------------------------------------------------------

    Oracle Database 11g Release 11.2.0.1.0 - Production
    PL/SQL Release 11.2.0.1.0 - Production
    CORE 11.2.0.1.0 Production
    TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
    NLSRTL Version 11.2.0.1.0 - Production
    I'm logged in to Windows XP and trying to compile Oracle embedded SQL using Net Express 5.1 COBOL compiler which in turn calls the Pro*COBOL pre-compiler.

    Mark.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •