try to get snap shot --- error out

[Deanna Tran_1]

I have installed the statpack on my system. However, when i tried to run a snap shot, I got the following errors?
the database has been running for 1 day
$ sqlplus perfstat/perfstat
SQL> execute statspack.snap
BEGIN statspack.snap; END;

*
ERROR at line 1:
ORA-03114: not connected to ORACLE

[Jeff Schussele]

Hi Deanna,

I don't see the DB name on the sqlplus command line - just the username/PW.

Rgds,
Jeff

[Deanna Tran_1]

according to the spdoc.txt
that is all i need to do? perhaps, there is something i didn't know? Can you show me how to do so?

[Jeff Schussele]

Hi (again) Deanna,

Well, first off I've never used statpack.
But a normal sqlplus command needs 3 args
username/PW ORACLE_SID (aka DB name)
with that syntax.

Rgds,
Jeff

[Deanna Tran_1]

hi, I tried you suggestion but was unsucssful
SQL> connect perfstat/perfstat daisy
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where ::= [/][@] | /

[Jeff Schussele]

Hi Deanna,

Sorry I'm an idiot.
Syntax should be
username/PW@ORACLE_SID

You need that @.

Sorry,
Jeff

[Deanna Tran_1]

i have problem when starting the listner...
SQL> connect perfstat/perfstat @daisy
ERROR:
ORA-12541: TNS:no listener

i then try to understand why ?
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
HPUX Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=princess.tucson.ibm.com)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
HPUX Error: 239: Connection refused
Starting /u01/product/9.0.1/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 9.0.1.0.0 - Production
System parameter file is /u01/product/9.0.1/network/admin/listener.ora
Log messages written to /u01/product/9.0.1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=princess.tucson.ibm.com)(PORT=1521)))
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
NL-00305: the specified path name does not exist

Listener failed to start. See the error message(s) above...

[Deanna Tran_1]

after fixing the lsnterner.ora and tns.ora
i was able to start up the listener again..however...i still can't execute
SQL> connect perfstat/perfstat @daisy
Connected.
SQL> execute statspack.snap
BEGIN statspack.snap; END;

*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

[Printaporn_1]

HI,
just make sure that you correctly connect to the database.

before

SQL> execute statspack.snap

do

SQL> select name from v$database

does it success ?

[Deanna Tran_1]

Answer to your question :

SQL> connect perfstat/perfstat @daisy;
Connected.
SQL> select name from v$database;

NAME
---------
DAISY

SQL> execute statspack.snap
BEGIN statspack.snap; END;

*
ERROR at line 1:
ORA-03113: end-of-file on communication channel