Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Cannot access Oracle database on Windows

Posted on 2013-11-20
8
Medium Priority
?
749 Views
Last Modified: 2013-11-20
I have Oracle database installed on my Windows (Windows 7) PC.
I have attached the screenshot of the location where the Oracle is installed.

Now I try to connect as sysdba:
C:\app\ding\product\11.2.0\threetwobitclient>sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 20 09:30:38 2013

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

SQL> connect sys as sysdba
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error

SQL>

Is there any way I could troubleshoot the above error so that I could connect to the database as sysdba. I do not remember any other login of the database. Or could you help me install the database in case it is not installed?

I mostly use this Oracle installation as an Oracle client for sqlplus. Thanks a lot.
oracle home
0
Comment
Question by:toooki
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39662863
From the path provided, threetwobitclient, it looks like you only have the client installed.

Are you wanting a local database or are you trying to connect to a remote database 'as sysdba'?
0
 

Author Comment

by:toooki
ID: 39663350
Thanks slightwv. I am actually trying to import a .dmp file (Oracle schema dump file) to this oracle database (local one). So I am trying to connect to the local database as sysdba so that I could run the Oracle import command.

On the PC I can connect to remote database. Is there any link that you could please let me know to download the Oracle 11g database.
I tried with http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html and I cannot even download it gives error.
Thanks a lot.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39663363
That is the place to download it.  What is the error you received when trying to download it?
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39663370
May not be the right place after all.  If you start off at oracle.com and follow the path I end up here:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html?ssSourceSiteId=ocomen
0
 

Author Comment

by:toooki
ID: 39663965
Thank you. I think I have Oracle database installed. As I see files under the folder C:\app\ding\oradata\orcl\ (attached screen).

Now anyway I downloaded the Oracle software from the above link. The files are win64_11gR2_database_1of2.zip and win64_11gR2_database_2of2.zip .
Those I extracted into two different folders:
C:\Users\ding\Downloads\OraDb\win64_11gR2_database_1of2\
C:\Users\ding\Downloads\OraDb\win64_11gR2_database_2of2\

Now I click on setup.exe under C:\Users\ding\Downloads\OraDb\win64_11gR2_database_1of2\database\ and eventually I get series of errors that says that it does not get the correct installation files.

Am I supposed to merge the above two folders? They have common sub-folders (database\stage).

Also at the beginning of the installation it showed I already have a db installed with sid name of orcl. So I chose new instance as orcl1 and new ORACLE_HOME location.

So anyway I cannot get to the existing database. Also the new installation is not working either.
Thank you.errordbOracle
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 39663987
If you already had Oracle Server software installed, why did you want another install?

Anyway: Each Oracle install should have it's own HOME unless you know it is an add-on and needs to be installed in an existing HOME.

The error in the image looks like you were trying to install the new version into the same HOME as the existing client.

Since you already have a database, check the service to see if it is started, if not, start it.  It should be labeled something like: OracleServiceORCL.  You also want the Listener service started.
0
 

Author Comment

by:toooki
ID: 39664870
Thank you. I ran the service OracleServiceORCL which was stopped before. Now I do not get the previous error.
SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.
SQL>
SQL> select * from user_tables;
select * from user_tables
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
SQL>

If I try to start the database, I get error:
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'
SQL>

Under ORACLE_HOME/network/admin/ the listener.or file is like this:
#listener.ora=================================================
# listener.ora Network Configuration File: C:\app\ding\product\11.2.0\dbhome_2\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\app\ding\product\11.2.0\dbhome_2)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\ding\product\11.2.0\dbhome_2\bin\oraclr11.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = C:\app\ding
#=================================================
And the tnsnames.ora is:
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ding.comcast-act.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
##-----

Thanks a lot
0
 

Author Comment

by:toooki
ID: 39664877
I got the issue resolved: (http://busintel.blogspot.com/2009/02/starting-11g-database-gives-ora-00119.html)
Added this
LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
In tnsnames.ora file and it worked.

Thank you.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question