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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XP install problems..configured tnsnames, listener, sqlnet files

Status
Not open for further replies.

targis

Programmer
Nov 4, 2002
10
US
These are questions that i have and I'll copy the files below and write my questions above the file.

this is the error when logging into sql plus with scott/tiger and system/manager.

this is the tnsname.ora file. I had to write it from scratch because it wasn't generated and later the # Comments were added by Oracle at some point later when it was generated during some configuring.
I'm not sure if targis is my Host. During the process the listener file created it so I'm going with it as my host.
I'm including the service name as targis also. i think the service name is the global database name so i don't think its correct but noticed a similar pattern in a fourm.
How do you find out what the service name is???

Here is a link:



# TNSNAMES.ORA Network Configuration File: C:\OraHome1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

TARGIS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = targis)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = targis)
)
)

____________________________________________________
This is my listener.ora file. I added the global db_name part after seeing an example. I'm not sure it belongs there and once again am not sure about the targis part.
How do you find out what the GLOBAL_DBNAME should equal?.

# LISTENER.ORA Network Configuration File: C:\OraHome1\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = targis)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = targis)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\OraHome1)
(PROGRAM = extproc)
)
)
_________________________________________

This is the sqlnet.ora file. I added the names default part out of seeing it in another example and once again am not sure about the targis part. (NAMES.DEFAULT_DOMAIN = targis)
How do you know what the default domain is?.

# SQLNET.ORA Network Configuration File: C:\OraHome1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DEFAULT_DOMAIN = targis

NAMES.DIRECTORY_PATH= (LDAP, ONAMES, TNSNAMES, HOSTNAME)
 
targis> I'm not sure if targis is my Host.
If you have Windows OS simply lool at your host file to verify Your host

targis> How do you find out what the service name is???
Service Name I am quickly verify by looking on windows service name (sorry if You are Linux-man), it is
OracleServiceXXX,
where XXX is a service name.

targis>How do you know what the default domain is?.
IMHO Default domain not required for properly work.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top