1. Please help support our sponsors by considering their products and services.
    Our sponsors enable us to maintain high-speed Internet connection and fast webservers.
    They support this free information and knowledge exchange forum service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions

"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

    Jul 23, 2008
    Likes Received:

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

    Vilius M.

Share This Page