WHAT DID I DO WRONG

[Deanna Tran]

hi shabu

I did try your suggestion but still I wasn't able to log in to the oracle database

su - oracle
$ORACLE_HOME/bin/lsnrctl start
this is what I get when i run that command
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 9.0.1.0.0 - Production
Start Date 12-MAR-2002 15:19:30
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /u01/product/9.0.1/network/admin/listener.ora
Listener Log File /u01/product/9.0.1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=princess.tucson.ibm.com)(PORT=1521))
)
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "sales" has 1 instance(s).
Instance "dia2", status UNKNOWN,

ps -ef | grep ora
give me this
oracle 8433 8350 0 15:18:16 pts/ta 0:00 -su
oracle 8458 1 0 15:19:30 ? 0:00 /u01/product/9.0.1/bin/tnslsnr L
ISTENER -inherit
oracle 8462 8433 0 15:20:19 pts/ta 0:00 grep ora
oracle 8461 8433 1 15:20:19 pts/ta 0:00 ps -ef

[SHABU KHAN]

Hi Deanna,

I am sorry I had a production issue here at work and couldn't get back to you...

Anyway, what happens when you execute

./dbstart

from the command line..

-Shabu

[SHABU KHAN]

Deanna,

There are some good threads in this forum about oracle 9i installation/procedures, here they are:

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xb8b5d5fab40ed6118ff40090279cd0f9,00.html

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x9ece94f22a31d6118fff0090279cd0f9,00.html

http://forums.itrc.hp.com/cm/QuestionAnswer/1,11866,0x6db8cf38d6bdd5118ff10090279cd0f9,00.html

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xa4bf4e49c5cdd5118ff40090279cd0f9,00.html

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x06cd4e49c5cdd5118ff40090279cd0f9,00.html

If you cannot find what you were looking for in the above threads try searching for "oracle 9i" in this forum.

Thanks,
Shabu

[Andreas D. Skjervold]

Hi

This is what you'll have to do:
as the Oracle software owner (os user oracle),
set the env variable ORACLE_SID=.
-sqlplus sys/passwd as sysdba
-SQL>startup

The database should now mount and open.

Check with ps -ef |grep ora that you have the ora_ background processes.

If this fails, you have done something wrong in setting up and creating your database.
Check:
-Did you create a database?
Check the alert.log in $ORACLE_BASE/admin/bdump for create info and error messages related to the startup.

-Have you linked init.ora to $ORACLE_HOME/dbs/init>SID>.ora ?
If not link or use the "startup pfile= " syntax while starting the database.

If you get your database up and running manually, its time to start looking at the /sbin/init.d/oracle script.
What this does is simply calling the dbora script in your oracle installation.
First try running dbstart and dbstop and get them running. Remember to update the /etc/oratab file with your database:
:/oracle/product/9.0.1:Y

If you got these running (ie stops and start the database) then start work on the /sbin/init.d/oracle script.


Andreas

[SHABU KHAN]

Deanna,

Can you assign points to folks who have responded to your posting please ?

-Shabu

[Deanna Tran]

I did create a database called
initdia2.ora in the $ORACLE_HOME/dbs directory.
HOw do i link this file as you suggested?

[Victor Geere]

I got the same message when I tried to connect in SQLPLUS.
The oracle .profile includes the following lines:

NLS_LANG=AMERICAN-AMERICA.WE8ISO8859P1; export NLS_LANG
NLS_LANGUAGE=$NLS_LANG; export NLS_LANGUAGE
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33

ORA-12705: invalid or unknown NLS parameter value specified

Has anybody found a solution to this yet?