1

i am very new to oracle need to practice in this,so i decided to install oracle 11g in my private machine using this link oacle homei tried to install this package it installed but,i can't access any more it ask username and password i did't give anything like tat while installing,it didn't ask like anything while installing too.

SQL*Plus: Release 11.2.0.1.0 Production on Sun Jan 27 13:24:15 2013

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

Enter user-name: sysdba
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:
Thiyagu ATR
  • 2,224
  • 7
  • 30
  • 44

3 Answers3

1

Try sqlplus / as sysdba. You don't need a password then.

Then do you have ORACLE_HOME variable defined? If you do, is it pointing to the correct folder where the database software for the running database is stored? What happens if you remove the variable ORACLE_HOME?

Do you have the environment variable ORACLE_SID set to the name of the database?

mdo
  • 6,961
  • 3
  • 24
  • 26
  • SQL*Plus: Release 11.2.0.1.0 Production on Sun Jan 27 13:43:28 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: / as sysdba ERROR: ORA-12560: TNS:protocol adapter error THIS IS WAT I GOT Enter user-name: – Thiyagu ATR Jan 27 '13 at 08:15
  • see friends!this is my own machine..i don'e ve server and all... simply I've downloaded using above mentioned link and try to work with this....i've ora_client_home_4 folder in my home and H:\app\admin these folders! – Thiyagu ATR Jan 27 '13 at 17:50
  • and also when i run this file Services.exe program... there is no oracle products in this!!!list – Thiyagu ATR Jan 27 '13 at 17:51
1

Log in to the database using the user name SYSTEM and connect as SYSDBA. Oracle Enterprise Manager displays the Database Home page.

Use the password that you specified for the SYSTEM account during the installation.

Note: You can also log in to the Database Control using the SYS, SYSTEM, or SYSMAN accounts, or you can grant login privileges to other database users. If you log in as SYS, then you must connect as SYSDBA.

Use the following statement to start SQL*Plus and log in as the SYS user, connecting as SYSDBA:

$ $ORACLE_HOME/bin/sqlplus 
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password

For example, to log on as SYSTEM enter:

$ $ORACLE_HOME/bin/sqlplus 
SQL> CONNECT SYSTEM
Enter password: password

If you are logging on as SYS, you must connect as SYSDBA:

$ $ORACLE_HOME/bin/sqlplus 
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password

References:

bonCodigo
  • 14,268
  • 1
  • 48
  • 91
  • @Thiyagu please do refer to the references I have provided as well as the logins stated in the answer. In the worst case, you may `alter` the password: Enter `sqlplus / as sysdba` in a Command Prompt. Then enter `alter user SYS identified by "newpassword";` – bonCodigo Jan 27 '13 at 08:18
  • `+1`, You are mixed talented! :) – CodeLover Jan 27 '13 at 09:58
  • when i tried to ener like this / as sysdba i got:ERROR: ORA-12560: TNS:protocol adapter error – Thiyagu ATR Jan 27 '13 at 17:55
0

Check the following links first. Follow them on the server machine where you run oracle instance, you will get your oracle instance started.

ORA-12560: TNS:protocol adaptor error

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::p11_question_id:431775600346873836

If there still exists any TNS related error, maybe you need to check the tnsnames.ora and listener.ora files under $ORACLE_HOME/network/admin.

When you connect to oracle, the client(e.g. sqlplus) will try to find the oracle instance run on the server machine. It will report a TNS related error when it cannot find the server.

To solve the problem, you need to config the tnsname.ora file under your installation directory(by default it's $ORACLE_HOME/network /admin) first.

The basic format of the tnsnames.ora file is:

net_service_name=
 (description=
 (address=(protocol_address_information))
 (connect_data=
 (service_name=service_name)))

A sample tnsnames.ora entry might look like the following:

ORA_INSTANCE=
  (description=
    (address_list=
      (address = (protocol = TCP)(host = yourmachine)(port = 1521))
    )
    (connect_data =
      (service_name=ora_sid)
    )
  )

After this configuration, you can try:

sqlplus /@ORA_INSTANCE as sysdba;

Then the oracle client you installed will find the ORA_INSTANCE based on your configuration in the tnsnames.ora file. If the oracle server is listening, your connection will be established. BTW, you may need to look at the listener.ora on server machine if there is any error remaining.

I attached the following parameters that are commonly used in tnsnames.ora:

description: This tnsnames.ora parameter acts as a container for a connect descriptor. It can be embedded under the description_list parameter in the tnsnames.ora file.

description_list: This tnsnames.ora parameter defines a list of connect descriptors for a particular net service name .

address: This tnsnames.ora parameter defines a single listener protocol address. It can be embedded under the address_list or description parameters in the tnsnames.ora file.

address_list: This tnsnames.ora parameter defines multiple listener protocol addresses. It is not necessary if only one listener protocol address is used. It can be embedded under the description or description_list parameters in the tnsnames.ora file.

Community
  • 1
  • 1
StarPinkER
  • 14,081
  • 7
  • 55
  • 81
  • friend!is it possible to run oracle 11g with out server!? – Thiyagu ATR Jan 27 '13 at 11:59
  • The server I mean is actually the very machine that you run your oracle instance on while the client is simply a sqlplus where you write your queries. Of course you can install both server and client on the same machine. – StarPinkER Jan 27 '13 at 13:39
  • I checked the link you provided, Oracle Database 11g Release 2 Client is what I mean the client, Oracle Database 11g Release 2 (11.2.0.1.0) for Microsoft Windows is the server. – StarPinkER Jan 27 '13 at 14:01
  • so what i suppose to do!further – Thiyagu ATR Jan 28 '13 at 09:34
  • I've edited the answer already, have you tried the approaches in those two links? – StarPinkER Jan 28 '13 at 10:27
  • ya i'v run secvice.msc file but i didn't get oracle sevice in that list! – Thiyagu ATR Jan 28 '13 at 17:46
  • Ok, that means you only installed the client, you don't even have an oracle(server) installed on your computer. Install Oracle Database 11g Release 2 (11.2.0.1.0) first. You can install it on your local computer or on a network machine. You can't use client without any server. – StarPinkER Jan 29 '13 at 00:39
  • ya sure,how do i get server package!is it available in net? – Thiyagu ATR Jan 29 '13 at 04:41
  • Yeah， the link you provide contains the full oracle package. http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html. The first one, not the second one. – StarPinkER Jan 29 '13 at 04:49
  • so i have to download both these packages? win32_11gR2_database_1of2.zip (1,625,721,289 bytes) win32_11gR2_database_2of2.zip (631,934,821 bytes) – Thiyagu ATR Jan 29 '13 at 05:24