Re: Oracle 8.0.5 error
Date: Tue, 21 Jun 2011 07:57:32 -0700 (PDT)
Message-ID: <470aa20d-0614-476a-a5d2-da4aa786f847_at_d7g2000vbv.googlegroups.com>
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) Received on Tue Jun 21 2011 - 09:57:32 CDT