Solved

Cannot access Oracle database on Windows

Posted on 2013-11-20
8
614 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
 
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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 

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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Read about achieving the basic levels of HRIS security in the workplace.
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

758 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now