OraFAQ Forum: Server Administration » problem in login to sql

Home » RDBMS Server » Server Administration » problem in login to sql

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problem in login to sql [message #125053]

Thu, 23 June 2005 00:26

mdamjad
Messages: 45
Registered: May 2005

Member

I have installed developer 2000 form 6i in c:\orant
and
Oracle 8.0.6.00 in c:\orant\ora8i . My problem is I am unable to connect to form6 and oracle 8

The following are the files

tnsname.ora
------------

# C:\ORANT\ORA8I\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:C:\orant\ora8i\network\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant

EXTPROC_CONNECTION_DATA.GULBARGA.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

new.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ex1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora8i.us.oracle.com)
)
)
************************************************

listner.ora
------------

# C:\ORANT\ORA8I\NETWORK\ADMIN\LISTENER.ORA Configuration File:C:\orant\ora8i\network\admin\listener.ora
# Generated by Oracle Net8 Assistant

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ex1)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = ex1)(PORT = 1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\orant\ora8i)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ora8i.us.oracle.com)
(ORACLE_HOME = C:\orant\ora8i)
(SID_NAME = ora8i)
)
)

Report message to a moderator

Re: problem in login to sql [message #125071 is a reply to message #125053]

Thu, 23 June 2005 02:36

munishmsh
Messages: 15
Registered: May 2005
Location: Bangalore

Junior Member

1.> Check whether the Listener is up and running.
2.> If its running, check for the env variable of ORACLE_HOME
3.> At the command prompt, set the Oracle_sid and try to login.

Hope that it will work.

Rgds,
Munish

Report message to a moderator

Re: problem in login to Oracle [message #125214 is a reply to message #125053]

Thu, 23 June 2005 17:10

sureddi
Messages: 10
Registered: June 2005
Location: Houston

Junior Member

Hi,

I have a problem with oracle 8.i.

I installed oracle 8i(8.1.7) on windows server.Its worked fine.when i restart my system it was not working what was the reason.Before restarting IMP and EXP are not working at command prompt.So I restarted Now that are recognizing.But now oracle Problem.How to make oracle Running when my sytem starts.I check in the task manager Listner.ora is not running how to make it run when system starts and what are the files should run to make oracle run properly.

my listner file is below

# LISTENER.ORA Network Configuration File: D:\oracle\ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.

STRACIT =
(DESCRIPTION_LIST =
(DESCRIPTION =

(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dev1)(PORT = 1521))
)
)

)

SID_LIST_STRACIT =
(SID_LIST =

(SID_DESC =
(GLOBAL_DBNAME = STRACIT)
(ORACLE_HOME = D:\oracle\ora81)
(SID_NAME = STRACIT)
)
)

My TNSNames.ora file is below

EXTPROC_CONNECTION_DATA.PICS-TDH.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

INST1_HTTP.PICS-TDH.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dev1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = STRACIT)
(PRESENTATION = http://admin)
)
)

STRACIT.PICS-TDH.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dev1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = STRACIT)
)
)

Bye
Sri

Report message to a moderator

Previous Topic:	user privs
Next Topic:	database migration and intermedia

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 00:14:57 CDT 2024