Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 772
  • Last Modified:

Cannot access Oracle database on Windows

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
toooki
Asked:
toooki
  • 4
  • 4
1 Solution
 
slightwv (䄆 Netminder) Commented:
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
 
toookiAuthor Commented:
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
 
slightwv (䄆 Netminder) Commented:
That is the place to download it.  What is the error you received when trying to download it?
0
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
slightwv (䄆 Netminder) Commented:
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
 
toookiAuthor Commented:
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
 
slightwv (䄆 Netminder) Commented:
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
 
toookiAuthor Commented:
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
 
toookiAuthor Commented:
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 Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now