Database configuration

[bal]

Just created an Oracle Database on windows XP, Oracle 817 and I am having problems connecting to this through SQLplus, TNSPING. Receiving error message TNS:could not resolve service name. All configuration looks ok.

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

DSDXP01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DSD_LAPTOP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DSDXP01)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DSD_LAPTOP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = DSDXP01)
(PRESENTATION = http://admin)
)
)




EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


********************************************
# SQLNET.ORA Network Configuration File: d:\Ora817\NETWORK\ADMIN\sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.INITIAL_RETRY_TIMEOUT = 2

NAME.DEFAULT_ZONE = world

NAMES.DEFAULT_DOMAIN = world

SQLNET.AUTHENTICATION_SERVICES= (NTS)

SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf

***********************************************

# LISTENER.ORA Network Configuration File: d:\Ora817\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENERORA8 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DSD_LAPTOP)(PORT = 1521))
)

SID_LIST_LISTENERORA8 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\Ora817)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = DSDXP01)
(ORACLE_HOME = d:\Ora817)
(SID_NAME = DSDXP01)
)
)

*************************
Services running

Oracleservice for dsdxp01
Listener

[stecal]

The fully qualified name is DSDXP01.WORLD.

If you are using NAMES.DEFAULT_DOMAIN, the value should match the domain name of your local environment. For example, suppose you use a domain name of company.com. A fully qualified net service name for a database named kfm would be kfm.company.com.

If you are connecting remotely (and you can do this on the server by going thru the network), the connect descriptor is username/password@kfm. What Oracle Net8 does is take "kfm" and add the value for NAMES.DEFAULT_DOMAIN to it (i.e., kfm.company.com) and then looks for an entry of kfm.company.com in your tnsnames.ora file. If Net8 does not see kfm.company.com in the file, you get an
error.

[vinit]

In short just # out the entry 'NAMES.DEFAULT_DOMAIN' in sqlnet.ora
or add .world with the service name in tnsnames.ora

[DaPi]

stecal,

Thanks for that - It answers the question, but I think it is only half the story?

Please, do you know of a ref to a CLEAR COMPLETE explanation of how the names in Net8 (or equivalent) work. The Net8 book seems intent on hiding all the horrid details! On top of that, there is complete confusion (at least in my mind, and those of my colleagues) beween db_name, SID name, global_name, service names, connection strings - all compounded with the ability to specfiy domain names in the init.ora and sqlnet.ora (can't the domain name be picked up from the internet value in the local environment as well?)!

Quite happy to RTFM, if I can find the right one!

Lewis Carrol had something about: the poem, the name of the poem, what the poem was called, what the name of the poem was called, etc etc.

[bal]

I commented out the entry 'NAMES.DEFAULT_DOMAIN' in sqlnet.ora and can now tnsping the database but when I try to connect to the database I receive the message

ORA-01034: Oracle not available
ORA-27101: shared memory realm does not exist

My operating system is windows xp oracle 817

[vinit]

Start/Open the Database. I assume the service is running.
At command prompt type the foll.

svrmgrl
connect internal;
startup ;

[stecal]

O'Reilly's "Oracle Net8 Configuration and Troubleshooting"

http://www.bookpool.com/.x/mzsi5geiq...qs=oracle+net8

$22.95

http://download-west.oracle.com/docs...a96580/toc.htm

free

[bal]

when starting database from svrmgrl i receive the following message:-


LRM-00116: syntax error at 'location' following 'd:\ora817\oradat'
LRM-00113: error when processing file 'd:\ora817\admin\DSDXP01\pfile\initDSDXP01.ora'
ORA-01078:failure in processing system parameters.

[stecal]

Your init.ora file has an error. What did you specify with the "location=" line (or lines)?

[DaPi]

Thanks stecal