By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,314 Members | 1,758 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,314 IT Pros & Developers. It's quick & easy.

SQL Server to Oracle

P: n/a
Hello,

Well unfortunately, I have to get an Oracle back end working with my
product and am having a hard time doing it. I was wondering if anyone
has had the same experience and could give me a little insight into
what I am doing wrong (if anything). I installed Oracle 10g on a
machine which ended up not being able to run it fast enough, though I
did manage to import the database that I wanted to use. After failing
at some syntax problems, I was finally able to return records, but it
was so slow, that we decided to install Oracle on a faster machine.
After that was done, I thought I was connecting to the newer machine,
but alas, I was actually connecting to the old machine when I found
that some structure changes were not being recognized. I shut off the
old machine, and now the name I was using to connect to it "ORCL",
could not be recognized. I uninstalled and reinstalled it to a new
name "GE", but it still doesn't recognize the name. Just wondering if
without trying to get into an Oracle/SQL Server contest, if there is a
simple stupid thing that I am missing. I don't want to learn Oracle,
I just want the thing running as a back end to do some simple SQL
stuff. I almost had this working, it is just the naming issue. Any
help would be great.

Thanks

-Jevon Thurlow
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi

You may want to either go through the SQLNet configuration wizard or look at
TNSNAMES adn SQLNET.ora files on the client to make sure they point to the
correct server.

John

"JThurlow" <jt******@lablite.com> wrote in message
news:5c**************************@posting.google.c om...
Hello,

Well unfortunately, I have to get an Oracle back end working with my
product and am having a hard time doing it. I was wondering if anyone
has had the same experience and could give me a little insight into
what I am doing wrong (if anything). I installed Oracle 10g on a
machine which ended up not being able to run it fast enough, though I
did manage to import the database that I wanted to use. After failing
at some syntax problems, I was finally able to return records, but it
was so slow, that we decided to install Oracle on a faster machine.
After that was done, I thought I was connecting to the newer machine,
but alas, I was actually connecting to the old machine when I found
that some structure changes were not being recognized. I shut off the
old machine, and now the name I was using to connect to it "ORCL",
could not be recognized. I uninstalled and reinstalled it to a new
name "GE", but it still doesn't recognize the name. Just wondering if
without trying to get into an Oracle/SQL Server contest, if there is a
simple stupid thing that I am missing. I don't want to learn Oracle,
I just want the thing running as a back end to do some simple SQL
stuff. I almost had this working, it is just the naming issue. Any
help would be great.

Thanks

-Jevon Thurlow

Jul 20 '05 #2

P: n/a
JThurlow wrote:
Hello,

Well unfortunately, I have to get an Oracle back end working with my
product and am having a hard time doing it. I was wondering if anyone
has had the same experience and could give me a little insight into
what I am doing wrong (if anything). I installed Oracle 10g on a
machine which ended up not being able to run it fast enough, though I
did manage to import the database that I wanted to use. After failing
at some syntax problems, I was finally able to return records, but it
was so slow, that we decided to install Oracle on a faster machine.
After that was done, I thought I was connecting to the newer machine,
but alas, I was actually connecting to the old machine when I found
that some structure changes were not being recognized. I shut off the
old machine, and now the name I was using to connect to it "ORCL",
could not be recognized. I uninstalled and reinstalled it to a new
name "GE", but it still doesn't recognize the name. Just wondering if
without trying to get into an Oracle/SQL Server contest, if there is a
simple stupid thing that I am missing. I don't want to learn Oracle,
I just want the thing running as a back end to do some simple SQL
stuff. I almost had this working, it is just the naming issue. Any
help would be great.

Thanks

-Jevon Thurlow


As someone that has performed many SQL Server to Oracle migrations:
Usually for products that needt to be platofrm neutral ... you are,
in my opinion, absolutely doomed to failure. You have broken the
cardinal rule of doing this which is to learn the product which
requires reading documentation and books.

If you don't know what multiversion read consistency is then get a
copy of Tom Kyte's book "Expert one-on-one Oracle" and read it ...
read the first three chapters until you get it.

Are you used to working with temp tables? In Oracle ... never.
Are you used to working with limited record locking? In Oracle ... never.
Are you used to working with autonumber? In Oracle ... never.
Are you used to working with only AFTER triggers?
Are you used to lock escalation?
And much much more!
--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace 'x' with 'u' to respond)
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.