Hi,
I checked using sqlplus prompt i am able to connect to oracle.
Now i installed oracle on my windows machine.
I am using the sample-config.tcl file which is running fine.
After that i made changes in it for oracle connectivity.
Changes are:
1. I added following lines in the ns_section
"ns/server/${servername}/modules"
ns_param nsdb ${bindir}/nsdb${shlibext}
ns_param ora8 ${bindir}/nsoracle${shlibext}
2. I added following lines at the and of sample-config.tcl file
#driver load
ns_section "ns/server/${servername}/db/nsdb"
ns_param nsdb nsdb.dll
ns_param ora8 nsoracle.dll
ns_section "ns/db/pools"
ns_param users users
ns_section "ns/db/pool/users"
ns_param Driver ora8
ns_param Connections 5
ns_param User System
ns_param Password manager
ns_param LogSQLErrors on
ns_param Datasource ""
ns_param ExtendedTableInfo On
ns_section "ns/server/${servername}/db"
ns_param pools * ;# Wildcard gives access to all
ns_param defaultpool "users"
After that i am executing nsd command server.log is being generated.
I am attaching the server.log file while loading both nsdb and nsoracle.
I also checked without loading nsoracle.dll and i am attaching the
server.log file without nsoracle.dll also.
Please check where i am doing wrong.
I am also attaching the sample-config.tcl file.
Errors are:
1. [10/Jan/2005:12:25:02][1184.1608][-main-] Error: dbdrv: no such driver
'ora8'
I am using ora8 in the following ns_param
ns_param Driver ora8
I also checked using
ns_param Driver nsoracle
Which driver i have to specify?
2.[10/Jan/2005:12:25:02][1184.1608][-main-] Error: dbinit: no such default
pool 'users'
Where i have to specify default pool.
Please reply me soon?
Thanks & regards,
Rakesh
----- Original Message -----
From: "Andrew Piskorski" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, January 07, 2005 10:56 PM
Subject: Re: [AOLSERVER] Problem in installing AOLServer 4.0.8 with oracle
> On Fri, Jan 07, 2005 at 10:08:28PM +0530, Rakesh Mahajan wrote:
> > I am trying it on linux as well as on windows.
> > I am facing problem on both platform.
> >
> > I am attaching tcl files for both windows and linux.
> > Please check it and inform what i am doing wrong.
>
>
> > filename="oracleLinux.tcl"
>
> > set home \usr\local\aolserver
> > set address $host
>
> That's broken, those backslashes need to be forward slashes -
> ESPECIALLY because your running this on Linux, but from inside Tcl,
> you should always use "/" as the directory separator, even on Windows.
>
> > ns_section "ns/servers/${sname}/db"
> > ns_param Pools *
> > ns_param defaultpool users
>
> > ns_section "ns/servers/${sname}/modules"
> > ns_param nsthread nsthread.so
> > ns_param nssock nssock.so
> > ns_param nslog nslog.so
> > ns_param nsperm nsperm.so
> > ns_param nsd nsd.so
> > ns_param nsdb nsdb.so
> > ns_param nscp nscp.so
>
> Why are you trying to load nsd.so and nsthread.so as modules? That
> makes no sense.
>
> The other modules shouldn't hurt anything, but you certainly don't
> need that many just to get AOLserver up and running. For a minimal
> config just to let you test Oracle connectivity, try loading ONLY
> these:
>
> ns_section "ns/servers/${sname}/modules"
> ns_param nssock nssock.so
> ns_param nslog nslog.so
> ns_param nsdb nsdb.so
>
> > ns_section "ns/db/drivers"
> > ns_param ora8 nsoracle.so
> >
> > ns_section "ns/db/pools"
> > ns_param users users
>
> Where is your "users" pool defined? I don't see it anywhere in your
> config file.
>
> > ns_section "ns/db/pool/users"
> > ns_param Driver ora8
> > ns_param Connections 5
> > ns_param User system
> > ns_param Password manager
> > ns_param LogSQLErrors on
> > ns_param Datasource "orcl"
> > ns_param ExtendedTableInfo On
>
> Can you connect to "orcl" via sqlplus? Try this:
>
> sqlplus system/[EMAIL PROTECTED]
>
> If that does not work, then your problem is that your Oracle client
> configuration on this box is wrong. Most likely you need to fix your
> "$ORACLE_HOME/network/admin/tnsnames.ora" file.
>
> Where is this Oracle database running, on a remote machine? If
> remote, then you need to use it as above. If the server is local, you
> can also use 'ns_param Driver {}' above, to connect to Oracle using
> it's Bequeath connection method.
>
> > ns_section "ns/server/${servername}/db"
> > ns_param pools * ;# Wildcard gives access to all
> > ns_param defaultpool "main"
>
> You have no "main" pool configured at all, so that's definitely
> broken.
>
> > ns_section ns/servers/${server}/db
> > ns_param pools "*"
> > ns_param defaultpool pool1
>
> You've just repeated the same section as above, but using a different
> server name variable. That makes little sense. Do you really have
> both a $servername and $server Tcl variables defined in your config
> file? Why? Looks like you have several simple Tcl bugs in your
> config file.
>
> --
> Andrew Piskorski <[EMAIL PROTECTED]>
> http://www.piskorski.com/
>
>
> --
> AOLserver - http://www.aolserver.com/
>
> To Remove yourself from this list, simply send an email to
<[EMAIL PROTECTED]> with the
> body of "SIGNOFF AOLSERVER" in the email message. You can leave the
Subject: field of your email blank.
>
>
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]>
with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
field of your email blank.
serverwith Nsdb only.log
Description: Binary data
serverwith Nsdb and nsoracle both.log
Description: Binary data
sample-config.tcl
Description: Binary data
