Re: How to create a service name for the Oracle instance

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

Thanks.
Raj Received on Wed Aug 29 2007 - 02:15:22 CDT