Re: Oracle 8.0.5 error
From: ddf <oratune_at_msn.com>
Date: Tue, 21 Jun 2011 09:00:01 -0700 (PDT)
Message-ID: <4a959039-0d29-4e48-aac0-baf518026b4b_at_y30g2000yqb.googlegroups.com>
On Jun 21, 7:57 am, Dan <daniel.oster..._at_visaer.com> wrote:
> On Jun 21, 8:35 am, John Hurley <hurleyjo..._at_yahoo.com> wrote:
>
>
>
>
>
> > On Jun 20, 10:46 pm, Dan <daniel.oster..._at_visaer.com> wrote:
>
> > > On Jun 20, 7:55 pm, ddf <orat..._at_msn.com> wrote:
>
> > > > On Jun 20, 2:27 pm, Dan <daniel.oster..._at_visaer.com> wrote:
>
> > > > > Gerald,
>
> > > > > Good question. I don't know why either. I checked those
> > > > > environmental variables, neither are set. I found that I can connect
> > > > > this way in svrmgr30:
>
> > > > > connect internal/<PW>_at_<SID>
>
> > > > > This means it clearly uses tns, but why? Also I always get the
> > > > > ora-12203 error as soon as I get into svrmgr30, even before I do a
> > > > > connect internal. I've found some people who've gotten this error and
> > > > > suggestions are always tns/listener or sqlnet.ora. I even did some
> > > > > registry hacks in the HOME0 but no luck. I'm completely stumped. It's
> > > > > probably something simple, but no luck so far.
>
> > > > > Dan
>
> > > > > On Jun 19, 2:47 pm, "Gerard H. Pille" <g..._at_skynet.be> wrote:
>
> > > > > > Why would svrmgr try to connect to a database using TNS?
>
> > > > > > Why would it try to connect to a remote database?
>
> > > > > > Do you perhaps have LOCAL or TWO_TASK defined?
>
> > > > > > open a dos-box in your whinedoze environment, and try
>
> > > > > > echo %LOCAL%
> > > > > > echo %TWO_TASK%
>
> > > > > > or verify the output from "set"- Hide quoted text -
>
> > > > > - Show quoted text -
>
> > > > Can you successfully tnsping the service? What HOST is being used in
> > > > the listner.ora? Is a loopback adapter installed?
>
> > > > David Fitzjarrell- Hide quoted text -
>
> > > > - Show quoted text -
>
> > > David,
>
> > > Thanks for jumping in, appreciate the help.
>
> > > I can successfully tnsping my ORCL database. The host in the listener
> > > is the server that I reside on, which it should be. I've pasted the
> > > listener.ora below and changed the actual server name to MYSERVER.
> > > I've done nothing to the listener except manually add the PILT
> > > database to it. The ORCL database was added when I had the installer
> > > create ORCL.
>
> > > Regarding the loopback adapter, there is none shown in the Device
> > > Manager. Should there be one installed? I've never done much with
> > > them so I'm not much of an expert. SHould something be set up with
> > > this?
>
> > > Dan
>
> > > PASSWORDS_LISTENER= (oracle)
>
> > > LISTENER =
> > > (ADDRESS_LIST =
> > > (ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world))
> > > (ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
> > > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> > > (ADDRESS = (PROTOCOL = NMP)(SERVER = MYSERVER)(PIPE = ORAPIPE))
> > > (ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVER)(PORT = 1521))
> > > (ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVER)(PORT = 1526))
> > > (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
> > > )
>
> > > SID_LIST_LISTENER =
> > > (SID_LIST =
> > > (SID_DESC =
> > > (GLOBAL_DBNAME = MYSERVER)
> > > (SID_NAME = ORCL)
> > > )
> > > (SID_DESC =
> > > (GLOBAL_DBNAME = MYSERVER)
> > > (SID_NAME = PILT)
> > > )
> > > (SID_DESC =
> > > (SID_NAME = extproc)
> > > (PROGRAM = extproc)
> > > )
> > > )
>
> > Do you really have entries for both 1521 and 1526 on the same host?- Hide quoted text -
>
> > - Show quoted text -
>
> I did a netstat -a and there is a 1526 port that is listening. I've
> not configured anything on it though, the tnsnames entries point to
> 1521. I just commented out the 1526 line in listener.ora and bounced
> the listener but it didn't help the ora-12203 issue.
>
> Here are my tnsnames and sqlnet.ora files to look at also, maybe you
> can see something that I'm not seeing. Keep in mind this is the
> current iteration of these files, I've tried several changes/
> commenting out/additions. These were all generated by the default
> Oracle install. The database I'm working with is the default install
> db ORCL.
>
> tnsnames.ora:
> # C:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configuration File:C:\orant
> \net80\admin\tnsnames.ora
> # Generated by Oracle Net8 Assistant
>
> CMEXAMPLE.WORLD =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = CM_SERVER)(PORT = 1610))
> (ADDRESS = (PROTOCOL = TCP)(HOST = LSNR_SERVER)(PORT = 1521))
> )
> (CONNECT_DATA = (SID = ORCL))
> (SOURCE_ROUTE = YES)
> )
>
> TCPEXAMPLE.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = Production1)(PORT = 1521))
> (CONNECT_DATA = (SID = ORCL))
> )
>
> NMPEXAMPLE.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = NMP)(Server = FinanceServer1)(Pipe =
> ORAPIPE))
> (CONNECT_DATA = (SID = ORCL))
> )
>
> ORCL.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVER)(PORT = 1521))
> (CONNECT_DATA = (SID = ORCL))
> )
>
> EXTPROC_CONNECTION_DATA.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0))
> (CONNECT_DATA = (SID = extproc))
> )
>
> PILT.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVER)(PORT = 1521))
> (CONNECT_DATA = (SID = PILT))
> )
>
> BEQ-LOCAL.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle80)(ARGV0 =
> oracle80ORCL)(ARGS = '(DESCRIPTION=(LOCAL=YES)
> (ADDRESS=(PROTOCOL=BEQ)))'))
> (CONNECT_DATA = (SID = ORCL))
> )
>
> SPXEXAMPLE.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = SPX)(Service = Server_lsnr))
> (CONNECT_DATA = (SID = ORCL))
> )
>
> TCP-LOOPBACK.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
> (CONNECT_DATA = (SID = ORCL))
> )
>
> Sqlnet.ora
> # C:\ORANT\NET80\ADMIN\SQLNET.ORA Configuration File:C:\orant
> \net80\admin\sqlnet.ora
> # Generated by Oracle Net8 Assistant
>
> TRACE_DIRECTORY_CLIENT = C:\TEMP
>
> NAME.DEFAULT_ZONE = world
>
> NAMES.DEFAULT_DOMAIN = world
>
> SQLNET.AUTHENTICATION_SERVICES= (NONE)
>
> TRACE_FILE_CLIENT = client
>
> TRACE_LEVEL_CLIENT = SUPPORT
>
> SQLNET.EXPIRE_TIME = 0
>
> #NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)- Hide quoted text -
>
> - Show quoted text -
Date: Tue, 21 Jun 2011 09:00:01 -0700 (PDT)
Message-ID: <4a959039-0d29-4e48-aac0-baf518026b4b_at_y30g2000yqb.googlegroups.com>
On Jun 21, 7:57 am, Dan <daniel.oster..._at_visaer.com> wrote:
> On Jun 21, 8:35 am, John Hurley <hurleyjo..._at_yahoo.com> wrote:
>
>
>
>
>
> > On Jun 20, 10:46 pm, Dan <daniel.oster..._at_visaer.com> wrote:
>
> > > On Jun 20, 7:55 pm, ddf <orat..._at_msn.com> wrote:
>
> > > > On Jun 20, 2:27 pm, Dan <daniel.oster..._at_visaer.com> wrote:
>
> > > > > Gerald,
>
> > > > > Good question. I don't know why either. I checked those
> > > > > environmental variables, neither are set. I found that I can connect
> > > > > this way in svrmgr30:
>
> > > > > connect internal/<PW>_at_<SID>
>
> > > > > This means it clearly uses tns, but why? Also I always get the
> > > > > ora-12203 error as soon as I get into svrmgr30, even before I do a
> > > > > connect internal. I've found some people who've gotten this error and
> > > > > suggestions are always tns/listener or sqlnet.ora. I even did some
> > > > > registry hacks in the HOME0 but no luck. I'm completely stumped. It's
> > > > > probably something simple, but no luck so far.
>
> > > > > Dan
>
> > > > > On Jun 19, 2:47 pm, "Gerard H. Pille" <g..._at_skynet.be> wrote:
>
> > > > > > Why would svrmgr try to connect to a database using TNS?
>
> > > > > > Why would it try to connect to a remote database?
>
> > > > > > Do you perhaps have LOCAL or TWO_TASK defined?
>
> > > > > > open a dos-box in your whinedoze environment, and try
>
> > > > > > echo %LOCAL%
> > > > > > echo %TWO_TASK%
>
> > > > > > or verify the output from "set"- Hide quoted text -
>
> > > > > - Show quoted text -
>
> > > > Can you successfully tnsping the service? What HOST is being used in
> > > > the listner.ora? Is a loopback adapter installed?
>
> > > > David Fitzjarrell- Hide quoted text -
>
> > > > - Show quoted text -
>
> > > David,
>
> > > Thanks for jumping in, appreciate the help.
>
> > > I can successfully tnsping my ORCL database. The host in the listener
> > > is the server that I reside on, which it should be. I've pasted the
> > > listener.ora below and changed the actual server name to MYSERVER.
> > > I've done nothing to the listener except manually add the PILT
> > > database to it. The ORCL database was added when I had the installer
> > > create ORCL.
>
> > > Regarding the loopback adapter, there is none shown in the Device
> > > Manager. Should there be one installed? I've never done much with
> > > them so I'm not much of an expert. SHould something be set up with
> > > this?
>
> > > Dan
>
> > > PASSWORDS_LISTENER= (oracle)
>
> > > LISTENER =
> > > (ADDRESS_LIST =
> > > (ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world))
> > > (ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
> > > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> > > (ADDRESS = (PROTOCOL = NMP)(SERVER = MYSERVER)(PIPE = ORAPIPE))
> > > (ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVER)(PORT = 1521))
> > > (ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVER)(PORT = 1526))
> > > (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
> > > )
>
> > > SID_LIST_LISTENER =
> > > (SID_LIST =
> > > (SID_DESC =
> > > (GLOBAL_DBNAME = MYSERVER)
> > > (SID_NAME = ORCL)
> > > )
> > > (SID_DESC =
> > > (GLOBAL_DBNAME = MYSERVER)
> > > (SID_NAME = PILT)
> > > )
> > > (SID_DESC =
> > > (SID_NAME = extproc)
> > > (PROGRAM = extproc)
> > > )
> > > )
>
> > Do you really have entries for both 1521 and 1526 on the same host?- Hide quoted text -
>
> > - Show quoted text -
>
> I did a netstat -a and there is a 1526 port that is listening. I've
> not configured anything on it though, the tnsnames entries point to
> 1521. I just commented out the 1526 line in listener.ora and bounced
> the listener but it didn't help the ora-12203 issue.
>
> Here are my tnsnames and sqlnet.ora files to look at also, maybe you
> can see something that I'm not seeing. Keep in mind this is the
> current iteration of these files, I've tried several changes/
> commenting out/additions. These were all generated by the default
> Oracle install. The database I'm working with is the default install
> db ORCL.
>
> tnsnames.ora:
> # C:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configuration File:C:\orant
> \net80\admin\tnsnames.ora
> # Generated by Oracle Net8 Assistant
>
> CMEXAMPLE.WORLD =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = CM_SERVER)(PORT = 1610))
> (ADDRESS = (PROTOCOL = TCP)(HOST = LSNR_SERVER)(PORT = 1521))
> )
> (CONNECT_DATA = (SID = ORCL))
> (SOURCE_ROUTE = YES)
> )
>
> TCPEXAMPLE.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = Production1)(PORT = 1521))
> (CONNECT_DATA = (SID = ORCL))
> )
>
> NMPEXAMPLE.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = NMP)(Server = FinanceServer1)(Pipe =
> ORAPIPE))
> (CONNECT_DATA = (SID = ORCL))
> )
>
> ORCL.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVER)(PORT = 1521))
> (CONNECT_DATA = (SID = ORCL))
> )
>
> EXTPROC_CONNECTION_DATA.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0))
> (CONNECT_DATA = (SID = extproc))
> )
>
> PILT.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVER)(PORT = 1521))
> (CONNECT_DATA = (SID = PILT))
> )
>
> BEQ-LOCAL.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle80)(ARGV0 =
> oracle80ORCL)(ARGS = '(DESCRIPTION=(LOCAL=YES)
> (ADDRESS=(PROTOCOL=BEQ)))'))
> (CONNECT_DATA = (SID = ORCL))
> )
>
> SPXEXAMPLE.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = SPX)(Service = Server_lsnr))
> (CONNECT_DATA = (SID = ORCL))
> )
>
> TCP-LOOPBACK.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
> (CONNECT_DATA = (SID = ORCL))
> )
>
> Sqlnet.ora
> # C:\ORANT\NET80\ADMIN\SQLNET.ORA Configuration File:C:\orant
> \net80\admin\sqlnet.ora
> # Generated by Oracle Net8 Assistant
>
> TRACE_DIRECTORY_CLIENT = C:\TEMP
>
> NAME.DEFAULT_ZONE = world
>
> NAMES.DEFAULT_DOMAIN = world
>
> SQLNET.AUTHENTICATION_SERVICES= (NONE)
>
> TRACE_FILE_CLIENT = client
>
> TRACE_LEVEL_CLIENT = SUPPORT
>
> SQLNET.EXPIRE_TIME = 0
>
> #NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)- Hide quoted text -
>
> - Show quoted text -
What do you see in the cli*.trc files? Is Oracle looking for connection data in a location other than what tnsping reports?
David Fitzjarrell Received on Tue Jun 21 2011 - 11:00:01 CDT