How to know the service name of oracle server

10-11  Source: Network gathering  Views:0 

Advertisement
write a query to get the servcie name of oracle from oracle tables
Not really! That's the instance name and not the service name!
This version is correct:
select name, value from v$parameter where name = 'service_names';
NAME                                                             VALUE         
service_names                                                    ACPT.WORLD
1 row selectedBye, Aron
Related articles
  • How to know the service name of oracle server 10-11

    write a query to get the servcie name of oracle from oracle tablesNot really! That's the instance name and not the service name! This version is correct: select name, value from v$parameter where name = 'service_names'; NAME                          

  • How to rename the column name in oracle 8i? 10-11

    hi, Does anyone know how to rename the column name in oracle 8i?My method was drop the relationship key first then delete the old column,finally add the new column. Thanks for your replay. jingThere is no facilty to rename a column name in Oracle 8i.

  • How to know the database name? 10-11

    I have installed oracle 10g and developer suite.. I am trying to create forms now. But its error out: TNS: could not resolve the connect identifier specified!!! I forgot the Data base name.. How can I know the database name?? Thanks in Advance!!!!!!!

  • How to get the service name of a webservice using UDDI API 10-11

    Hi, Iam working on setting up a dynamic partner link in a BPEL, by passing the endpoint of a web service queried from the UDDI (Oracle Service Registry 10.3 ) using the API. Iam able to do it successfully. Now, for example I have two operations in my

  • How to know the column name using the index name for a particular table 10-11

    Hi All, I have small query regarding, I have index name and table name so by using this how can I know the column name associated with that index of that particular table specific to Oracle9i. Thanks Sudheerselect * from user_ind_columns -- or all_in

  • How to get the file name from Oracle B2B 10g 10-11

    Hi My requirement is I am getting a CSV file from Trading partner, I am using oracle 10g b2b to translate the data. In my BPEL 10g I am using AQ adapter to get the message from IP_IN_QUEUE. Now I want to get the file name Eg: SampleFile.dat of the CS

  • How to know the Column name which contains some value? 10-11

    Suppose if a table contains 30 columns, and I want to know the name of the Column that contains my search text(Value). For Eg. I have a Table named Allowances contains 20 columns for referencing 20 types of allowances. The columns are named like Allw

  • How To Know The Column Name Of The Internal Table 10-11

    HI ,         i have an internal table . f1          f2           f 3         f4            f5   matnr   mbrsh    mtart     meins       minbe i want to know the column name which depending on the value i.e . if it is matnr then f1 , if mbrsh it is f2

  • How to know the User name and date, who executed the report last time. 11-30

    Hi All, We are collecting a list of reports which are not executed for past 3 months. Can anybody tell me how to know the username and date they executed the report last time. Is there any table to look ? or is there any process ? Thanks, Ravi.Ravi,

  • How to get the Host name of Unix server 10-11

    Hi all, I am need to use the Host name of application server for some purpose. where can i see the host name of the unix server ?SYST-HOST or SY-HOST contain the name of the application server. You may also use the following internal call to get the

  • How to create custom service name in oracle 10g 11-30

    Hi, I have installed oracle 10g, it has created default servicename as XE which is having only 4GB memory size. It is not sufficient to import my dmp file. I would like to created my own service name, How can I do it. Advice thanks for your instructi

  • How to know the enhancement name by the exit funciton 10-11

    helleo     i have a question about enhancement. if i know the exit function name how can i get the enhancement name in SMOD.     thank u!!!!go to smod press F4 in enhancement. press information system in pop up. after that another popup will come giv

  • How to know the table names n field names 2 11-30

    hi, with the use of the below fileds Vendor number, material number, PO number, Purchasing group/Buyer, PO creation date, PO delivery date, PO created by I should get the out put with the fields.... PO, PO date, PO group/buyer, purchasing org, vendor

  • How to know the class name in .ser file? 10-11

    Hi, I have a .ser file, could any expert help me to find out all the classes in the .ser file? Thanks!If you have written them as Object, then you can just read them one by one with an ObjectInputStream and when you have the object, you can print out

  • How to set the snc name to abap server with IDM? 11-30

    HI all:      I want to set the snc name from IDM , but I didn't konw  which attribute that I would be set. I there anyone konw this? thanks!Hi Shi, I'm guessing you don't know which attribute in the MX_PERSON class contains it? If this is what you me

  • How to know current form name in oracle applications 11i. 11-30

    Hi all, By clicking on Help menu-> About Oracle Applications, it will display environment variables info, and current form info, on which we r working. I want to know from where this information is coming, Where oracle applicaitons will store this in

  • How to know the amount of RAM Oracle is recognizing on the Server...? 10-11

    I have 10g Rel 2 running on 4 CPU Win2003 Adv Server, which has 8 GB of RAM, but when I look at the Oracle Ent.Mgr. Host page under 'Configuration' it shows 'Memory Size' as 2048 MB, in fact it shows the correct CPU count and hard disk size. What can

  • [ASK] How to know the number of usage of each Atomic Service ?? 11-30

    I correct my question: *How to know the number of usage of each Atomic Service by the Domain & Enterprise Services?* I want to see the number of usage of each atomic service(AS) by other services (DS & ES) ex: es_A  ----->  ds_B   (1x)    -----

  • I want to know how to setup the logicaladdress (cluster+HA+oracle) 11-30

    I want to know how to setup the logicaladdress (cluster+HA+oracle)Please have a look at: http://docs.sun.com/app/docs/doc/819-0703/6n343k6g0?q=SUNW.LogicalHostname&a=view for how to add a Logical Hostname Resource to a Resource Group (in that case th

  • Hi All.. i want to use my iphone 4 to play poker on facebook with the zynga..  idont know the apps name,, thank's for ur help, and how to upgrade ios 4.3.3, now i'm still using ios 4.1.1, thank's 10-11

    hi All.. i want to use my iphone 4 to play poker on facebook with the zynga..  idont know the apps name,, thank's for ur help, and how to upgrade ios 4.3.3, now i'm still using ios 4.1.1, thank'swhen you connect your phone with your computer and use