Re: Oracle Administration

From: Novice <zacNOzaSPAM_at_agorics.com.invalid>
Date: Thu, 20 Jan 2000 15:15:41 -0800
Message-ID: <1ca4f2e8.4e9345f2@usw-ex0109-066.remarq.com>

I have attached below the messages that is displayed when I start the oracle server from /etc/init.d/dbora startup script for oracle. Do I need to have any special startups for sqlplus?

Starting the Listener...

Oracle Server Manager Release 3.0.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation. All Rights
Reserved.

Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production

SVRMGR> Connected.
SVRMGR> ORACLE instance started.

Total System Global Area                          4873744
bytes
Fixed Size                                          48656
bytes
Variable Size                                     4333568
bytes
Database Buffers                                   409600
bytes
Redo Buffers                                        81920

bytes
Starting /opt/oracle/product/8.0.5/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 8.0.5.0.0 - Production System parameter file is
/opt/oracle/product/8.0.5/network/admin/listener.ora Log messages written to
/opt/oracle/product/8.0.5/network/log/listener.log

Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=8)(KEY=sar))
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=12)(KEY=PNPKEY))
Listening on:

(ADDRESS=(PROTOCOL=tcp)(DEV=14)(HOST=207.135.96.37)(PORT=1521))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=sar)) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version
8.0.5.0.0 - Production
Start Date                20-JAN-00 14:16:37
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF

Listener Parameter File
/opt/oracle/product/8.0.5/network/admin/listener.ora Listener Log File
/opt/oracle/product/8.0.5/network/log/listener.log Services Summary...

  extproc               has 1 service handler(s)
  sar           has 1 service handler(s)
  sar1          has 1 service handler(s)
  sar3          has 1 service handler(s)
  sar4          has 1 service handler(s)

The command completed successfullyDatabase "sar3" warm started.

Oracle Server Manager Release 3.0.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation. All Rights
Reserved.

Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production

SVRMGR> Connected.
SVRMGR> ORACLE instance started.

Total System Global Area                          4873744
bytes
Fixed Size                                          48656
bytes
Variable Size                                     4333568
bytes
Database Buffers                                   409600
bytes
Redo Buffers                                        81920

bytes
Database mounted.
Database opened.
SVRMGR>
Server Manager complete.

Database "sar4" warm started.

Oracle Server Manager Release 3.0.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation. All Rights
Reserved.

ORA-12162: TNS:service name is incorrectly specified SVRMGR> Password:
Password:
ORA-12162: TNS:service name is incorrectly specified SVRMGR> LCC-00161: Message 161 not found; product=SVRMGR; facility=MGR

ORA-12162: TNS:service name is incorrectly specified SVRMGR>
Server Manager complete.

Database "" warm started.

Oracle Server Manager Release 3.0.5.0.0 - Production

Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production

SVRMGR> Connected.
SVRMGR> ORACLE instance started.

Total System Global Area                          4873744
bytes
Fixed Size                                          48656
bytes
Variable Size                                     4333568
bytes
Database Buffers                                   409600
bytes
Redo Buffers                                        81920

bytes
Database mounted.
Database opened.
SVRMGR>
Server Manager complete.

Database "sar1" warm started.

root_at_hayek # Database mounted.
Database opened.
SVRMGR>
Server Manager complete.

I appreciate your help. Thankyou in advance

Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

Received on Thu Jan 20 2000 - 17:15:41 CST