Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Don't know how to find "connect string" when opening Oracle Designer

990784Feb 13 2013
Hi, I want to install Oracle Designer for demonstration purposes, I only need just a working Oralce Designer. I downloaded Oracle Designer 10gR2 but when I tried to install it, it said I need to install Oracle Developer suite, so I downloaded Oracle Developer Suite 10g (10.1.2.0.2). It had dick 1 and 2 zipped files, I unzipped and installed them. Then I tried to install Oracle Designer 10gR2 again, but it said operating system version failed. I don't know if it meant this, My OS is windows 7 32bit, anyway I couldn't install the Designer 10gR2. While I was browsing the start menu, I found there is a Oracle Designer already installed when I installed developer suite. I tried to start that, then it gave me a connect screen, asking for the username, password and connect string. The version of the designer in the backgroued showed it was 10g. I cannot access designer without passing through this screen. Figured out I need a database, so I installed Oracle Ex to the same computer. But still I don't know what my connect string should be. The documentry says the username should be SYSTEM and the password is what I entered during installation, I know those two; what I don't know is the connect string.

Is there anyway that I can open the designer otherthan the steps I followed? If not, How can I find this Connect String? Please help me, I have no idea.

Thank you very much.

Comments

390020
Works ok in my environment (note I'm using python 2.5).

-----
$ ipython
Python 2.5.2 (r252:60911, Jul 31 2008, 17:28:52)
Type "copyright", "credits" or "license" for more information.

In [1]: import cx_Oracle as ora

In [2]: con_str = "i/me@mine"

In [3]: con = ora.connect(con_str)

In [4]: type(con)
Out[4]: <type 'cx_Oracle.Connection'>

In [5]: con = ora.Connection(con_str)

In [6]: type(con)
Out[6]: <type 'cx_Oracle.Connection'>
-----
Q: what is the output if you do:

type(connection_string)


?

675949
type(connection)
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
NameError: name 'connection' is not defined
390020
I asked for connection_string, not connection. Also I'm assuming you're running it in the same python session you run the previous code you show us. Is that right?
675949
Here is the code.....

Python 2.6.1 (r261:67517, Dec 4 2008, 16:51:00) [MSC v.1500 32 bit (Intel)] on win32
Type "help", "copyright", "credits" or "license" for more information.
import cx_Oracle
connection_string = "system/mypass@GLOBAL"
connection = cx_Oracle.Connection(connection_string)
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
cx_Oracle.DatabaseError: ORA-24315: illegal attribute type
type(connection_string)
<type 'str'>
>>>




I am doing all this under the same python session.
390020
Since I was unable to find out what is happening, I forwarded your problem to the cx-oracle-users list. You can find an answer over there. Here's [the link|http://sourceforge.net/mailarchive/forum.php?forum_name=cx-oracle-users&max_rows=25&style=nested&viewmonth=200812&viewday=19].
730306
I encountered this problem today, and there was no answer on the web.
This is what I learned, although it is embarassing to admit. I had installed
the Ora11g version of cx_Oracle, but the database is Ora10g. I deleted
the Ora11g cx_Oracle files, installed the Ora10g version, and everything
worked.
&nbsp;&nbsp;&nbsp;&nbsp;--dang
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 13 2013
Added on Feb 13 2013
0 comments
447 views