- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: WHAT DID I DO WRONG
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-12-2002 02:20 PM
тАО03-12-2002 02:20 PM
Re: WHAT DID I DO WRONG
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-12-2002 05:58 PM
тАО03-12-2002 05:58 PM
Re: WHAT DID I DO WRONG
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-12-2002 08:52 PM
тАО03-12-2002 08:52 PM
Re: WHAT DID I DO WRONG
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-13-2002 01:10 AM
тАО03-13-2002 01:10 AM
Re: WHAT DID I DO WRONG
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
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:
If you got these running (ie stops and start the database) then start work on the /sbin/init.d/oracle script.
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-13-2002 10:23 AM
тАО03-13-2002 10:23 AM
Re: WHAT DID I DO WRONG
Deanna,
Can you assign points to folks who have responded to your posting please ?
-Shabu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-13-2002 03:45 PM
тАО03-13-2002 03:45 PM
Re: WHAT DID I DO WRONG
initdia2.ora in the $ORACLE_HOME/dbs directory.
HOw do i link this file as you suggested?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2002 04:49 AM
тАО05-15-2002 04:49 AM
Re: WHAT DID I DO WRONG
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?
- « Previous
-
- 1
- 2
- Next »