Home » Other » General » Oracle Installation (2 Merged) (Oracle 11G R2)
Oracle Installation (2 Merged) [message #534182] Sat, 03 December 2011 20:36 Go to next message
ordbas11
Messages: 4
Registered: December 2011
Junior Member
I have installed Oracle 11G R2 for Microsoft Windows(x64)--Enterprise Edition on my laptop with Windows 7 Enterprise 64 bit Operating System

I am having problems with the installation.

This is how I installed it--

Step 2--Create and Configure a Database
Step 3--Desktop Class
Step 4--Typical Installation
Step 5--Prerequisite Checks
Step 6--Summary
Step 7--Install Product
Step 8--Finish
The Installation of Oracle Database was successful

I am trying to install a financial software that will use this Oracle database.

It asks me Database Properties

I enter the following:

Server Address--P7WZAC9
Port--1521
Oracle Version--Oracle 11G R2
Oracle Home: C:\Oracle\product\11.2.0\dbhome_1
TNS Alias--orcl
Database Instance--orcl
Schema Owner--DBO
User: dbo
Password--ababab

It performs Verify Database properties

It fails on Verify SQL tool OS bits compatilibility

I get two error messages

1) The SQL tool (SQLPLUS) used to connect to the database has not the correct bits compatibility (like 32 bits tool with a 64 bits distribution),Please install a correct version.

2) Error cannot connect with JDBC.Oracle.Thin
Error cannot connect with JDBC.Oracle.Thin@P7WZAC9.1521.orcl(user=dbo,password=ababab)


How do I fix this?

Re: Oracle Installation [message #534184 is a reply to message #534182] Sat, 03 December 2011 20:43 Go to previous messageGo to next message
BlackSwan
Messages: 26733
Registered: January 2009
Location: SoCal
Senior Member
I am sorry to see that COPY & PASTE are broken for you.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

do as below
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE	11.2.0.1.0	Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
Re: Oracle Installation (2 Merged) [message #534190 is a reply to message #534182] Sat, 03 December 2011 23:33 Go to previous messageGo to next message
Michel Cadot
Messages: 67363
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Error cannot connect with JDBC.Oracle.Thin


Error? Which error?
Note that unless you created it, "dbo" account does not exist.

Regards
Michel
Re: Oracle Installation (2 Merged) [message #534196 is a reply to message #534182] Sun, 04 December 2011 04:36 Go to previous messageGo to next message
John Watson
Messages: 8344
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. You need to give more information before anyone csn help. What actually happens when you try to connect? The best way to show this is with COPY and PASTE. For example, for SQL*Plus, run it from a DOS prompt and copy the entire session so that we can all see exactly what you did and what happedn. Like this:
c:\users\john\home>
c:\users\john\home>sqlplus dba/ababab@orcl

SQL*Plus: Release 11.2.0.3.0 Production on Sun Dec 4 10:33:49 2011

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

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Enter user-name:
Note that I have formatted the copy/paste with [code] tages, please do this as described hereHow to use [code] tags and make your code easier to read.
Re: Oracle Installation (2 Merged) [message #534221 is a reply to message #534196] Sun, 04 December 2011 12:22 Go to previous messageGo to next message
ordbas11
Messages: 4
Registered: December 2011
Junior Member
C:\Users\ordbas11>sqlplus system/System123@orcl

SQL*Plus: Release 11.2.0.2.0 Production on Sun Dec 4 13:13:03 2011

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
Re: Oracle Installation (2 Merged) [message #534225 is a reply to message #534221] Sun, 04 December 2011 13:14 Go to previous messageGo to next message
Michel Cadot
Messages: 67363
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ And with JDBC?
2/ "system" is NOT "dbo"

Regards
Michel

[Updated on: Sun, 04 December 2011 13:15]

Report message to a moderator

Re: Oracle Installation (2 Merged) [message #534226 is a reply to message #534182] Sun, 04 December 2011 14:11 Go to previous messageGo to next message
ordbas11
Messages: 4
Registered: December 2011
Junior Member
C:\Users\ordbas11>sqlplus dbo/ababab@orcl

SQL*Plus: Release 11.2.0.2.0 Production on Sun Dec 4 15:07:01 2011

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

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:


This is what I get with dbo.

What do you mean And with JDBC?

[update: added the [code] tags. jw.]

[Updated on: Sun, 04 December 2011 15:42] by Moderator

Report message to a moderator

Re: Oracle Installation (2 Merged) [message #534227 is a reply to message #534226] Sun, 04 December 2011 14:35 Go to previous messageGo to next message
Michel Cadot
Messages: 67363
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
What do you mean And with JDBC?


YOU talked about JDBC:

Quote:
Error cannot connect with JDBC.Oracl.Thin
Error cannot connect with JDBC.Oracle.Thin@P7WZAC9.1521.orcl(user=dbo,password=ababab)


Quote:
ORA-01017: invalid username/password; logon denied


So As I said, unless you created the account it does not exist.

Regards
Michel

[Updated on: Sun, 04 December 2011 14:36]

Report message to a moderator

Re: Oracle Installation (2 Merged) [message #534229 is a reply to message #534182] Sun, 04 December 2011 15:36 Go to previous messageGo to next message
ordbas11
Messages: 4
Registered: December 2011
Junior Member
How do I create the account?
Re: Oracle Installation (2 Merged) [message #534230 is a reply to message #534229] Sun, 04 December 2011 15:43 Go to previous messageGo to next message
BlackSwan
Messages: 26733
Registered: January 2009
Location: SoCal
Senior Member
>How do I create the account?

CREATE USER DBO IDENTIFIED BY ABABAB;
GRANT CREATE SESSION TO DBO;
Re: Oracle Installation (2 Merged) [message #534231 is a reply to message #534230] Sun, 04 December 2011 15:46 Go to previous message
John Watson
Messages: 8344
Registered: January 2010
Location: Global Village
Senior Member
Remember that passwords are (by default) case sensitive in release 11g.

I would have thought that your package software would have instructions for creating the schema. Is there nothing in its documentation? Particularly about the privileges it needs?
Previous Topic: Database configuration
Next Topic: Citrix
Goto Forum:
  


Current Time: Sun Sep 20 23:01:21 CDT 2020