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

On Aug 30, 12:04 am, vitalis..._at_gmail.com wrote:
> On Aug 30, 4:34 am, Raj <jkama..._at_gmail.com> wrote:
>
>
>
>
>
> > On Aug 29, 1:40 am, vitalis..._at_gmail.com wrote:
>
> > > 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.- Hide quoted text -
>
> > > - Show quoted text -
>
> > Thanks. Yes it should be SQL-Plus. When I try to create a new net
> > service name from my local machine using the service name created from
> > "Alter" statement from Net configuration assitance, the test fails
> > with the following error:
>
> > Ora12514: TnsListener could not resolve SERVICE_NAME given in connect
> > descriptor.
>
> > What am I mssing.
>
> Try again, it might have happened because the instance was not
> registered in the listener with the new service name yet.
>
> If that still fails, post your instance and sqlnet configuration if
> you want some help from this group: tnsnames.ora (on your client),
> init.ora regarding sqlnet, listener.ora, output from "lsnrctl
> status" (on your server)...- Hide quoted text -
>
> - Show quoted text -

I got it working. I have to enter the "Alter SYSTEM" you have provided after login as sysdba using the following statement

connect sys/admin_at_ora9i.actuate.com as sysdba

Thank you for all the help.

Regards
Raj Received on Thu Aug 30 2007 - 09:37:12 CDT