Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle dbase install on win 95

Status
Not open for further replies.

dps

Programmer
Feb 2, 2001
157
GB
Hello,

Has anyone come across this - I have seen some related info but is conflicting.

I have win 95 and Oracle 8.0.4. I installed sqlplus 8.0 with Net8 and networking tools using the 3.3.1.2.4 installer.

-set up an instance called dev1 tried to connect via scott/tiger system/manager but comes back with TNS protocol adapter error and no listner.

-Configured a new listner and this instance to this listener - still no joy. My lsnrctl start or status reveals the tns error.

-My tnsnames in net80 admin shows this new instance. I have also tried hostname as 127.0.0.1 and name of my machine without joy

Howver; when I install PO8.0.4 (same CD) then I can connect to sqlus using scott/tiger. Can somebody please explain this? I did not want to install PO 8.0.4 - just sqlplus.

can anyone please assist?
 
Can you ping the name of the machine you've setup in the tnsnames.ora?
What output do you get from tnsping?
Have you installed TCPIP and NMP?
Try connecting via named pipes rather than useing TCPIP.
Try setting ORACLE_SID or LOCAL and running sqlplus from a DOS prompt,what happens?
Have yon now got a net80 and a network directory possibly under two different oracle homes, and are the files identical?
What is in your sqlnet.ora file?
Have you run the net8 assistant?
 
Thanks for the response.

"Have you run the net8 assistant"? Yes and the test gave the same TNS error.

"What is in your sqlnet.ora file"? Can't remem. exactly - but not much; will re-check

"Have yon now got a net80 and a network directory possibly under two different oracle homes, and are the files identical"? No they are all in ORAWIN95 - no two homes (yet)

"What output do you get from tnsping"? I think output was ok i.e. it pinged ok; can't remember - will re-check this

"Have you installed TCPIP and NMP"? How do I confirm these have been installed??
Will do the following : -

--> ping the name of the machine you've setup in the tnsnames.ora
--> Try connecting via named pipes rather than using TCPIP
--> Set ORACLE_SID or LOCAL and running sqlplus from a DOS prompt to see what happens

Thanks in advance



 
Results -

tnsping 127.0.0.1 -->> Tnsping utiltiy version 2.3.4.0.0 TNS : 03505: Failed to resolve name

tnsping <machine name (as in tnsnames) > same as above

FROM DOS start SQLPLUS -->> using scott/tiger -->> Connected to : Oracle 8 PO Edition - global_name = oracle.world

SQLNET contains - names.default_zone = world
names.default_domain = world
names.directory_path = (tnsnames,hostname)

what is the command to use the other sid; is it export ORACLE_SID = 'name of the sid'??

Thanks in advance
 
Can you show us you tnsname.ora & sqlnet.ora.
In orawin95 do you have two directories called net80 and network?
 
Thanks.

Here it is, as taken from Network folder

AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
names.directory_path = (TNSNAMES)
names.default_domain = world
name.default_zone = world

and ...

# C:\ORAWIN95\NET80\ADMIN\SQLNET.ORA Configuration File:C:\orawin95\net80\admin\sqlnet.ora
# Generated by Oracle Net8 Assistant

NAME.DEFAULT_ZONE = world

NAMES.DEFAULT_DOMAIN = world

#sqlnet.authentication_services = (NONE)

SQLNET.EXPIRE_TIME = 0

SQLNET.ENCRYPTION_SERVER = requested

SQLNET.ENCRYPTION_CLIENT = requested

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)

# C:\ORAWIN95\NET80\ADMIN\TNSNAMES.ORA Configuration File:C:\orawin95\net80\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant

CMEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = CM_SERVER)(PORT = 1610))
(ADDRESS = (PROTOCOL = TCP)(HOST = LSNR_SERVER)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
)
(SOURCE_ROUTE = YES)
)

TCPEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Production1)(PORT = 1521))
(CONNECT_DATA =
(SID = ORCL)
)
)

NMPEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = NMP)(Server = FinanceServer1)(Pipe = ORAPIPE))
(CONNECT_DATA =
(SID = ORCL)
)
)

EXTPROC_CONNECTION_DATA.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0))
(CONNECT_DATA =
(SID = extproc)
)
)

BEQ-LOCAL.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle80)(ARGV0 = oracle80ORCL)(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))'))
(CONNECT_DATA =
(SID = ORCL)
)
)

SPXEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = SPX)(Service = Server_lsnr))
(CONNECT_DATA =
(SID = ORCL)
)
)

mine.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SID = hsup1)
(GLOBAL_DBNAME = mine)
)
)

TCP-LOOPBACK.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SID = ORCL)
)
)

No tnsnames in Network flder

although there are two listener - one in Net80 and one in Network - is this the problem?

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top