Error no listerner avaliable

• • Reply

  15 years ago

  by asi2k6

  asif

  london, United Kingdom

  Joined 15 years ago

  
  i have recently install oracle 8i on windows 2000 Prof..
  but i am unable to enter in to oracle DB
  i have tried scott/tiger so many times but fail.
  and also tell me the adminstrator account info (user name/password)

  Report abuse
• • Reply

  15 years ago

  by Wanna learn

  Wanna learn

  , United States

  Joined 15 years ago

  try to use
  

  
  username : system
  password: manager
  

  
  if it does not work you have to reinstall the oracle
  

  
  

  
  

  
  

  
  because oracle 8i need special requerments to run
  

  
  do  not ask me  about them
  

  
  but i prefere using oracle 7 it just wanna windows 98 and it never cause any error

  Report abuse
• • Reply

  15 years ago

  by asi2k6

  asif

  london, United Kingdom

  Joined 15 years ago
  
  but the  problem is exsist when i install oracle developer 2000/6i  before oracle 8i
  
  
  I am listing  two errors which are  arising.
  
  1) ORA-12560 TNS protocol adapter error
  2) TNS 12514-  TNS Service Name cannot be resolved
  
  My lintener.ora ,tnsnames.ora and names.ora has following configurations
  
  
  
  # LISTENER.ORA Network Configuration File:
  g:\orant\network\admin\listener.ora
  # Generated by Oracle configuration tools.
  
  Q =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = home-97d89ed175)(PORT = 1521))
    )
  LISTENER =
    (DESCRIPTION_LIST =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = home-97d89ed175)(PORT =
  1521))
        )
      )
    )
  SID_LIST_Q =
    (SID_LIST =
      (SID_DESC =
        (GLOBAL_DBNAME = Oracle8)
        (ORACLE_HOME = G:\ORANT)
        (SID_NAME = ORCL)
      )
    )
  
  
  ***************************************************************
  
  
  
  # NAMES.ORA Network Configuration File:
  g:\orant\NETWORK\ADMIN\names.ora
  # Generated by Oracle configuration tools.
  
  NAMES.SERVER_NAME = ss
  NAMES.ADDRESSES =
    (ADDRESS = (PROTOCOL = TCP)(HOST = home-97d89ed175)(PORT = 1521))
  
  NAMES.ADMIN_REGION =
    (REGION =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = host-97d89ed175)(PORT =
  1521))
        (CONNECT_DATA =
          (SID = ORCL)
          (Server = Dedicated)
        )
      )
      (USERID = scott)
      (PASSWORD = tiger)
      (NAME = LOCAL_REGION)
      (REFRESH = 86400)
      (RETRY = 60)
      (EXPIRE = 600)
      (VERSION = 134230016)
    )
  
  
  
  
  ****************************************************
  
  
  
  # TNSNAMES.ORA Network Configuration File:
  g:\orant\NETWORK\ADMIN\tnsnames.ora
  # Generated by Oracle configuration tools.
  
  
  Q=
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = home-97d89ed175)(PORT =
  1521))
      )
      (CONNECT_DATA =
        (SID = ORCL)
      )
    )
  
  
  
  i have not use
  
  username : system
  password: manager
  
  up till now
  
  what can i do plz help me  and also send me  configuration setting to
  me.
  
  All suggestions are welcome
  
  Thanks
  
  
  
  
  
  
  
  
  Report abuse
• • Reply

  15 years ago

  by Wanna learn

  Wanna learn

  , United States

  Joined 15 years ago
  the same problem faced my while i try to use oracle sql 8i with developer 6i
  
  i dont know how to face this problem
  
  but on windows 98 just install oracle sql 7 with developer 6i and it will work with out any problem
  
  i am sorry i have not any idea to solve such problem
  
  with best wishes
  Report abuse
• • Reply

  15 years ago

  by asi2k6

  asif

  london, United Kingdom

  Joined 15 years ago

  
  ok i will install oracle7 and developer 2000/6i on win 2000 Prof.. will it work or not.
  and try to connect them.
  

  
  Thnx Wanna learn for given me a time ..
  

  Report abuse
• • Reply

  15 years ago

  by Wanna learn

  Wanna learn

  , United States

  Joined 15 years ago

  you ara welcome .:^asi2k6^:.
  

  
  with best wishes

  Report abuse