Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Index > ORACLE Server Parameters > service_names

service_names

Oracle 11.1.0:

Parameter Name:service_names
Description:service names supported by the instance
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.2.0:

Parameter Name:service_names
Description:service names supported by the instance
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.1.0:

Parameter Name:service_names
Description:service names supported by the instance
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 9.2.0:

Parameter Name:service_names
Description:service names supported by the instance
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 8.1.7:

Parameter Name:service_names
Description:service names supported by the instance
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 8.0.6:

No such parmeter in Oracle 8.0.6.

Oracle 7.3.4:

No such parmeter in Oracle 7.3.4.

Related Error Messages:

ORA-00114: missing value for system parameter SERVICE_NAMES
    Cause: No value was specified for the SERVICE_NAMES system parameter, nor for the DB_NAME parameter.

    Action: Add an SERVICE_NAMES or DB_NAME definition to the INIT.ORA file. By default, SERVICE_NAMES is the value of DB_NAME unless SERVICE_NAMES is explicitly specified.

ORA-00116: SERVICE_NAMES name is too long

    Cause: A service name specified in the SERVICE_NAMES system parameter is too long.

    Action: Use a shorter name in the SERVICE_NAMES value (<= 255 chars).

This parameter is documented in the Oracle Server Reference Guide. Search for more info about [ service_names ] on the Oracle FAQ.

HOME | ASK QUESTION | ADD FAQ | SEARCH | E-MAIL US