• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

Installing Oracle9i

 
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have downloaded it from website and just want
to install it.Just all I want is to start SQLPLUS.I have my computer name is anuji(Windows ME,I could connect to internet and DNS is disabled).An error is coming as
TNS rotocol Adapter Error
trace file information is;

--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is C:\ORACLE\BIN\cli.trc
New trace level is 6
--- TRACE CONFIGURATION INFORMATION ENDS ---
--- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source C:\ORACLE\network\admin\sqlnet.ora
Parameter source loaded successfully
Attempted load of local pfile source C:\ORACLE\BIN\sqlnet.ora
Parameter source was not loaded
-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
TRACE_LEVEL_SERVER = ADMIN
TRACE_LEVEL_CLIENT = ADMIN
NAMES.DIRECTORY_PATH = (TNSNAMES, HOSTNAME)
--- PARAMETER SOURCE INFORMATION ENDS ---
--- LOG CONFIGURATION INFORMATION FOLLOWS ---
Log stream will be "C:\ORACLE\BIN\sqlnet.log"
Log stream validation not requested
--- LOG CONFIGURATION INFORMATION ENDS ---
nigini: entry
nigini: Count in NI global area now: 1
nigini: Count in NI global area now: 1
nrigbi: entry
nrigbni: entry
nrigbni: Unable to get data from navigation file tnsnav.ora
nrigbni: exit
nrigbi: exit
nigini: exit
niqname: Hst is already an NVstring.
niqname: Inserting CID.
niotns: entry
niotns: niotns: setting up interrupt handler...
niotns: Not trying to enable dead connection detection.
niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\ORACLE\BIN\SQLPLUSW.EXE)(HOST=ANUJI)(USER=OraUser))))
nsmal: 156 bytes at 0x8161d0
nscall: connecting...
nladini: entry
nladini: exit
nladget: entry
nladget: exit
nlpcaini: entry
nlpcaini: prg = oracle
nlpcaini: arg[0] = oracleORCL
nlpcaini: arg[1] = (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
nlpcaini: exit
nsmal: 476 bytes at 0x8171e0
nsmal: 2312 bytes at 0x784300
nsopen: opening transport...
ntpcon: entry
ntpcon: toc = 1
sntpcall: entry
sntpsp: entry
sntpsp: Failed to load , err = 1157
ntpcon: exit
nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=102, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nsopen: unable to open transport
nsmfr: 2312 bytes at 0x784300
nsmfr: 476 bytes at 0x8171e0
nladget: entry
nladget: exit
nsmfr: 156 bytes at 0x8161d0
nladtrm: entry
nladtrm: exit
nioqper: error from nscall
nioqper: nr err code: 0
nioqper: ns main err code: 12560
nioqper: ns (2) err code: 0
nioqper: nt main err code: 102
nioqper: nt (2) err code: 0
nioqper: nt OS err code: 0
niomapnserror: entry
niqme: entry
niqme: reporting NS-12560 error as ORA-12560
niqme: exit
niomapnserror: returning error 12560
niomapnserror: exit
niotns: Couldn't connect, returning 12560
niotns: exit
nigtrm: Count in the NI global area is now 0
nnfgdei: entry
nrigbd: entry
nrigbd: exit
nigtrm: Count in the NL global area is now 0
----------------------------------------------
Please help me,I donot know about TNS name,Host
name,Service name,Net Service name.So I could not
configure net configuration assistant properly.
But for just a stand alone system of mine why
should I bother it?
(This Windows Millenium Edition comes in which
category?Windows95,Windows98,Windows NT,16 BIT,
32 BIT?)
[ June 17, 2002: Message edited by: ANUJI PHILIP ]
 
Anuji Philip
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
please help
 
Ranch Hand
Posts: 254
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Would like to see the tnsnames.ora , listener.ora file and sqlnet.ora files? Have you checked the configuration yet?
Beksy
[ June 19, 2002: Message edited by: Beksy Kurian ]
 
Anuji Philip
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Please see these files;
# TNSNAMES.ORA Network Configuration File: C:\ORACLE\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = anuji)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = LISTENER)
)
)
--------------------------------------------------# LISTENER.ORA Network Configuration File: C:\ORACLE\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = anuji)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\ORACLE)
(PROGRAM = extproc)
)
)
--------------------------------------------------
# SQLNET.ORA Network Configuration File: C:\ORACLE\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (HOSTNAME, TNSNAMES)
 
Beksy Kurian
Ranch Hand
Posts: 254
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You haven't specified an SID in the tnsnames.ora file. What is the oracle_sid name you gave when you installed oracle. If you have selected typical installation, it would have configured it automatically. Are you sure installation is done properly? Also, try to give ip address instead of name for the Host field.
It should be some thing like this:
ANUJIDB.COM=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ANUJIDB)
)
)
Beksy
[ June 20, 2002: Message edited by: Beksy Kurian ]
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic