Store and Oracle
Locked
 
|
Hello all.
I've installed Oracle Express 10.2.0.1.0 and Visual Works Non-Commercial 7.7.1. I'd like to use the Store facility keep track of my software versions.
But when I try to create the appropriate tables in Oracle by doing Store.DbRegistry installDatabaseTables, I can't satisfy the dialog that pops up.
I've tried a variety of permutations. This almost works:
Connection Profile: Visual Works Store Local Repository
Interface: OracleConnection
Environment: RicksLaptop:1521
User Name: BERN
Password: ******
Table Owner: BERN
The password is correct. I am able to log into Oracle using it. I believe the key is the Environment string. RicksLaptop:1521 gets further than anything else I have tried. I found the port number in Oracle's tnsnames.ora file.
Surely, someone else has gotten past this point, and knows the magic incantation if one has just installed the software, and so far has changed nothing.
I appreciate any help.
Regards,
Rick
_______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
|
|
Hi Rick!
On 19.10.2010 07:15, Rick Hedin wrote: > But when I try to create the appropriate tables in Oracle by doing > Store.DbRegistry installDatabaseTables, I can't satisfy the dialog that pops > up. > > I've tried a variety of permutations. This almost works: > > Connection Profile: Visual Works Store Local Repository > Interface: OracleConnection > Environment: RicksLaptop:1521 > User Name: BERN > Password: ****** > Table Owner: BERN I had a similar experience, when confronted with databases and their "environments". Your environment setting misses the database name to connect to, since environment hast the format SERVER:PORT_DATABASE, where :PORT is optional, if you (as you do) use the standard port. Whoever invented this convoluted concept of specifying 3 values in a single string, should be punished to write a .doc parser without any documentation. Regards Jan _______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
|
|
haven't used Oracle for a while, but AFAIK you either have to use a SID
or //host[:port][/database] as environment string,e.g. //RicksLaptop/storedb The latter only works with Oracle >= 10g. > Hi Rick! > > On 19.10.2010 07:15, Rick Hedin wrote: >> But when I try to create the appropriate tables in Oracle by doing >> Store.DbRegistry installDatabaseTables, I can't satisfy the dialog that pops >> up. >> >> I've tried a variety of permutations. This almost works: >> >> Connection Profile: Visual Works Store Local Repository >> Interface: OracleConnection >> Environment: RicksLaptop:1521 >> User Name: BERN >> Password: ****** >> Table Owner: BERN > > I had a similar experience, when confronted with databases and their > "environments". Your environment setting misses the database name to > connect to, since environment hast the format SERVER:PORT_DATABASE, > where :PORT is optional, if you (as you do) use the standard port. vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
|
|
In reply to this post by Jan Weerts
Thanks for the information, Jan and Holger!
I think I'm almost there. I suspect I do not know the correct name of my database. Does someone know what it would be after a fresh install of Oracle Express 10.2?
This environment string: RicksLaptop:1521
And this environment string: RicksLaptop:1521_XE
Result in the message: ORA-06413: Connection not open.
Whereas this environment string: //RicksLaptop/XE
Results in the message: ORA-12154: TNS:could not resolve the connect identifier specified
Is this enough information for someone to solve the puzzle?
Regards,
Rick
On Tue, Oct 19, 2010 at 1:15 AM, Jan Weerts <[hidden email]> wrote:
Hi Rick! Holger Kleinsorgen to vwnc haven't used Oracle for a while, but AFAIK you either have to use a SID
or //host[:port][/database] as environment string,e.g. //RicksLaptop/storedb The latter only works with Oracle >= 10g.
_______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
|
|
The SID of Oracle Express is probably "XE", so that should work as
environment string. Am 19.10.2010 13:01, schrieb Rick Hedin: > Thanks for the information, Jan and Holger! > > I think I'm almost there. I suspect I do not know the correct name of my > database. Does someone know what it would be after a fresh install of > Oracle Express 10.2? _______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
|
|
In reply to this post by Rick Hedin
Did you have a look at:
http://ora-12154.ora-code.com/ -- Claus Kick "Wenn Sie mich suchen: Ich halte mich in der Nähe des Wahnsinns auf. Genauer gesagt auf der schmalen Linie zwischen Wahnsinn und Panik. Gleich um die Ecke von Todesangst, nicht weit weg von Irrwitz und Idiotie." "If you are looking for me: I am somewhere near to lunacy. More clearly, on the narrow path between lunacy and panic. Right around the corner of fear of death, not far away from idiocy and insanity." --------------------- Von: "Rick Hedin" <[hidden email]> Gesendet: 19.10.2010 13:01:05 An: [hidden email] Betreff: Re: [vwnc] Store and Oracle Thanks for the information, Jan and Holger! I think I'm almost there. I suspect I do not know the correct name of my database. Does someone know what it would be after a fresh install of Oracle Express 10.2? This environment string: RicksLaptop:1521 And this environment string: RicksLaptop:1521_XE Result in the message: ORA-06413: Connection not open. Whereas this environment string: //RicksLaptop/XE Results in the message: ORA-12154: TNS:could not resolve the connect identifier specified Is this enough information for someone to solve the puzzle? Regards, Rick On Tue, Oct 19, 2010 at 1:15 AM, Jan Weerts <[[hidden email]]> wrote: Hi Rick! On 19.10.2010 07:15, Rick Hedin wrote: But when I try to create the appropriate tables in Oracle by doing Store.DbRegistry installDatabaseTables, I can't satisfy the dialog that pops up. I've tried a variety of permutations. This almost works: Connection Profile: Visual Works Store Local Repository Interface: OracleConnection Environment: RicksLaptop:1521 User Name: BERN Password: ****** Table Owner: BERN I had a similar experience, when confronted with databases and their "environments". Your environment setting misses the database name to connect to, since environment hast the format SERVER:PORT_DATABASE, where :PORT is optional, if you (as you do) use the standard port. Whoever invented this convoluted concept of specifying 3 values in a single string, should be punished to write a .doc parser without any documentation. Regards Jan Holger Kleinsorgen to vwnc haven't used Oracle for a while, but AFAIK you either have to use a SID or //host[:port][/database] as environment string,e.g. //RicksLaptop/storedb The latter only works with Oracle >= 10g. _______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
|
|
In reply to this post by Rick Hedin
I think with a simple local database you also have the
option of just leaving it blank. Except that 7.7.1 tries to be too
helpful and disallow that. So if you go to the method
ConnectionProfile>>isValid and remove the last clause (the
"self isSpecified: environment") and then leave the environment
string blank, that may work.
At 07:01 AM 2010-10-19, Rick Hedin wrote: Thanks for the information, Jan and Holger!
Holger Kleinsorgen to vwnc haven't used Oracle for a while, but AFAIK you either have to use a SID or //host[:port][/database] as environment string,e.g. //RicksLaptop/storedb The latter only works with Oracle >= 10g. _______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc --
Alan Knight [|], Engineering Manager, Cincom Smalltalk
_______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
|
|
In reply to this post by Rick Hedin
Hi Rick,
If your tnsnames.ora file was generated by the Oracle install, can't you find the SID in that file? I've been configuring Oracle lately on both Windows and MacOSX, and my tnsnames.ora file contains something like this: LOGICAL_NAME = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = LOCALHOST)(PORT = 1521)) ) (CONNECT_DATA = (SID = DB_SID) (SERVER = DEDICATED) ) ) With the environment variable TNS_ADMIN referencing the directory that contains my tnsnames.ora file, I am able to use either "localhost/db_sid" or "logical_name" (in our installation at least, case is not important) in the Environment string for Store. - Sherry On 10/19/10 7:01 AM, Rick Hedin wrote: > Thanks for the information, Jan and Holger! > I think I'm almost there. I suspect I do not know the correct name of my database. Does someone > know what it would be after a fresh install of Oracle Express 10.2? > This environment string: RicksLaptop:1521 > And this environment string: RicksLaptop:1521_XE > Result in the message: ORA-06413: Connection not open. > Whereas this environment string: //RicksLaptop/XE > Results in the message: ORA-12154: TNS:could not resolve the connect identifier specified > Is this enough information for someone to solve the puzzle? > Regards, > Rick > > > On Tue, Oct 19, 2010 at 1:15 AM, Jan Weerts <[hidden email] <mailto:[hidden email]>> wrote: > > Hi Rick! > > > On 19.10.2010 07:15, Rick Hedin wrote: > > But when I try to create the appropriate tables in Oracle by doing > Store.DbRegistry installDatabaseTables, I can't satisfy the dialog that pops > up. > > I've tried a variety of permutations. This almost works: > > Connection Profile: Visual Works Store Local Repository > Interface: OracleConnection > Environment: RicksLaptop:1521 > User Name: BERN > Password: ****** > Table Owner: BERN > > > I had a similar experience, when confronted with databases and their "environments". Your > environment setting misses the database name to connect to, since environment hast the format > SERVER:PORT_DATABASE, where :PORT is optional, if you (as you do) use the standard port. > > Whoever invented this convoluted concept of specifying 3 values in a single string, should be > punished to write a .doc parser without any documentation. > > Regards > Jan > > > > Holger Kleinsorgen to vwnc > haven't used Oracle for a while, but AFAIK you either have to use a SID > or //host[:port][/database] as environment string,e.g. > > //RicksLaptop/storedb > > The latter only works with Oracle >= 10g. > > > > _______________________________________________ > vwnc mailing list > [hidden email] > http://lists.cs.uiuc.edu/mailman/listinfo/vwnc vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
|
|
In reply to this post by Rick Hedin
Dear Rick,
does just the environment string XE itself resolve correctly when you are running an image on the same machine, not over a network? Yours faithfully Niall Ross >Thanks for the information, Jan and Holger! > >I think I'm almost there. I suspect I do not know the correct name of my >database. Does someone know what it would be after a fresh install of >Oracle Express 10.2? > >This environment string: RicksLaptop:1521 > >And this environment string: RicksLaptop:1521_XE > >Result in the message: ORA-06413: Connection not open. > >Whereas this environment string: //RicksLaptop/XE > >Results in the message: ORA-12154: TNS:could not resolve the connect >identifier specified > >Is this enough information for someone to solve the puzzle? > > > Regards, > > Rick > > > >On Tue, Oct 19, 2010 at 1:15 AM, Jan Weerts <[hidden email]> wrote: > > > >>Hi Rick! >> >> >>On 19.10.2010 07:15, Rick Hedin wrote: >> >> >> >>>But when I try to create the appropriate tables in Oracle by doing >>>Store.DbRegistry installDatabaseTables, I can't satisfy the dialog that >>>pops >>>up. >>> >>>I've tried a variety of permutations. This almost works: >>> >>>Connection Profile: Visual Works Store Local Repository >>>Interface: OracleConnection >>>Environment: RicksLaptop:1521 >>>User Name: BERN >>>Password: ****** >>>Table Owner: BERN >>> >>> >>> >>I had a similar experience, when confronted with databases and their >>"environments". Your environment setting misses the database name to connect >>to, since environment hast the format SERVER:PORT_DATABASE, where :PORT is >>optional, if you (as you do) use the standard port. >> >>Whoever invented this convoluted concept of specifying 3 values in a single >>string, should be punished to write a .doc parser without any documentation. >> >>Regards >> Jan >> >> >> > > >Holger Kleinsorgen to vwnc >haven't used Oracle for a while, but AFAIK you either have to use a SID >or //host[:port][/database] as environment string,e.g. > > //RicksLaptop/storedb >The latter only works with Oracle >= 10g. > > > >------------------------------------------------------------------------ > >_______________________________________________ >vwnc mailing list >[hidden email] >http://lists.cs.uiuc.edu/mailman/listinfo/vwnc > > _______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
|
|
Bless you all for your graciousness. I feel like I'm back in the early days of Unix newsgroups, when everybody helped, and nobody flamed.
I've had illness and other projects, but I've solved the problem. I did remove the check that the connection string was present, as Alan K. suggested. That didn't work. I buttonholed a couple of DBAs with rusty Oracle experience and presented the problem to them. That didn't work.
My solution to the problem might be regarded as "cheating" but Store is connected, and I'm happy. I moved to postgreSQL.
<rant>Putting the levers and gears behind GUIs, and making the documentation very terse in order to make it "simpler," doesn't interact well with my approach to computer science.</rant>
With postgres, the entries that work are
Interface: PostgreSQLEXDIConnection
Environment: ricksdb
User Name: BERN
Password: ******
Table Owner: BERN
I can connect and disconnect to my heart's content, using the Store menu's Connect to Repository and Disconnect from Repository. Regards,
Rick
On Wed, Oct 20, 2010 at 7:28 AM, Niall Ross <[hidden email]> wrote: Dear Rick, -- I insist on rapport! _______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
|
|
Rick From the Store perspective, you have to put the DB name
in the environment string.
Nothing tricky here. From the Oracle
perspective you have to set up the DB name and listener. I use the
Oracle Net Manager tool to do this. Terry From: [hidden email] [mailto:[hidden email]] On
Behalf Of Rick Hedin Bless you all for your graciousness. I feel like I'm
back in the early days of Unix newsgroups, when everybody helped, and nobody
flamed. I've had illness and other projects, but I've solved the
problem. I did remove the check that the connection string was present,
as Alan K. suggested. That didn't work. I buttonholed a couple
of DBAs with rusty Oracle experience and presented the problem to
them. That didn't work. My solution to the problem might be regarded as
"cheating" but Store is connected, and I'm happy. I moved to
postgreSQL. <rant>Putting the levers and gears behind GUIs, and
making the documentation very terse in order to make it "simpler,"
doesn't interact well with my approach to computer science.</rant> With postgres, the entries that work are
Interface: PostgreSQLEXDIConnection Environment: ricksdb User Name:
BERN
Password: ****** Table Owner: BERN
Regards, Rick On Wed, Oct 20, 2010 at 7:28 AM, Niall Ross <[hidden email]> wrote: Dear Rick,
_______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
«
Return to VisualWorks
|
1 view|%1 views
| Free forum by Nabble | Edit this page |