Re: Oracle 10g and dbca

fmjohnson_at_gmail.com wrote:

>>>>
>>>> Can you use TNSPING successfully?
>>>>
>>>> Post your listener.ora, sqlnet.ora, tnsnames.ora
>>>> --
>>>> Daniel A. Morgan
>>>> University of Washington
>>>> damorgan_at_x.washington.edu
>>>> (replace x with u to respond)
>>>> Puget Sound Oracle Users Group
>>>> www.psoug.org

> Results of tnsping. I have not configured the listener or naming
> convention.
>
> [oracle_at_martin: ~> tnsping myhome
>
> TNS Ping Utility for Linux: Version 10.1.0.3.0 - Production on
> 21-AUG-2006 19:54:32
>
> Copyright (c) 1997, 2003, Oracle. All rights reserved.
>
> Used parameter files:
>
> TNS-03505: Failed to resolve name

TNSPING will fail if it is not configured. Use NETCA to drop everything and exit. Then use NETCA to recreate everything.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org