CODEWITHSUNDEEP
c++oracle-databaseoracle-call-interfaceocci
user1139981
user1139981

Reputation: 31

Having issues using oracle's OTT utility

This is the command I run on the command prompt:

ott userid=username/password intype=object.typ outtype=objectOut.typ 
                code=cpp hfile=temp.h cppfile=temp.cpp mapfile=tempmapfile.cppset

This is the error i get:

O2T-1118, Unable to register the connection
O2T-102, ERROR: Unable to connect to schema "username"

I can't figure out how to properly register my connection. Can someone help shed some light on this issue I'm having?

Upvotes: 3

Views: 703

Answers (1)

liloew
liloew

Reputation: 21

As it says,your username or password is wrong.

I create a new user and connected:

SQL> create user ott identified by ott;

User created.

SQL> grant connect,resource to ott;

Grant succeeded.

SQL> conn ott/ott

Connected.
SQL>

Then create an object named ott_type:

SQL> create type ott_type as object
  2  (name varchar2(30),
  3   empno number,
  4   hiredate date);
  5  /

Type created.

SQL>

Then I create an intype file:

[oracle@db oracle]$ cat ott_typein.tpy
case=lower
type ott_type
[oracle@db oracle]$

Now I'll convert it using ott:

[oracle@db oracle]$ ott userid=ott/ott intype=ott_typein.tpy outtype=ott_typeout.tpy code=cpp \
> hfile=ott_type.h cppfile=ott_type.cpp mapfile=ott_type.cppset

OTT: Release 10.2.0.5.0 - Production on Thu Aug 15 13:02:21 CST 2013

Copyright (c) 1999, 2009, Oracle.  All rights reserved.

System default option values taken from: /u01/app/oracle/product/10.2.0/db_1/precomp/admin/ottcfg.cfg

We could see it successed!And we change the password for userid:

[oracle@db oracle]$ ott userid=ott/ottwrong intype=ott_typein.tpy outtype=ott_typeout.tpy code=cpp \
> hfile=ott_type.h cppfile=ott_type.cpp mapfile=ott_type.cppset

OTT: Release 10.2.0.5.0 - Production on Thu Aug 15 13:21:00 CST 2013

Copyright (c) 1999, 2009, Oracle.  All rights reserved.

System default option values taken from: /u01/app/oracle/product/10.2.0/db_1/precomp/admin/ottcfg.cfg

java.sql.SQLException: ORA-01017: invalid username/password; logon denied

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:692)
    at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:352)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:453)
    at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:133)
    at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:77)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:753)
    at java.sql.DriverManager.getConnection(DriverManager.java:512)
    at java.sql.DriverManager.getConnection(DriverManager.java:171)
    at oracle.ott.Konnection.getTheConnection(Konnection.java:110)
    at oracle.ott.Konnection.<init>(Konnection.java:39)
    at oracle.ott.Doit.main(Doit.java:98)
    at oracle.ott.c.CMain.main(CMain.java:9)

O2T-1117, Error reported by subsystem:
ORA-01017: invalid username/password; logon denied


O2T-102, ERROR: Unable to connect to schema "ott"

[oracle@db oracle]$

Upvotes: 1

Related Questions