Home > Administration > Add service to single instance database

Add service to single instance database

February 15, 2011 Leave a comment Go to comments

1. Login database as sysdba

2.Add ha_gsqs database service name to service_names parameter

SQL> alter system set service_names=’gsqsqa,ha_gsqs’ scope=both;

3. Register the database service to listener

SQL> alter system register;

4. Testing the service name

$ sqlplus gsqs/gsqs@gsqsvmdb:1521/ha_gsqs

SQL*Plus: Release 11.1.0.7.0 – Production on Tue Feb 15 11:51:36 2011

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

 

Advertisements
Categories: Administration
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: