Re: where is this GLOBAL_NAME value coming from?

On Tue, 16 Mar 2004 13:32:11 -0500, "Bib Endum" <gd-newsgroups_at_spamex.com> wrote:

>
>"Ed Stevens" <nospam_at_noway.nohow> a écrit dans le message de
>news:a12e501dpkn4hpe47iilefmnvd9jr0sh2k_at_4ax.com...
>> Server Platform: Oracle EE 9.2 on Solaris 8
>> Client platform: Oracle 8.1.7 on Win2k
>>
>> On my desketop I have a login.sql file with the following:
>>
>> column global_name new_value gname
>> set termout off
>> select lower(user) || '@' ||
>> decode(global_name, 'ORACLE8.WORLD', '8.0',
>> 'ORA8I.WORLD', '8i',
>> global_name) global_name from global_name;
>> set sqlprompt '&gname> '
>> set termout on
>>
>>
>> This has worked quite nicely to set my sql prompt to keep me informed
>> of who and where I am. Until now.
>>
>> While I have been maintaining some Unix based databases that I
>> inherited, yesterday I did my first creation of a db on Unix. Used
>> dbca and netca and everything went swimmingly. But when I connect
>> from my desktop with SQLPlus and the above login.sql file, my prompt
>> looks like this:
>>
>
>Is there a TNS_ADMIN variable set somewhere on your UNIX Box ?
>
>echo $TNS_ADMIN from shell prompt
>
>If it existe, does it point to a legit directory ?
>
>Have you tried NOT setting the DB_DOMAIN in your INIT.ORA instead of setting
>it to blank ?
>
>
>

No TNS_ADMIN variable. Didn't believe there was, since I helped build this one, but I checked to confirm.

Commented out the DB_DOMAIN, bounced the db. No change. Received on Tue Mar 16 2004 - 13:27:21 CST