-
$ more sqlnet.ora
# Generated by Oracle Net8 Assistant
NAMES.PREFERRED_SERVERS =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = megvserv)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = megvserv)(PORT = 1521))
)
NAMESCTL.TRACE_FILE = NCTL
$ more names.ora
names.server_name=megvserv
names.addresses= (ADDRESS =(PROTOCOL =TCP)(HOST=megvserv)(PORT=1575))
names.use_plug_and_play = TRUE
NAMES.ADMIN_REGION =
(REGION =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =megvserv )(PORT = 1575))
(CONNECT_DATA = (SID = rman)(Server = Dedicated))
)
(USERID = names)
(PASSWORD = names)
(NAME = LOCAL_REGION)
(REFRESH = 86400)
(RETRY = 60)
(EXPIRE = 600)
(VERSION = 134230016)
)
$ more listener.ora
# LISTENER.ORA Configuration File:/opt/app/oracle/product/8.1.6/netw
stener.ora
# Generated by Oracle Net8 Assistant
USE_PLUG_AND_PLAY_LISTENER = TRUE
CONNECT_TIMEOUT_LISTENER=0
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = megvserv)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = megvserv)(PORT = 2481))
)
)
$ namesctl
Oracle Names Control for Solaris: Version 8.1.6.0.0 - Production on 22-AUG-2001
09:36:21
(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
NNL-00018: warning: could not contact default name server
Welcome to NAMESCTL, type "help" for information.
NAMESCTL> start
Starting "/opt/app/oracle/product/8.1.6/bin/names"...
$ namesctl set server megvserv
Oracle Names Control for Solaris: Version 8.1.6.0.0 - Production on 22-AUG-2001
10:12:39
(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
NNL-00018: warning: could not contact default name server
NNC-00003: error opening stream (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=
megvserv))(ADDRESS=(PROTOCOL=TCP)(HOST=megvserv)(PORT=1521)))
I am not able to proceed further .is there any configuration problems in any of sqlnet.ora /names.ora /etc ...
Can anyone tell me where exactly i am going wrong ...
Radhakrishnan.M
-
I think the port # for a name server is 1527 or something. Try changing the port#. If that doesn't work then try. Were you getting any tns errors. If so what are they? Why would you want to have an SID with name "rman", which is a v.bad practice as there is an oracle utility called rman too.
Sam
Thanx
Sam
Life is a journey, not a destination!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|