var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Creating Database manually
I am trying to create an oracle v8.1.5 database manually. Using the net8 assistant i have created the entry for the SID to be used and i am able to tnsping to the SID name. However, when i connect using svrmgrl it gives the following error
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
here's copy of the tnsnames.ora
(ADDRESS = (PROTOCOL = TCP)(PORT = 1527)(HOST = abc))
(SERVICE_NAME = ID)
The sqlnet.ora file is as follows
SQLNET.EXPIRE_TIME = 0
Any ideas on wht i am missing
First, connect to the instance using this setting, type show parameter service_name Or
Select * from v$parameter where name = 'service_name'
and compare the result with the service_name string in tnsnames.ora According to the error message, they aren't equal.
A Newkid in the block
You did do the following?
I assume the database is not yet there?
* open dos-box (assuming you are on windows. Yes, a lot of assumes, but then again, you do not post what you are using.. )
create database ID ....etc.