Oracle Installation (2 Merged) [message #534182] |
Sat, 03 December 2011 20:36 |
|
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 (2 Merged) [message #534196 is a reply to message #534182] |
Sun, 04 December 2011 04:36 |
John Watson
Messages: 8960 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 #534226 is a reply to message #534182] |
Sun, 04 December 2011 14:11 |
|
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 #534231 is a reply to message #534230] |
Sun, 04 December 2011 15:46 |
John Watson
Messages: 8960 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?
|
|
|