Re: custom glogin and RAC
- From: "Bradd Piontek" <piontekdd@xxxxxxxxx>
- To: oracledbaquestions@xxxxxxxxx
- Date: Wed, 30 Jul 2008 22:32:41 -0500
I've always used this, and it did work on RAC (10.2.0.3 - Linux), but didn't
work at our level of Grid Control (I believe there is now a patch for this,
but certain things done through grid control did not like non-standard SQL>
prompts and would bomb out)
----------------------
-- Set up SQL Prompt to show database name
set ARRAYSIZE 14
set termout off
define osid='NOLOG'
column sid new_value osid noprint
select lower(user) || '@' ||
case when instr(global_name,'.')>1
then lower(substr(global_name,1,instr(global_name,'.')-1))
else lower(global_name) end
sid from global_name;
set sqlprompt '&osid> '
column sid clear
------------------------
Bradd Piontek
Oracle Blog: http://piontekdd.blogspot.com
Linked In: http://www.linkedin.com/in/piontekdd
On Wed, Jul 30, 2008 at 8:20 PM, Dba DBA <oracledbaquestions@xxxxxxxxx>wrote:
> I have used a glogin like the following for years. When I try to start
> svrctl with this, it looks for db name and username parameters and it fails
> to start. anyone know how to change this so I can make it work with RAC ?
>
> undefine usr db
> col usr new_value usr
> col db new_value db
>
> set termout off
> select lower(user) usr,
> substr(global_name, 1, instr(global_name, '.')-1) db
> from global_name
> /
> set termout on
>
> set sqlprompt '&&usr.@&&db.> '
>
>
Other related posts:
