Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: moving a database from 8.0.5 to 8.1.7
Howard J. Rogers <howardjr_at_www.com> wrote:
: "Christoph Kukulies" <kuku_at_gil.physik.rwth-aachen.de> wrote in message : news:9n04kl$5qs$1_at_nets3.rz.RWTH-Aachen.DE...
: The same thing that gets 'taken' every time you do a 'connect : system/manager' in SQL Plus without the tns alias (which is what the : '@database' bit is known as)... whatever the ORACLE_SID environment variable : is set to (assuming that the tnsnames.ora file correctly identifies such a : database, and correctly explains how the hell to connect to it).
Thanks to all who helped so great.
While being at this 'tns alias': How would the syntax be when there is no alias defined? E.g. I know the host and the ORACLE_SID the database is running on. Often there is not yet an entry in tnsnames.ora or the file was edited by hand and there is an error in tnsnames.ora.
Then it could be useful to know how to get to the database without all the Oracle naming and aliasing stuff inbetween.
something like user/password_at_TNS:<someting> I seem to recall.
: Regards
: HJR
-- Chris Christoph P. U. Kukulies kuku_at_gil.physik.rwth-aachen.deReceived on Tue Sep 11 2001 - 04:30:03 CDT