OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » How to check the instance name

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to check the instance name [message #596421]

Mon, 23 September 2013 01:29

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?

Report message to a moderator

Re: How to check the instance name [message #596849 is a reply to message #596421]

Thu, 26 September 2013 13:23

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 01 06:40:03 CDT 2023