Hi Kindra,
> I'm attaching a new books script that my predecessor created.
I didn't see an attached script, but I'll take a shot anyway...
> I'm trying to get this to run, but I'm coming up with errors.
> I'm almost sure it is because of the upgrade to Unicode (we're
> with Endeavor)
Typically, a Perl DBI/DBD script needs to have certain database related
environment parameters set. With your Oracle upgrade, those parameters
have changed.
If the script included lines like this:
$ENV{ORACLE_SID} = "LIBR";
$ENV{ORACLE_HOME} = "/oracle/app/oracle/product/8.0.5";
It will need to be changed to this (for Voyager with Unicode):
$ENV{ORACLE_SID} = "VGER";
$ENV{ORACLE_HOME} = "/oracle/app/oracle/product/9.2.0";
> the read-only password changing.
You will want to use the read-only username and password that works with
your Voyager canned reports (i.e. reports.mdb).
-- Michael
# Michael Doran, Systems Librarian
# University of Texas at Arlington
# 817-272-5326 office
# 817-688-1926 cell
# [EMAIL PROTECTED]
# http://rocky.uta.edu/doran/
> -----Original Message-----
> From: Kindra Morelock [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 27, 2005 10:15 AM
> To: perl4lib@perl.org
> Subject: new books list
>
> Hi all,
>
> I'm attaching a new books script that my predecessor created. I'm
> trying to get this to run, but I'm coming up with errors. I'm almost
> sure it is because of the upgrade to Unicode (we're with
> Endeavor) with
> the read-only password changing. I suspect it has something
> to do with
> the oracle instance being called "VGER" now, but I'm not sure
> how to fix
> it. I did change the read-only username/password from
> "dbread" to ours,
> "ro_trinitydb".
>
> Would there be a kind soul out there willing to look at this
> script and
> help me figure out what I need to do to get this to work?
> When I run it
> from the command line, I get the following errors:
>
> DBI connect('','ro_trinitydb',...) failed: ORA-01034: ORACLE not
> available
> ORA-27101: shared memory realm does not exist
> SVR4 Error: 2: No such file or directory (DBD ERROR: OCISessionBegin)
> at ./new_books.html line 147
> Database connection not made: ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> SVR4 Error: 2: No such file or directory (DBD ERROR: OCISessionBegin)
> at ./new_books.html line 147.
>
> Thanks,
> Kindra
>
> ^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^
> Kindra I. Morelock
> Library Systems Administrator
> Trinity International University
> 2065 Half Day Road
> Deerfield, IL 60015
> (847) 317-4021
>
