Re: Oracle 8.0.5 error
From: Dan <daniel.ostertag_at_visaer.com>
Date: Tue, 21 Jun 2011 19:01:50 -0700 (PDT)
Message-ID: <f0574ce4-fc89-4cef-a6ca-a11832ec1a36_at_gv8g2000vbb.googlegroups.com>
On Jun 21, 12:00 pm, ddf <orat..._at_msn.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -
Date: Tue, 21 Jun 2011 19:01:50 -0700 (PDT)
Message-ID: <f0574ce4-fc89-4cef-a6ca-a11832ec1a36_at_gv8g2000vbb.googlegroups.com>
On Jun 21, 12:00 pm, ddf <orat..._at_msn.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -
Here is the trace file. Do you see anything? TNSNAV.ora?
- TRACE CONFIGURATION INFORMATION FOLLOWS --- New trace stream is "C:\TEMP\client.trc" New trace level is 16
- TRACE CONFIGURATION INFORMATION ENDS --- nigini: entry nigini: Count in NI global area now: 1 nigini: Count in NI global area now: 1 nrigbi: entry nrigbni: entry nrigbni: Unable to get data from navigation file tnsnav.ora nrigbni: exit nrigbi: exit nigini: exit niqname: Hst is already an NVstring. niqname: Inserting CID. (4d44) niotns: entry (4d44) niotns: niotns: setting up interrupt handler... (4d44) niotns: Not trying to enable dead connection detection. (4d44) niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80) (ARGV0=oracle80orcl)(ARGS='(DESCRIPTION=(LOCAL=YES) (ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C: \orant\bin\SVRMGR30.EXE)(HOST=WRIGHT-UUJCBBFS)(USER=Administrator)))) (4d44) nricall: entry (4d44) nric2a: entry (4d44) nric2a: Getting local community information (4d44) nriglp: entry (4d44) nriglp: Looking for local addresses setup by nrigla (4d44) nriglp: No addresses in the preferred address list (4d44) nriglp: exit (4d44) nric2a: TNSNAV.ORA is not present. No local communities entry. (4d44) nrigla: entry (4d44) nrigla: Getting local address information (4d44) nrigla: Address list being processed. (4d44) nrigla: No community information so all addresses are local (4d44) nrigla: exit (4d44) nridst: entry (4d44) nridst: Resolving address to use to call destination or next hop (4d44) nridst: Processing address list. (4d44) nridst: No community entries so iterate over address list (4d44) nridst: exit (4d44) nric2a: This is a local community access (4d44) nric2a: exit (4d44) nricall: Got routable address information. (4d44) nricall: Making call with following address information: (DESCRIPTION=(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\orant\bin \SVRMGR30.EXE)(HOST=WRIGHT-UUJCBBFS)(USER=Administrator))) (ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80orcl) (ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))). (4d44) nricdt: entry (4d44) nricdt: Calling with outgoing connect data: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80) (ARGV0=oracle80orcl)(ARGS='(DESCRIPTION=(LOCAL=YES) (ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C: \orant\bin\SVRMGR30.EXE)(HOST=WRIGHT-UUJCBBFS)(USER=Administrator)))). (4d44) nscall: entry (4d44) nscall: connecting... (4d44) nsc2addr: entry (4d44) nlpcaini: entry (4d44) nlpcaini: prg = (4d44) nlpcaini: arg[0] = (4d44) nlpcaini: arg[1] = (4d44) nlpcaini: exit (4d44) nsc2addr: normal exit (4d44) nsopen: entry (4d44) nsmal: entry (4d44) nsmal: 400 bytes at 0xbb7eb0 (4d44) nsmal: normal exit (4d44) nsnainconn: entry (4d44) nsmal: entry (4d44) nsmal: 1664 bytes at 0xbb5238 (4d44) nsmal: normal exit (4d44) nsnainconn: normal exit (4d44) nsopen: opening transport... (4d44) ntpcon: entry (4d44) ntpcon: toc = 1 (4d44) sntpcall: entry (4d44) ntpcon: exit (4d44) nserror: entry (4d44) nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=0, nt[2]=0 (4d44) nsopen: unable to open transport (4d44) nsmfr: entry (4d44) nsmfr: 1664 bytes at 0xbb5238 (4d44) nsmfr: normal exit (4d44) nsmfr: entry (4d44) nsmfr: 400 bytes at 0xbb7eb0 (4d44) nsmfr: normal exit (4d44) nsopen: error exit (4d44) nscall: error exit (4d44) nricdt: Call failed. (4d44) nricfg: entry (4d44) nricfg: exit (4d44) nricdt: Call made to destination. (4d44) nricdt: Processing address list so continuing. (4d44) nricdt: exit (4d44) nric2a: entry (4d44) nric2a: Getting local community information (4d44) nriglp: entry (4d44) nriglp: Looking for local addresses setup by nrigla (4d44) nriglp: No addresses in the preferred address list (4d44) nriglp: exit (4d44) nric2a: TNSNAV.ORA is not present. No local communities entry. (4d44) nrigla: entry (4d44) nrigla: Getting local address information (4d44) nrigla: Address list being processed. (4d44) nrigla: Processed all addresses in address list. Failed to make contact. (4d44) nrigla: exit (4d44) nric2a: exit (4d44) nricie: entry (4d44) nricie: Result descriptor: 12203,12560,530,0. (4d44) nricie: Result descriptor: 12203,12560,530,0 from Interchange: (4d44) nricie: exit (4d44) nricall: Failed to copy originating community name value binding. (4d44) nricall: Exiting NRICALL with following termination result: -1. (4d44) nricall: exit (4d44) nioqper: error from nricall (4d44) nioqper: nr err code: 12203 (4d44) nioqper: ns main err code: 12560 (4d44) nioqper: ns (2) err code: 0 (4d44) nioqper: nt main err code: 530 (4d44) nioqper: nt (2) err code: 0 (4d44) nioqper: nt OS err code: 0 (4d44) niqme: entry (4d44) niqme: reporting nr (1) error: (12203) as rdbms err (12203) (4d44) niqme: exit (4d44) niotns: Couldn't connect, returning 12203 (4d44) nsbfrfl: entry (4d44) nsbfrfl: normal exit nigtrm: Count in the NI global area is now 0 nrigbd: entry nrigbd: exit nigtrm: Count in the NL global area is now 0