topic Re: database in Operating System - HP-UX

database

Cathy Arora — Tue, 28 Oct 2003 10:39:26 GMT

I am new to oracle. Oracle admin told me that my id is the same as unix id to get into oracle.
once I get sqlplus promt i try to put the id i get an error
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory
My reasoning from dba is (as little as i know) that if I am getting sqlplus prompt then my profile is setup right (sid , oracle home etc)
but id is not created right.
DBA seems to disagree and non coperative. Please explain is my reasoning right and if it is how can I create my oracle id myself. I can go sytem manager and do it.
I would the little procedure and step by step explaing as how to login to oracle from unix box.

Thanks

Re: database

Tomek Gryszkiewicz — Tue, 28 Oct 2003 10:45:10 GMT

Looks like the database is not working. If you have a user with DBA rights (owner of the oracle files and processes), and the oracle is 8i, try to run:
svrmgrl
connect internal
startup

-Tomek

Re: database

Steven E. Protter — Tue, 28 Oct 2003 10:47:20 GMT

Just because svrmgr is going away I'd do it like this:

sqlplus internal
startup

ORACLE_HOME and ORACLE_SID must be set for the user starting the database.

SEP

Re: database

Graham Cameron_1 — Tue, 28 Oct 2003 10:56:04 GMT

Cathy

Deja vu ?

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=240280

Anyway I guess you're still not sorted.

As before your problem is nothing to do with your id or password, you are not actually getting that far, your environment is pointing you at a database which is not up.

Can you post the output of these commands:

env|grep -i ora
ps -ef|grep pmon

Then maybe we can see your problem or at least work towards it.

-- Graham

Re: database

Cathy Arora — Tue, 28 Oct 2003 11:09:19 GMT

Thanks all.
Grahm; here is the output of both commands
hpcb18/home/kchinsky$env|grep ora
PATH=/u01/app/oracle/product/8.1.7/bin:/usr/ccs/bin:/usr/local/bin:/usr/bin:/usr
/ccs/bin:/usr/contrib/bin:/opt/nettladm/bin:/opt/fc/bin:/opt/fcms/bin:/opt/upgra
de/bin:/opt/pd/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/perf/bin:/opt/OV/bin/O
pC://opt/perl/bin:/opt/resmon/bin:/usr/sbin/diag/contrib:/opt/pred/bin:/opt/hpar
ray/bin:/opt/ignite/bin:/opt/sanmgr/commandview/client/sbin:/usr/sbin:usr/bin:/e
tc:/usr/ccs/bin:usr/bin/X11:/usr/contrib/bin:/usr/local/bin:/opt/perf/bin:/home/
kchinsky/bin:/usr/share:/usr/share/man/man4.Z:/u01/app/oracle/product/8.1.7/rdbm
s/admin:.
ORACLE_BASE=/u01/app/oracle
CLASSPATH=/u01/app/oracle/product/8.1.7/jdbc/lib/classes111.zip
LD_LIBRARY_PATH=/u01/app/oracle/product/8.1.7/jdbc/lib:
ORACLE_HOME=/u01/app/oracle/product/8.1.7
PWD=/u01/app/oracle/product/8.1.7

hpcb18/home/kchinsky$ps -ef |grep pmon
kchinsky 9366 8458 0 10:59:34 pts/te 0:00 grep pmon
oracle 11146 1 0 Oct 20 ? 0:48 ora_pmon_TRNCNMMS

Re: database

Cathy Arora — Tue, 28 Oct 2003 11:11:39 GMT

Thanks all.
Grahm; here is the output of both commands
hpcb18/home/kchinsky$env|grep ora
PATH=/u01/app/oracle/product/8.1.7/bin:/usr/ccs/bin:/usr/local/bin:/usr/bin:/usr
/ccs/bin:/usr/contrib/bin:/opt/nettladm/bin:/opt/fc/bin:/opt/fcms/bin:/opt/upgra
de/bin:/opt/pd/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/perf/bin:/opt/OV/bin/O
pC://opt/perl/bin:/opt/resmon/bin:/usr/sbin/diag/contrib:/opt/pred/bin:/opt/hpar
ray/bin:/opt/ignite/bin:/opt/sanmgr/commandview/client/sbin:/usr/sbin:usr/bin:/e
tc:/usr/ccs/bin:usr/bin/X11:/usr/contrib/bin:/usr/local/bin:/opt/perf/bin:/home/

