• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • 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.

  • 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

vilius.m

ADSM.ORG Senior Member
#1
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.
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 8 21.6%
  • Keep using TSM for Spectrum Protect.

    Votes: 19 51.4%
  • Let's be formal and just say Spectrum Protect

    Votes: 6 16.2%
  • Other (please comement)

    Votes: 4 10.8%

Forum statistics

Threads
30,969
Messages
131,783
Members
21,226
Latest member
rocaflqu
Top