Re: 10G tns questions

On 3 apr, 21:00, GS <G..._at_GS.com> wrote:
> Frank van Bortel wrote:
> > GS schreef:
>
> >>frank.van.bor..._at_gmail.com wrote:
>
> >>>On 3 apr, 15:49, GS <G..._at_GS.com> wrote:
>
> >>>>I checked the sqlnet, I am not using NTS and it is set at NONE. I am a
> >>>>little confused on why Oracle has set up with 2 homes and am wondering
> >>>>it there is a conflict with the path somewhere. When I type in lsnrctl
>
> >>>You're on Windows... Windows cannot switch profilesa s *ixes can.
> >>>But you can (permanently, or temporarely) change your path - just
> >>>make sure your 10G direcotries are named before the 9i.
>
> >>>>from a prompt I get an early version for some reason, 9.0.1.4.1, and it
> >>>>won't start, just returns TNS-12538,12560 and 00508, if I go the the bin
> >>>>directory of the newest home for the database I just installed I get
> >>>>version 10.2.0.3.0 and it wont start from the prompt (times out), but it
> >>>>will start from windows services tab but now is not showing any
> >>>>services. Some kind of weirdness happened with one of the installs I
> >>>>think. Was thinking this would be a quick find & fix but it looks like I
> >>>>may have to open a SR..
>
> >>>Your listener version should be the one with the server; if you have
> >>>two
> >>>or more instances, use the highest avaibale version of the listener.
>
> >>>Isn't a firewall causing trouble? You're on windows...
>
> >>Not the firewall, and local connections thru the listener are failing or
> >>working the same as remote connections and 9i isn't installed on this
> >>machine. The Oracle home first in the path is the 10.1.0/em_1 home, and
> >>it's version of listener is 9.xx it seems. I can connect to the emrep db
> >>fine thru the listener, and it is set up identical to the new install.
> >>I've tried using service name, SID, and all the usual variations to no
> >>avail. I did check the service name db parameter and notices that it did
> >>not have the domain attached to it, so I changed the service name in
> >>tnsnames to match, still nothing, then did an alter system set
> >>service_name=dbname.my.net and made sure it matched the tnsnames - still
> >>nothing, in any event I've always been able to use SID in tnsnames but
> >>not this time.
>
> > Hold it - service_name is not something you invent; it's the SID
> > of the instance, with it's db_domain attached to it.
> > You can query these - or take a look in your pfile
> > (create pfile='...' from spfile;)
>
> >>When I shut down the listener and try to start the (10.2.0.3)one in the
> >>10.2.0\bin directory it wont start, just gives a tns-12560 protocol
> >>adapter error. I've been googling this to death and going in circles, I
> >>hate these niggling little annoyances that consume so much time..
>
> >>I'm thinking now I should have patched before installing grid control or
> >>creating the repository db, but I should run the patch on the
> >>10.2.0/em_1 home in any case so I will see what happens then
>
> > I'm confused about your setup; can you post details about:
> > 1) Oracle product
> > 2) what version of 1)
> > 3) path to oracle home of every 1)
>
> Ok, this is what has transpired so far:
>
> Installed 10GR2 sans starter db on a workstation runnin XP pro as a test box
>
> Installed Grid control and let it create the emrep repository database
>
> IIRC this left me with two Oracle homes under the c:\oracle\product
> directory 10.1.0/em_1 and 10.2.0/db_1
>
> Installed latest patch to the db_1 home
>
> Created new database with DBCA, from scratch (custom), not using datafiles
>
> so now under my c:\oracle I have:
> \admin\emrep\bdump,cdump etc.
> \oradata\emrep\<datafiles>
> \10.1.0\em_1\bin,database,rdbms,network etc.
> \10.2.0\db_1\bin,database,rdbms,network etc.
> \oradata\<newdb>\<datafiles>
> \admin\newdb\bdump,cdump,etc.
>
> path to each oracle home is:
>
> c:\oracle\product\10.1.0\em_1
> c:\oracle\product\10.2.0\db_1
>
> I got the alter system set service_name=newdb.mydomain.net idea from a
> thread on one of the forums in OTN, but I've never used it (alter system
> set service_names=) before. As I said, the service name in the emrep
> database had the domain appended to it, the newdb did not for some
> reason, in any case I dont think this was/is the problem. When I look at
> the spfile with wordpad it says service_names=newdb.mydomain.net

Switch to a command line interface (CLI), and: c: <enter>
cd \oracle\product\10.2.0\db_1\bin
set ORACLE_SID=newdb
sqlplus system/manager (or whatever password you use)

Does that work without the tns-12xxx errrors? If so, please post the contents of:

c:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
c:\oracle\product\10.2.0\db_1\network\admin\listener.ora
c:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
c:\oracle\product\10.1.0\em_1\network\admin\tnsnames.ora