Solved

Cannot access Oracle database on Windows

Posted on 2013-11-20
8
649 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
  • 4
  • 4
8 Comments
 
LVL 76

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 76

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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
LVL 76

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 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Creating and Managing Databases with phpMyAdmin in cPanel.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

808 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