1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

"tdposync syncdb" windows os user member of ora_dba

Discussion in 'Oracle' started by vilius.m, Jul 23, 2017.

  1. vilius.m

    vilius.m ADSM.ORG Senior Member

    Joined:
    Jul 23, 2008
    Messages:
    67
    Likes Received:
    4
    Hello,

    Oracle installed on Windows, oracle services and tsm scheduler for oracle service are running as windows user which is member of ora_dba group. Lets say its oracle1.
    If I logon as oracle1 I have no trouble connectting to oracle using sqlplus or rman:
    Code:
    > sqlplus / as sysdba
    ....
    > rman target /
    ....
    "tdpoconf showenvironment" also works with no problem.

    How do I use "tdposync syncdb" command in this case, since it keeps asking username, password and connect string:
    Code:
    > tdposync syncdb -nocatalog
    IBM Tivoli Storage Manager for Databases:
    Data Protection for Oracle
    Version 7, Release 1, Level 0.0
    (C) Copyright IBM Corporation 1997, 2013. All rights reserved.
    
    From Date (01/01/1990):
    To Date (07/24/2017):
    Oracle Database 1 User Name:
    Oracle database 1 Password: ********
    Oracle database 1 Connect String:
    
    Gathering Catalog information...Please wait
    SQL*Plus: Release x.x.x.x.x Production on xx xxx xx 01:10:31 2017
    Copyright (c) 1982, 2010, Oracle.  All rights reserved.
    SP2-0306: Invalid option.
    Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
    where <logon> ::= <username>[/<password>][@<connect_identifier>]
          <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
    SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus
    ANU2533E SQLPLUS error
    As "User Name" I tried "oracle1", "/" but result is the same.
    I don't even know what to provide for "Connect String".

    What are correct parameters when connecton to oracle is configured as ora_dba windows group member user ?

    thanks,
    Vilius M.
     
  2.  

Share This Page