?
Solved

Cannot access Oracle database on Windows

Posted on 2013-11-20
8
Medium Priority
?
722 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

770 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