| Configuring listener manually [message #304307] |
Tue, 04 March 2008 17:34  |
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
|
Senior Member |
|
|
Hi,
I read a lot of write ups on making a listener.ora file. I wanted to know, if I am able to make the file manually then do I need to use net8 configuration assistance for anything.
Also, here is what I understand
If my computer name is Server1 and the database name, sid_name = DBASE and I am working on a stand alone computer then this listener.ora file will listen to any requests coming from below mentioned tnsnames.ora file and I don't need to use any administrative tool to configure this.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(PROTOCOL_STACK =
(PRESENTATION = TTC)
(SESSION = NS)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
(PROTOCOL_STACK =
(PRESENTATION = TTC)
(SESSION = NS)
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = DBASE)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
)
DBASE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DBASE)
)
)
Your assistance is highly appreciated
- Das
|
|
|
|
|
|
| Re: Configuring listener manually [message #304345 is a reply to message #304314] |
Tue, 04 March 2008 23:42  |
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
|
Senior Member |
|
|
Thanks..I am new to BEQ protocol but from what I read in the forum, my sqlnet.ora file should look something like this.
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)
(PROGRAM=oracle)(ARGV0=oracleDBASE)
(ARGS=’(DESCRIPTION= (LOCAL=YES)
(ADDRESS=(PROTOCOL=beq)))’))(CONNECT_DATA=(SID=DBASE)
(CID=(PROGRAM=c:\oracle\ora92\bin\oradim.exe)
(HOST=server1)(USER=SYSTEM)
)))
and that Oracle would not check tnsnames.ora file while connecting.
Please let me know if this is not true
- Das
|
|
|
|
|
|
| Re: Configuring listener manually [message #304355 is a reply to message #304350] |
Wed, 05 March 2008 00:13 |
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
|
Senior Member |
|
|
Ok..Maybe I need to elaborate on what I already mentioned..here is the problem.
I am assigned the job of starting an old Oracle 8i database (which was used a couple of years ago). While trying to login to the database I found out that someone had installed a 10g in the same computer and replaced the tnsnames.ora file with that of 10g. Now when the sqlplus prompt shows 8.1.5 version when I log on to it
cmd>set oracle_sid=oracle
cmd>sqlplus
but when I try to give the sysdba login "/as sysdba" it logs on to 10g database. I tried editing the files, changed the sid_name as service name of oracle 8i but it gave me this error
| Quote: | Cannot resolve service name
|
I created another service (DBASE) and tried to login as sysdba but in vain.
Now as you have mentioned I do not need the files (tnsnames, sqlnet and listener) to log on the the database, can you tell me what exactly do I need to do?
- Das
|
|
|
|
| Re: Configuring listener manually [message #304374 is a reply to message #304307] |
Wed, 05 March 2008 00:35 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>can you tell me what exactly do I need to do?
The short answer is NO.
I work on *nix; not Windoze.
I believe you can change your environment to act "locally"; but I can not tell you how.
HTH & YVVM!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
