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
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: 3123
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;

select * from global_name;

select instance_name from v$instance;

Log this as an output from the shell script.

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

Current Time: Tue May 23 03:54:42 CDT 2017

Total time taken to generate the page: 0.11250 seconds