Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to create a service name for the Oracle instance
On Aug 29, 9:15 am, Raj <jkama..._at_gmail.com> wrote:
> On Aug 28, 11:38 pm, vitalis..._at_gmail.com wrote:
>
> > On Aug 29, 5:39 am, EscVector <J..._at_webthere.com> wrote:
>
> > > Not sure what you are getting at, but it sounds like you should search
> > > on Remote Listener, or if you only need to add a service name simply
> > > alter service set service_name='supora.domain';
>
> > That should read:
> > alter SYSTEM set service_nameS='supora.domain';
>
> Thank you for the answer. I will elaborate the steps here. Can you
> please check and confim
>
> 1. Create a Net service name from my local machine for the Ora9i
> instance running on support-db2
> 2. Login to Ora92 with System account in PL-SQL from my local
> machine using the Net service name created in step #1
> 3. Run the following statement in PLSQL
>
> alter SYSTEM set service_nameS='suporasntest.domain';
>
> 4. Logout of PL-SQL
> 5. Create a new Net service from my local machine for the Ora9i
> instance but this time using the service name created in step 3. That
> is using suporasntest.domain
> 6. Try to login to PL-SQL with Net service name created in setp #5 to
> verify the service_name created in #3 works correctly
That looks good provided you replace "PL-SQL" with sqlplus. ;-)
You might want to set suporasntest.domain *and* supora.domain in service_names to still be able to connect with the old service name as well. Received on Wed Aug 29 2007 - 03:40:57 CDT