Home » SQL & PL/SQL » SQL & PL/SQL » Can not connect to database (Oracle 10g)
Can not connect to database [message #379301] Tue, 06 January 2009 00:19 Go to next message
sachinsudden
Messages: 5
Registered: January 2008
Location: kolhapur
Junior Member
Hi ,

I have data for Oct-08,Nov-08 and Dec-08 in table table1. From application I call repoert which shows data contains Current month and last month. When I call report , shows Jan-09 and Dec-08 but I dont have data for Jan-09.

For testing purrpose, I set date of server is 30-dec-08. Now when I call report it gives me error as "Can not open database". What should I do? I have to check data of previous year i.e 2008.

Please help.
Thanks in advance.

Regards,
Sachin
Re: Can not connect to database [message #379305 is a reply to message #379301] Tue, 06 January 2009 00:25 Go to previous messageGo to next message
trivendra
Messages: 208
Registered: October 2007
Location: Noida, India
Senior Member
Why are changing the date of server, You can pass your date as

TRUNC(ADD_MONTHS(SYSDATE,-1),'MM')


Try with this

Thanks
Trivendra
Re: Can not connect to database [message #379312 is a reply to message #379301] Tue, 06 January 2009 00:55 Go to previous messageGo to next message
sachinsudden
Messages: 5
Registered: January 2008
Location: kolhapur
Junior Member
Thank you for reply.
I am not passing date from Screen(Front end). Also I cant change the queries. I have to change server date or anything else.
Re: Can not connect to database [message #379320 is a reply to message #379301] Tue, 06 January 2009 01:14 Go to previous messageGo to next message
trivendra
Messages: 208
Registered: October 2007
Location: Noida, India
Senior Member
so pass your date as 01-Dec-2008 or 01/12/2008 as an input parameter.
Re: Can not connect to database [message #379322 is a reply to message #379301] Tue, 06 January 2009 01:19 Go to previous messageGo to next message
sachinsudden
Messages: 5
Registered: January 2008
Location: kolhapur
Junior Member
What will happen if i changed database date??
Re: Can not connect to database [message #379332 is a reply to message #379322] Tue, 06 January 2009 02:06 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
How did you change the date?

It's very unlikely that setting the fixed sysdate value would prevent you from connecting to the database, but as you don't provide much in the way of details, we can't provide much in the way of help.

'Cannot open database' is not an oracel error message - can you show us the actual error message that you get?
Re: Can not connect to database [message #379381 is a reply to message #379301] Tue, 06 January 2009 04:33 Go to previous messageGo to next message
sachinsudden
Messages: 5
Registered: January 2008
Location: kolhapur
Junior Member
I am getting following error while taking report(I changed system date to Dec 08)

Failed to view report from BusinessObjects. Exception=com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: Failed to open the connection.
Cannot open database.
Failed to open the connection.
C:\WINDOWS\TEMP\{E08743FF-F935-4476-A6FB-08CE3B4CF6EF}.rpt---- Error code:-2147482892 Error code name:failed
Re: Can not connect to database [message #379382 is a reply to message #379301] Tue, 06 January 2009 04:36 Go to previous messageGo to next message
sachinsudden
Messages: 5
Registered: January 2008
Location: kolhapur
Junior Member
Also when I try to connect thro' PL/SQL developer, it shows

"ORA-28547 connection to server failed, probable Net8 admin error"

Re: Can not connect to database [message #379626 is a reply to message #379382] Wed, 07 January 2009 06:58 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
ORA-28547: connection to server failed, probable Oracle Net admin error
    Cause: A failure occurred during initialization of a network connection from a client process to the Oracle server: The connection was completed but a disconnect occurred while trying to perform protocol-specific initialization, usually due to use of different network protocols by opposite sides of the connection. This usually is caused by incorrect Oracle Net administrative setup for database links or external procedure calls. The most frequent specific causes are: -- The connection uses a connect string which refers to a Heterogeneous Services agent instead of an Oracle server. -- The connection uses a connect string which includes an (HS=) specification.
    Action: Check Oracle Net administration in the following ways: -- When using TNSNAMES.ORA or an Oracle Names server, make sure that the client connection to the ORACLE server uses the correct service name or SID. -- Check LISTENER.ORA on the connection end point's host machine to assure that this service name or SID refers to the correct server. -- Confirm in TNSNAMES.ORA or the equivalent service definition that the connect string does NOT contain (HS=).


What do you get trying to connect from SQL*Plus

Have yuo changed anything in your$ORACLE_HOME/network/admin directory?
Previous Topic: Query about the in-built functions in Oracle
Next Topic: how to combine two queries
Goto Forum:
  


Current Time: Sat Dec 03 12:13:18 CST 2016

Total time taken to generate the page: 0.08470 seconds