Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Knowing service_name of my database; where to find parameter file.

454775Sep 25 2005 — edited Sep 25 2005

To All,

I have Oracle 9i. How can I find the service_name (inorder to specify it in the tnsnames.ora) of my database..?

Also Is it possible that the name of my parameter file in the location 'H:\orawin95\admin\thomas\pfile\' be init.ora ....? ie, without the instance name as a suffix to the filename after init. Or is the parameter file in some other location...?

my oracle_home is 'H:\orawin95'
db_name is : 'thomas'
instance name is : 'toms'

thanks in advance
thomaskprakash@rediffmail.com

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 23 2005

Added on Sep 25 2005

#general-database-discussions

3 comments

336 views