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)
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)