Printable View
Hello
I am a beginner in oracle ...i installed oracle 8i on win xp(128 mb RAM).I connected to Oracle for the first time using username:scott and password:tiger .but now when i try to connect to oracle using same password/username, it displays mme the following error:-
ORA-12560: TNS protocol adapter error
Please tell me as to what to do??? I will be really thankful to you...Please help me!!!
Nitin
you need to start the service (or create a database if you havent done so already)
If you're a beginner and living in 2005, Try starting with atleast version 9i. There's already a version 10G Release 2 BTW.
For connections as Davey said
do
--tnsping database name
hi if u are facing that problem then just create a database or start the oracle database service... the problem is related to your database.....
and most probably u have not created the database...
so create it...
Hello
Thanks everybody for ur reply!!! I connected to oracle 8i through the following steps:(from command prompt)-
sqlplus>connect sys/change_on_install as sysdba
it displayed:-
idle instance started
then i wrote:-
startup
and through this , instance got started and i was able to work in sql*plus editor...........but i want to ask whether i have to do this every time i want to connect to Oracle??? Is not there a way out by which instance gets automatically started...do i need to make any change in registry???
actually when i tried to connect to Oracle(via 'scott/tiger' combination) after turning my PC on....it displayed me the following error:-
ORA-01034:ORACLE not available
that's when i tried to connect to Oracle thru command prompt via "sys/change_on_install" combination in sysdba mode(as described above in this post) and it was successful attempt.
so please tell me how will this instance get started automatically???
thanx once again
Nitin
just set the service to start automatically from control panel -> services
first go to services option from controlpanel-->administrative tools
then right click on the database service what u r concern...
then change the value of startup from manual to automatic ....
and now enjoy .....
I did wat u said...but when i restarted my PC and tried to cnnect to Oracle(via scott/tiger combination), it again displayed me:-
ORA-01034:ORACLE not available
and moreover in the services section in control panel...i changed from manual to automatic but then its status is always "starting" and not "started"....even when i have connected to oracle through:
sqlplus>connect sys/password as sysdba
startup
so my problem is not solved....
nitin
What is the content of sqlnet.ora file?
As Tarry said, 8i is soooo 1990's.
you'll be better served learning 10g .
But in 10g you can still have ORA errors. What should you do then? Maybe install MS SQL server? (no ORA errors ther)
Hello
i do not have sqlnet.ora filed created ...i.e. in the folder(i.e admin folder) where tnsnames.ora , listener.ora and names.ora is present, there is no sqlnet.ora file over there...only its sample is present in the "sample" folder..so how can i create sqlnet.ora file????
nitin
Create new text document and name it sqlnet.ora
Put in following lines
NAMES.DEFAULT_DOMAIN = WORLD
NAMES.DIRECTORY_PATH= (ONAMES,TNSNAMES,HOSTNAME)
SQLNET.AUTHENTICATION_SERVICES= (NONE)
Then restart.
dont need an sqlnet.ora at all, just make sur eyour tnsnames.ora file is ok
Hello
I am working in Pro*C ...and when i try to make 'exe' of the program (in Visual C++)it displays me the following error:-
Performing Custom Build Step on .\student2_26sep.pc
Pro*C/C++: Release 8.1.5.0.0 - Production on Mon Sep 26 19:34:15 2005
(c) Copyright 1999 Oracle Corporation. All rights reserved.
System default option values taken from: e:\Oracle\Ora8i\precomp\admin\pcscfg.cfg
PCC-F-02041, CMD-LINE: Option does not exist: .\student2_26sep.pcinclude
Error executing c:\windows\system32\cmd.exe.
(student2_26sep.pc is the name of the file which contains original code written by me)
what should i do to remove this error???? i am working in WIN 32 console application in Visual C++ and in project settings,under 'custom build' option,i have included following in the 'commands' portion:-
$(ProjDir)\..\..\..\..\bin\proc$(ProjDir)\$(InputName).pcinclude=$(ProjDir)\..\..includeinclude="$(MSDEVDIR)\..\vc\include"
and in 'output' section , i have included:-
$(ProjDir)\$(InputName).c
and i want to precompile *.pc into *.C , for which i try to make 'exe'...at this stage it displays me the above mentioned 'PCC-f-02041' error.
please tell me as to wat to do????thanx for concern of all of u till now.
Nitin