 | |
Oracle 8.0.5 error
comp.databases.oracle.server comp.databases.oracle.server
 |
| | Thread Tools | Display Modes |
#31
 
| |||
| |||
|
Re: Oracle 8.0.5 error -
06-24-2011
, 06:58 PM
|
David: # How would cloning that server help the issue? Hard to keep track exactly from all of Dan's postings but I think there is a database somewhere running on win 2000 on one of the several servers he has posted about. If all that he needs is one more database on a different server maybe he can get it that way. AKA ... John, regarding the OS, the other system that is working is at Win2000 SP4 also. *It has the same Ora-12203 error but somehow they were able to build databases - probably before this error started arising. |
disallowing those same things to function. I've administered
databases on Windows and had issues with 'connect / as sysdba'; one
day that works and the next day and ever after it doesn't. Windows is
neither the most reliable nor the most robust 'operating system' (a
term I use VERY loosely with Winders) and, as stated earlier, Oracle
tested 8.0.6 on Windows 2000 in 1999 just before it (Winders 2k) was
unleashed on an unsuspecting public and clearly declared it unsuitable
for use (again, see MOS Document 116208.1) as it proved itself
unstable.
The 'solution' may be as simple as installing a more 'historic'
release of Winders ('dig out those 3.5" floppies, Bob. we need to
install Windows NT 4.0 ...'), one that tends to play more nicely with
Oracle 8.0.5. I realize the application they are using isn't on
speaking terms with more recent releases of Oracle (which begs the
question why haven't they looked for a more modern replacement for
this beast, or written their own?) and Winders 2K is now suffering
indigestion from such an old release of the RDBMS. One suggestion yet
to be made is to utilize the wonderful Micro$oft crutch of
compatibility settings for executables; one possible avenue is to set
these executables to run in Windows NT 4.0 compatibility mode and see
if they actually work as expected (which may save the guardians of the
archives from dusting off the NT 4.0 floppies). It's a shot in the
dark but so is Windows, if you think about it.
David Fitzjarrell
#32
| |||
| |||
|
|
Dan schreef: David and Gerald, Thanks so much for taking the time to help me here, I appreciate it emmensely. I'll try to answer your questions: ... - Also, I'm totally local when doing this work, there is no remote database. What I'm doing is using remote desktop to get to this computer, but it's the database server. So when running svrmgr30, as long as the ORACLE_SID is set it shouldn't care about tns/sqlnet, etc. Correct? What's strange is that it only works when I do the @ sign in the connect internal command. I repeat: "How do you connect to the server? Sybrand Bakker (http://www.dbmonster.com/Uwe/Forum.a...n-oracle-8-0-5) says that Remote Desktop does not support Bequeath." ... Any other suggestions as to what I should do? I am completely stumped. Oh, and by the way, I'm building this database for the client because their old oracle server had the EXACT SAME connection problem via svrmgr30. I thought it was a bad install but maybe not. Could it be something with their network? Something with the compatibility of 8.0.5 and Win2000? Yes, they are in-compatible. Bequeath does not work, ergo, you will not be able to connect to a local database. Not that it matters much, since it can't be installed. |
#33
| |||
| |||
|
|
Yes, yes, I know this is a REALLY OLD version of Oracle. I'm doing some one-time work for a client that is stuck on old enterprise software that can only run on Oracle 8. Having said that here is the problem: a newly installed version of Oracle 8.0.5 resides on Windows 2000 SP4. After installation the svrmgr30.exe (server manager) program always gives me the error "ORA-12203: TNS:unable to connect to destination". This happens even before I try to type "connect internal". I get the error both when I manually try to create a database and when the installer tries to create the ORCL database for me. I purposely run the installer and take all the defaults, so it's not like I've not created the TNSNAMES or Listener correctly - the installer should be doing this. And on investigation, the listener is up and running, tnsnames looks good, etc. A similar configuration on another server gives the same exact error. Is it the network? Doubtful, I'm doing everything local. Is it the OS? Can 8.0.5 simply NOT RUN on Win2000? I've seen issues regarding this but nothing as dead-in-the-water as this. Any ideas? No dinosaur comments please  Dan |
the -new option), or not started
Remember? Windows needs services. 8.0 did not make them
auto-starting by default, you need to oradim -edit -sid orcl ...
for that.
--
Regards,
Frank van Bortel
One of the dinosaurs
#34
| |||
| |||
|
#35
| |||
| |||
|
|
Gerard H. Pille wrote: Dan schreef: David and Gerald, Thanks so much for taking the time to help me here, I appreciate it emmensely. I'll try to answer your questions: ... - Also, I'm totally local when doing this work, there is no remote database. What I'm doing is using remote desktop to get to this computer, but it's the database server. So when running svrmgr30, as long as the ORACLE_SID is set it shouldn't care about tns/sqlnet, etc. Correct? What's strange is that it only works when I do the @ sign in the connect internal command. I repeat: "How do you connect to the server? Sybrand Bakker (http://www.dbmonster.com/Uwe/Forum.a...6978/connect-w....) says that Remote Desktop does not support Bequeath." ... Any other suggestions as to what I should do? I am completely stumped. Oh, and by the way, I'm building this database for the client because their old oracle server had the EXACT SAME connection problem via svrmgr30. I thought it was a bad install but maybe not. Could it be something with their network? Something with the compatibility of 8.0.5 and Win2000? Yes, they are in-compatible. Bequeath does not work, ergo, you will notbe able to connect to a local database. Not that it matters much, since it can't be installed. Can anyone see my messages. or is mine a voice of one crying in the desert? |
to get through.
jg
--
@home.com is bogus.
http://forums.oracle.com/forums/mess...786199#1786199
#36
| |||
| |||
|
|
Gerald: # Can anyone see my messages. or is mine a voice of one crying in the desert? At least when using google groups interface since last weekend ( 25th? 26th ? ) things seem to be getting delayed "considerably" ... |
Probably the wonders of being able to allocate resources dynamically,
blown out by new social networking paradigm.
https://plus.google.com/up/start/?sw=1 "We've temporarily exceeded our
capacity. Please try again soon."
Maybe they need the people who implemented jive and MOS at Oracle...
</sarcasm>
jg
--
@home.com is bogus.
http://www.eweek.com/c/a/Data-Storag...127280/?kc=rss
#37
| |||
| |||
|
#38
| |||
| |||
|
|
Joel: # Maybe they need the people who implemented jive and MOS at Oracle... ... I guess we all saw the MOS rollout disaster not so long ago. *Seems to have stabilized for the most part although it still gets flaky every once in a while. Not sure what the jive reference means though |
OTN forums, the slightly more open alternative to the MOS forums. At
one point any word with a particular letter in it would be rejected by
the nannyware. They can't even figure out why smileys don't work.
Merging in Sun forums as well as upgrading the forum software were
unmitigated disasters. They still sometimes display real emails
instead of user id's. Check out http://forums.oracle.com/forums/forum.jspa?forumID=29
jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/2...-over-bridges/
http://www.signonsandiego.com/news/2...house-convert/
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.