Home » RDBMS Server » Performance Tuning » connect database
connect database [message #536044] Mon, 19 December 2011 02:03 Go to next message
sirumon
Messages: 8
Registered: December 2011
Location: Dhaka
Junior Member
Hi,
I'm new in Oracle XE. Please help

XE has been setup. Then in Command Prompt
*************************************
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\sirajul>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 19 13:33:47 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: hr/hr

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL>
***************************************************
Here Connection is successful.

But While I setup Oracle Forms Developer 10g, The above process no longer on success in Command Prompt.
I experience TNS:protocol adapter error
*********************************************

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\sirajul>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 19 13:33:47 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: hr/hr
ORA-12560:TNS:protocol adapter error

***********************************************

When I deinstall Developer Suit 10g Then the problem is solved.

Please help.

with regards
[[mailto:mdsirumon@yahoo.com|mdsirumon@yahoo.com]]
Re: connect database [message #536049 is a reply to message #536044] Mon, 19 December 2011 02:16 Go to previous messageGo to next message
Michel Cadot
Messages: 67241
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The new installation changes your default environment that is variables ORACLE_HOME, ORACLE_SID, PATH.

Regards
Michel
Re: connect database [message #536060 is a reply to message #536049] Mon, 19 December 2011 02:36 Go to previous messageGo to next message
sirumon
Messages: 8
Registered: December 2011
Location: Dhaka
Junior Member
Dear,Michel

How do I examine default environment that is variables ORACLE_HOME, ORACLE_SID, PATH.

As I'm beginner please help with an example.

With Best Regards
mdsirumon@yahoo.com
Re: connect database [message #536062 is a reply to message #536060] Mon, 19 December 2011 02:39 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
In windows, at the cmd prompt type "ECHO ORACLE_HOME" ECHO.... etc
Re: connect database [message #536063 is a reply to message #536062] Mon, 19 December 2011 02:48 Go to previous messageGo to next message
sirumon
Messages: 8
Registered: December 2011
Location: Dhaka
Junior Member

C:\Documents and Settings\sirajul>ECHO ORACLE_HOME
ORACLE_HOME

C:\Documents and Settings\sirajul>
Re: connect database [message #536065 is a reply to message #536063] Mon, 19 December 2011 02:49 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
Sorry, mixed up my OS's - in windows its "SET ...."
Re: connect database [message #536067 is a reply to message #536065] Mon, 19 December 2011 02:51 Go to previous messageGo to next message
Michel Cadot
Messages: 67241
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
or "echo %ORACLE_HOME%"

Regards
Michel
Re: connect database [message #536071 is a reply to message #536067] Mon, 19 December 2011 02:58 Go to previous messageGo to next message
sirumon
Messages: 8
Registered: December 2011
Location: Dhaka
Junior Member
C:\Documents and Settings\sirajul>echo %ORACLE_HOME%
%ORACLE_HOME%

C:\Documents and Settings\sirajul>
Re: connect database [message #536072 is a reply to message #536071] Mon, 19 December 2011 03:00 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
That would suggest it is not set. Try setting it.
Re: connect database [message #562345 is a reply to message #536072] Tue, 31 July 2012 09:19 Go to previous messageGo to next message
sirumon
Messages: 8
Registered: December 2011
Location: Dhaka
Junior Member
Dear Michel,

Please explain the reason occurring in two scenario in windows XP:

1.when trying as:

All Program>Oracle Database 10g Express Edition>Run SQL Command Line>Enter.

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 31 20:03:27 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect
Enter user-name: hr
Enter password:
Connected.
SQL>



2. When trying from cmd:
Run>CMD

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\sirajul>sqlplus

SQL*Plus: Release 11.1.0.7.0 - Production on Tue Jul 31 20:13:05 2012

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Enter user-name: hr
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:


I appreciate your valuable tips to get rid around.

Regards
Sirajul
Re: connect database [message #562346 is a reply to message #562345] Tue, 31 July 2012 09:31 Go to previous messageGo to next message
BlackSwan
Messages: 26722
Registered: January 2009
Location: SoCal
Senior Member
how many different Oracle version or DB have been installed on this system?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: connect database [message #562350 is a reply to message #562345] Tue, 31 July 2012 10:51 Go to previous messageGo to next message
Michel Cadot
Messages: 67241
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you just post what has been asked that is the result of command SET you will see that ORACLE_HOME and/or ORACLE_SID is not set.

Regards
Michel
Re: connect database [message #562403 is a reply to message #562350] Wed, 01 August 2012 05:51 Go to previous messageGo to next message
sirumon
Messages: 8
Registered: December 2011
Location: Dhaka
Junior Member
----Sorry
There is another installation of 11g fusion middleware.
De-installation that one is quite enough for me at this moment. Yet there any other options to fix this besides
ORACLE_HOME and/or ORACLE_SID set other than De-installation.

Regards
Sirajul

Re: connect database [message #562405 is a reply to message #562403] Wed, 01 August 2012 06:13 Go to previous message
Michel Cadot
Messages: 67241
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't understant your post.
Are you or not on the database server?
Are you on client worstation or application server different from the database server?
In both cases post the result of "SET".

Regards
Michel
Previous Topic: Oracle 11g high memory usage dbw0 and dbw1
Next Topic: where the second fetch data ?
Goto Forum:
  


Current Time: Mon Jul 13 14:11:17 CDT 2020