Howdy
Well, If your SID=ARCH and running internally , then you should be fine for
Listener.
Which SID you want to use?
Is server really started?
Test like
>srvmgrl
>connect internal/password_at_servicename
>startup
Let me know how it goes.
"Thomas Fischer" <himself_at_tfischer.de> wrote in message
news:38c1547b.4260906_at_news.uni-kassel.de...
> Hi,
>
> I have installed Oracle805 on Linux as user 'oracle'.
> when I do
> >dbstart
> and then
> >lsnrctl start
> I get the following:
>
> -----8<-------------------------------------------------------------------
>
> LSNRCTL for Linux: Version 8.0.5.0.0 - Production on 04-MAR-00
> 13:53:35
>
> (c) Copyright 1997 Oracle Corporation. All rights reserved.
>
> Starting /home/oracle/product/8.0.5/bin/tnslsnr: please wait...
>
> TNSLSNR for Linux: Version 8.0.5.0.0 - Production
> System parameter file is
> /home/oracle/product/8.0.5/network/admin/listener.ora
> Log messages written to
> /home/oracle/product/8.0.5/network/log/listener.log
> Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=6)(KEY=ARCH))
> Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=PNPKEY))
> Listening on:
> (ADDRESS=(PROTOCOL=tcp)(DEV=11)(HOST=127.0.0.1)(PORT=1521))
>
> Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ARCH))
> TNS-12546: TNS:permission denied
> TNS-12560: TNS:protocol adapter error
> TNS-00516: Permission denied
> Linux Error: 13: Permission denied
> Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PNPKEY))
> TNS-12546: TNS:permission denied
> TNS-12560: TNS:protocol adapter error
> TNS-00516: Permission denied
> Linux Error: 13: Permission denied
> Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=libretto)(Port=1521))
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for Linux: Version 8.0.5.0.0 -
> Production
> Start Date 04-MAR-00 13:53:38
> Uptime 0 days 0 hr. 0 min. 0 sec
> Trace Level off
> Security OFF
> SNMP OFF
> Listener Parameter File
> /home/oracle/product/8.0.5/network/admin/listener.ora
> Listener Log File
> /home/oracle/product/8.0.5/network/log/listener.log
> Services Summary...
> ARCH has 1 service handler(s)
> extproc has 1 service handler(s)
> The command completed successfully
>
> -----8<-------------------------------------------------------------------
>
> shouldn't oracle be up now?
> when I now try to talk to it via sqlplus it tells me oracle
> is down:
>
> oracle_at_libretto:/home/oracle > sqlplus internal
>
> SQL*Plus: Release 8.0.5.0.0 - Production on Sat Mar 4 13:53:56 2000
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Connected.
> SQL> CREATE foo;
> CREATE foo
> *
> ERROR at line 1:
> ORA-01034: ORACLE not available
>
> WHY????? What can I do/check/repair?
>
> Thanks,
> Tom
> ...........................>>>>>>>
> candy m. herr = $candy_at_tfischer.de
> .........and remove the $.........
> .................................>
> visit the pink inferno candypolis>
> >www.tfischer.de/candy.........>>>
Received on Sun Mar 05 2000 - 00:27:59 CST