FYI..I am in DBA group under unix id. but I donot know how to check if I can use same unix id/password in sqlplus or it is created differently by dba.
Thanks
kchinsky/bin:/usr/share:/usr/share/man/man4.Z:/u01/app/oracle/product/8.1.7/rdbm
s/admin:.
ORACLE_BASE=/u01/app/oracle
CLASSPATH=/u01/app/oracle/product/8.1.7/jdbc/lib/classes111.zip
LD_LIBRARY_PATH=/u01/app/oracle/product/8.1.7/jdbc/lib:
ORACLE_HOME=/u01/app/oracle/product/8.1.7
PWD=/u01/app/oracle/product/8.1.7

hpcb18/home/kchinsky$ps -ef |grep pmon
kchinsky 9366 8458 0 10:59:34 pts/te 0:00 grep pmon
oracle 11146 1 0 Oct 20 ? 0:48 ora_pmon_TRNCNMMS

Re: database

Graham Cameron_1 — Tue, 28 Oct 2003 11:16:23 GMT

Cathy

Looks like your SID is unset.

Try this.

Export ORACLE_SID=TRNCNMMS
sqlplus etc..

Good luck

-- Graham

Re: database

Cathy Arora — Tue, 28 Oct 2003 11:28:12 GMT

thanks Grahm,
I used unix login id /password info and got an error with userid/password now. asleast I am getting closer.
How could I check that my login / password information is same as unix login (since i am in dba group) or is there a way I can create an seperate oracle user id.
Also I would like to know since I am in dba group shold there be a need of seperate oracle user?
please help with oracle login concept.
Thanks all.

Re: database

Graham Cameron_1 — Tue, 28 Oct 2003 11:43:32 GMT

If you are in dba group you should be able to connect as sysdba, as follows:

sqlplus /nolog
connect / as sysdba

Provided that lets you in, you can interrogate the Oracle dictionary to find out what users are defined:

select username
from dba_users
order by username
/

If you are not listed, create your user as

create user YOURNAME identified by YOURPASS
/
grant connect, resource to YOURNAME
/

If you are listed but your password doesn't work, use

alter user YOURNAME identified by YOURPASS
/

Then disconnect and retry connecting as yourself.

As to user id policy, that's up to your dba, but if he doesn't co-operate, then do what you must!

-- Graham

Re: database

Cathy Arora — Tue, 28 Oct 2003 12:14:39 GMT

Thanks Grahm.
I am in sqlplus and can query tables etc and your help and clear instructions were appreciated.
now just to understand- there must be two ways to access database one with unix id and another with oracle id. but it may depend it the architecture is. is that right?

last thing is that i need to understand TRNCNMMS schema. is data dictionary will be a good place to start to get a feel for it.

Thanks,

Re: database

Jan Shu — Tue, 28 Oct 2003 14:46:23 GMT

Hi Cathy,
Greetings, see if you can get the CSI - Oracle customer support id number from your DBAs, and then go to http://metalink.oracle.com/, register yourself an account. You will find everything you need to know about Oracle database, easy and fast.

Regards,
Jan

Re: database

Graham Cameron_1 — Wed, 29 Oct 2003 04:43:32 GMT

Cathy

To answer your last point - yes there are 2 ways of authentication. Using an oracle id and password as you are now is one method, operating system authentication is the other.

In the former you supply user name and password to sqlplus, in the latter, you just use "sqlplus /". Oracle picks up your user id from unix, and provided you have an externally identified account it will log you in.

When I say an externally identified account, this is one created using the syntax "create user USERNAME identified externally" (as opposed to "identified by password").

There is one more complication - there is a prefix called "os_authent_prefix" - this will have been set by your dba, but you can see it, by connecting as sysdba and saying "show parameter os_authent_prefix".

Usually these days it is null, but in the old days, it was "OPS$". If not-null, then the oracle account name ahs to be prefixed with this.

eg
if os_authent_prefix = "OPS$", and your unix id is "fred", then you would need to be set up as "create user ops$fred identified externally".

Hope that helps.
As said by a previous post, there is tons of documentation on this on the oracle site.

-- Graham