Hello, Khosro
Thanks again for your answer.
I read the url yo sent me, and it's very interesting.
Yesterday I tried others things.
My configuration is:
Sparc processor
Solaris 10
Oracle 10
Java JDK 1.5.0_06
Apache Maven 2.0.8
Apache Ant 1.7.0
Jakarta Tomcat 6.0
I finally put the string conection in two manners:
1) db.url =
jdbc:oracle:thin:@//machine.subdomain.domain:port/service_name
2) db.url = jdbc:oracle:thin:@machine.subdomain.domain:port:sid_name
I saw the messages in the log of the Oracle listener, with both url in
the config file when I executed
$ ant fres_install
1)
10-JUL-2008 11:48:15 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=service_name)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=host_ip)(PORT=48876)) * establish *
service_name * 0
2)
10-JUL-2008 11:52:01 *
(CONNECT_DATA=(SID=sid_name)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=host_ip)(PORT=48907)) * establish *
sid_name * 0
It look then connection is established, but inmediately it is
disconnected from the client.
Now I have a new error in the output of the $ ant fres_install command:
(…)
[java] 2008-07-10 11:52:01,334 INFO
org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
[java] 2008-07-10 11:52:02,695 FATAL
org.dspace.storage.rdbms.InitializeDatabase @ Caught exception:
[java] org.apache.commons.dbcp.SQLNestedException: Cannot get a
connection, pool exhausted
(…)
Any suggestions?
Marisa.
khosro asgharifard escribió:
> Hello Marisa,
> XE is a service name.
> Please refer to
> http://download.oracle.com/docs/cd/B25329_01/doc/admin.102/b25107/connecting.htm#CEGIGEIJ.
> In "Connect Strings" subsection you can see the line
> "username/[EMAIL PROTECTED]//]host[:port][/service_name]" ,read the bottom of
> this line,there is a description.
>
> Best Regards.
>
> Khosro.
>
>
> ----- Original Message ----
> From: María Isabel López Sánchez-Huete <[EMAIL PROTECTED]>
> To: khosro asgharifard <[EMAIL PROTECTED]>
> Sent: Thursday, July 10, 2008 12:52:02 AM
> Subject: Re: [Dspace-tech] New problem installing DSpace
>
> Hi, Khosro
>
> Thanks for your rapid answer.
>
> I have changed the "." by ¨":" in my db.url. It's really a bug in the
> documentation
>
> What does it mean XE? Is it the database name?
>
> Marisa.
>
> khosro asgharifard escribió:
> > Hello Marisa,
> > I am not expert in Dspace.I am a novice.But two days ago when i wanted
> > to install Dspace i faced this error.
> > You found in install.html in (step3->Oracle->iii) the
> > "db.url = jdbc.oracle.thin:@//host:port/dspace" ,As far as i remember i
> > changed it
> > to "db.url = jdbc:oracle:thin:@//localhost:1521/XE"
> > I use Oracle 10g express edition in windows.Please pay attention to
> > changing "." to ":" and pay attention to XE.
> > Maybe this helps you.
> >
> > Khosro.
> >
> > ----- Original Message ----
> > From: María Isabel López Sánchez-Huete <[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>>
> > To: [email protected]
> <mailto:[email protected]>
> > Sent: Wednesday, July 9, 2008 3:35:30 AM
> > Subject: [Dspace-tech] New problem installing DSpace
> >
> > Hi,
> >
> > I don´t now if somebody is really reading this list, but I try to ask
> > again. I hope someday somebody can respond to me.
> >
> > This installation is very difficult to me, perhaps because the
> > documentation is written thinking in an linux operating system with a
> > Postgres database. But this is not my case: Sparc, Solaris 10 and Oracle.
> >
> > Now I arrive to the 7 point in the installation instructions, and I
> > find a new error. When I execute
> >
> > ant fres_install
> >
> > the new error that arise is:
> > [java] 2008-07-04 13:37:25,750 INFO
> > org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
> > [java] 2008-07-04 13:37:26,391 FATAL
> > org.dspace.storage.rdbms.InitializeDatabase @ Caught exception:
> > [java] java.sql.SQLException: Listener refused the connection with
> > the following error:
> > [java] ORA-12514, TNS:listener does not currently know of service
> > requested in connect descriptor
> > [java] The Connection descriptor used by the client was:
> > [java] //machine.subdom.dom:1711/database
> >
> > The database is up and the connections test are ok.
> >
> > Somebody knows what is happening?
> >
> > Thanks in advance.
> >
> > Marisa.
> >
> > --
> >
> > -------------------------------------------------------------------------
> > Sponsored by: SourceForge.net <http://SourceForge.net>
> <http://SourceForge.net> Community Choice
> > Awards: VOTE NOW!
> > Studies have shown that voting for your favorite open source project,
> > along with a healthy diet, reduces your potential for chronic lameness
> > and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> > _______________________________________________
> > DSpace-tech mailing list
> > [email protected]
> <mailto:[email protected]>
> <mailto:[email protected]
> <mailto:[email protected]>>
> > https://lists.sourceforge.net/lists/listinfo/dspace-tech
> >
>
>
-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
