[ACCEPTED]-Where to get Oracle SERVICE_NAME?-oracle10g

Accepted answer

Score: 13

It is normally XE for the free version. ORCL 6 is another typical value.

Once logged in, it 5 can be determined from

select sys_context('USERENV','SERVICE_NAME') from dual

If you need to know 4 it so that you can log in, look for a file 3 called TNSNAMES.ORA in $ORACLE_HOME/rdbms/network/admin 2 and the service name will probably be in 1 the connection string.

Score: 4

Since its windows, you can go to control 5 panel - administrative tools - services 4 : (switch to classic mode in control panel 3 if you do not see admin tools). Once there 2 you will have a service by the name "Oracle 1 service_". The is your service name.

Source: stackoverflow.com

How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?

Difference Between Timestamps in Milliseconds in Oracle

Unable to create table using pl/sql

JDBC Batch insert exception handling

Dynamically call PL/SQL procedure with output variables

MINUS Operator in oracle

Getting index of element in PL/SQL collection

How to see refcursor result/output in Oracle SQL Developer?

Insert multiple rows from select into another table

Relation between Oracle session and connection pool

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.