Home » Applications » Oracle Fusion Apps & E-Business Suite » How to check the instance name
How to check the instance name [message #596421] Mon, 23 September 2013 01:29 Go to next message
newbieinapps
Messages: 13
Registered: August 2013
Junior Member
Hi Guys,
I am running a Oracle concurrent program with executable method as PROG. A shellscript file.
In the output log file I need to display the instance name only.
Like $1,$2,$3,$4 is there any standard default parameter to display?
Re: How to check the instance name [message #596849 is a reply to message #596421] Thu, 26 September 2013 13:23 Go to previous message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
I hope you can definitely execute the SQL*Plus script as an executable file i.e. SQL*Plus script through the Concurrent Program Executable Window. In the script code the following(DEPENDING ON THE PRIVILEGES THAT ARE GRANTED TO YOU):-

select sys_context('USERENV','INSTANCE_NAME') from dual;


or,
select * from global_name;


or,
select instance_name from v$instance;


Log this as an output from the shell script.

Regards,
Lalit
Previous Topic: PO status is Incomplete
Next Topic: Forward Po Notificaton
Goto Forum:
  


Current Time: Thu Mar 28 15:34:27 CDT 2024