Board index Solaris

Oracle on Sun Solaris 8

Oracle on Sun Solaris 8

Post by Seabas » Tue, 23 Oct 2001 07:14:59



Hi there

Abit of a newbie to this.  Got a Sun Solaris Box today and tried to set up
an Oracle server and database with that java configuration assistant for
Oracle.  Well got the following continual errors:

ORA-01012 : Not logged on
ORA-01031 : Insufficient privileges
ORA-27101 : Shared memory realm does not exist

Well I have since read that I should have set up raw devices in the solaris
/dev directory (remember im new to this), because installing Oracle 8.1.7
installation assistant requires them.  All I knew was that I had this Oracle
Enterprise Manager 8.1.7 disk and I wanted to install it. :)  Abit naive yeh
:)  Ok, I just need to know how to set up raw devices/partitions in that
/dev directory on solaris 8.  Cant find any information anywhere concerning
the specific commands to do it. Again a newbie :)   Anyone help plz?
Cheers & thanks in advance
Paul

 
 
 
Top

Oracle on Sun Solaris 8

Post by Tom Dyes » Tue, 23 Oct 2001 09:33:28


Here is a link to installing Oracle 8 on Solaris 7 - Sparc - Should work the
same for Sol8.

http://www.oraclepower.com/isapi/orapower.dll?AID=SP&PG=/idocs/Ora8Sp...
tall.htm

Tom


Quote:> Hi there

> Abit of a newbie to this.  Got a Sun Solaris Box today and tried to set up
> an Oracle server and database with that java configuration assistant for
> Oracle.  Well got the following continual errors:

> ORA-01012 : Not logged on
> ORA-01031 : Insufficient privileges
> ORA-27101 : Shared memory realm does not exist

> Well I have since read that I should have set up raw devices in the
solaris
> /dev directory (remember im new to this), because installing Oracle 8.1.7
> installation assistant requires them.  All I knew was that I had this
Oracle
> Enterprise Manager 8.1.7 disk and I wanted to install it. :)  Abit naive
yeh
> :)  Ok, I just need to know how to set up raw devices/partitions in that
> /dev directory on solaris 8.  Cant find any information anywhere
concerning
> the specific commands to do it. Again a newbie :)   Anyone help plz?
> Cheers & thanks in advance
> Paul


 
 
 
Top

Oracle on Sun Solaris 8

Post by Seabas » Tue, 23 Oct 2001 09:55:43


cheers m8
Ill try that.
Thanks
Paul

Quote:> Here is a link to installing Oracle 8 on Solaris 7 - Sparc - Should work
the
> same for Sol8.

http://www.oraclepower.com/isapi/orapower.dll?AID=SP&PG=/idocs/Ora8Sp...
> tall.htm

> Tom



> > Hi there

> > Abit of a newbie to this.  Got a Sun Solaris Box today and tried to set
up
> > an Oracle server and database with that java configuration assistant for
> > Oracle.  Well got the following continual errors:

> > ORA-01012 : Not logged on
> > ORA-01031 : Insufficient privileges
> > ORA-27101 : Shared memory realm does not exist

> > Well I have since read that I should have set up raw devices in the
> solaris
> > /dev directory (remember im new to this), because installing Oracle
8.1.7
> > installation assistant requires them.  All I knew was that I had this
> Oracle
> > Enterprise Manager 8.1.7 disk and I wanted to install it. :)  Abit naive
> yeh
> > :)  Ok, I just need to know how to set up raw devices/partitions in that
> > /dev directory on solaris 8.  Cant find any information anywhere
> concerning
> > the specific commands to do it. Again a newbie :)   Anyone help plz?
> > Cheers & thanks in advance
> > Paul

 
 
 
Top

Oracle on Sun Solaris 8

Post by Scott Lawso » Tue, 23 Oct 2001 20:52:00


Here is another good link.

http://www.dbspecialists.com/4dbas/presos/oracle817solaris.html


> Hi there

> Abit of a newbie to this.  Got a Sun Solaris Box today and tried to set up
> an Oracle server and database with that java configuration assistant for
> Oracle.  Well got the following continual errors:

> ORA-01012 : Not logged on
> ORA-01031 : Insufficient privileges
> ORA-27101 : Shared memory realm does not exist

> Well I have since read that I should have set up raw devices in the solaris
> /dev directory (remember im new to this), because installing Oracle 8.1.7
> installation assistant requires them.  All I knew was that I had this Oracle
> Enterprise Manager 8.1.7 disk and I wanted to install it. :)  Abit naive yeh
> :)  Ok, I just need to know how to set up raw devices/partitions in that
> /dev directory on solaris 8.  Cant find any information anywhere concerning
> the specific commands to do it. Again a newbie :)   Anyone help plz?
> Cheers & thanks in advance
> Paul

--

__________________________________________________________________

Scott Lawson
Systems Manager
Department Of Information Services
St. George's Hospital Medical School
Tooting
London SW17 0RE
UK

P: 44 (0)208 725 2896
F: 44 (0)208 725 3583


http://www.sghms.ac.uk

__________________________________________________________________

Your mouse has moved.
Windows must be restarted for the change to take effect.
Reboot now?  [OK]
__________________________________________________________________

 
 
 
Top

Oracle on Sun Solaris 8

Post by Seabas » Wed, 24 Oct 2001 03:59:18


Thanks I will used that as well :)
Paul


> Here is another good link.

> http://www.dbspecialists.com/4dbas/presos/oracle817solaris.html


> > Hi there

> > Abit of a newbie to this.  Got a Sun Solaris Box today and tried to set
up
> > an Oracle server and database with that java configuration assistant for
> > Oracle.  Well got the following continual errors:

> > ORA-01012 : Not logged on
> > ORA-01031 : Insufficient privileges
> > ORA-27101 : Shared memory realm does not exist

> > Well I have since read that I should have set up raw devices in the
solaris
> > /dev directory (remember im new to this), because installing Oracle
8.1.7
> > installation assistant requires them.  All I knew was that I had this
Oracle
> > Enterprise Manager 8.1.7 disk and I wanted to install it. :)  Abit naive
yeh
> > :)  Ok, I just need to know how to set up raw devices/partitions in that
> > /dev directory on solaris 8.  Cant find any information anywhere
concerning
> > the specific commands to do it. Again a newbie :)   Anyone help plz?
> > Cheers & thanks in advance
> > Paul

> --

> __________________________________________________________________

> Scott Lawson
> Systems Manager
> Department Of Information Services
> St. George's Hospital Medical School
> Tooting
> London SW17 0RE
> UK

> P: 44 (0)208 725 2896
> F: 44 (0)208 725 3583


> http://www.sghms.ac.uk

> __________________________________________________________________

> Your mouse has moved.
> Windows must be restarted for the change to take effect.
> Reboot now?  [OK]
> __________________________________________________________________

 
 
 
Top

Oracle on Sun Solaris 8

Post by Philip Bro » Thu, 25 Oct 2001 08:41:03



>Thanks I will used that as well :)

well, then how about THIs one too? :-)

http://www.bolthole.com/solaris/oracle.html

--
[Trim the no-bots from my address to reply to me by email!]
[ Do NOT email-CC me on posts. Pick one or the other.]

The word of the day is mispergitude

 
 
 
Top

Oracle on Sun Solaris 8

Post by D_Kro » Fri, 26 Oct 2001 03:38:09


the ORA-01031 error is the common error about the password file.
when you select CREATE DATABASE ...
the Oracle Installer create a file like createSID.sh that call
other shells scripts....
the first of this scripts try to run "svrmgrl" with the params
"connect internal" and (intentionally) without password, because
the password is in the another file.
This is the cause for the message "Not logged on"
and this cause the insufficient privileges for create the
datafiles for oracle.

You need to see, too, the OS privileges like 755 or 644 (minimal) on
datafile's creation dirs
and on the tnsnames.ora file.

You can search in http://metalink.oracle.com with the ORA-01031 error.

Too, check this:

0) sqlnet.ora PATH search order :
    $TNS_ADMIN/sqlnet.ora
    $HOME/sqlnet.ora
    $ORACLE_HOME/network/admin/sqlnet.ora
    or (depending of your OS type)
         /var/opt/oracle/sqlnet.ora
         /etc/sqlnet.ora

1)  sqlnet.ora , will have
      SQLNET.AUTHENTICATION_SERVICES = (BEQ,NONE)
      AUTOMATIC_IPC = OFF

( the BEQ,NONE is for search the password in another file,
  and if you set AUTOMATIC_IPC = ON then are forcing to setting
  on environment the variable TWO_TASK.

2) like ROOT :

    check the privileges on :
      sqlnet.ora
      tnsnames.ora
      listener.ora

    with this :
      cd $TNS_ADMIN
      chmod 644 sqlnet.ora tnsnames.ora listener.ora
      ls -l sqlnet.ora tnsnames.ora listener.ora

and thas all!
this will be go on...

____________________________________________________________
Jorge Acevedo Flores
Santiago de Chile
Oracle DBA


> Hi there

> Abit of a newbie to this.  Got a Sun Solaris Box today and tried to set up
> an Oracle server and database with that java configuration assistant for
> Oracle.  Well got the following continual errors:

> ORA-01012 : Not logged on
> ORA-01031 : Insufficient privileges
> ORA-27101 : Shared memory realm does not exist

> Well I have since read that I should have set up raw devices in the solaris
> /dev directory (remember im new to this), because installing Oracle 8.1.7
> installation assistant requires them.  All I knew was that I had this Oracle
> Enterprise Manager 8.1.7 disk and I wanted to install it. :)  Abit naive yeh
> :)  Ok, I just need to know how to set up raw devices/partitions in that
> /dev directory on solaris 8.  Cant find any information anywhere concerning
> the specific commands to do it. Again a newbie :)   Anyone help plz?
> Cheers & thanks in advance
> Paul

 
 
 
Top

1. Oracle on SUN --> Oracle on DEC Aplha + Digital Unix ?

Hi

We are currently running Oracle 7.2 on an ageing SUN Sparc2.

Because of a good hardware price, there is a proposal to
upgrade to a DEC Alpha, Digital Unix, rather than the
original SUN upgrade we intended.

Does anybody have any experience or views on this as a good
or bad idea ?

There is some concern that we may be moving to a less popular
UNIX, possibly less supported and with a doubtful future.
There are also some learning curve issues, and the need
to convert our SQL*Forms "legacy" apps to Developer 2k/Forms 4.5,
whereas under a SUN upgrade we can run them as they are
(connectintg via SQL*Net).

(We are not planning to use Developer 2K /Forms 4.5
as our future client, so this would be a one off learning
curve. We are into Delphi and Java/HTML)

Thanks for any advice / experience

Alan McCulloch

2. Solaris 2.3 - Disk partitioning recommendation

3. Oracle 10 (RAC) & Solaris 10 & Sun Cluster 3

4. Which kernel fro SCSI & IDE HD's?

5. ORACLE - SUN SOLARIS 9

6. How to configure and use a serial port in C under Linux ?

7. Sun's claims regarding Solaris 8 for Oracle DB performance?

8. any dual head tv-out video card ?

9. memory problem oracle 816 sun sparc solaris

10. Binding Oracle to two CPU's in a four CPU Sun Solaris 8 system........

11. Integrate Solaris ver. of Oracle and Netscape Enterprise Server on 2 Sun Machines

12. FA: Oracle 8i Release 8.1.7 for Sun SPARC Solaris

13. FA: Oracle 9i Release 9.0.1 for Sun SPARC Solaris


All times are UTC
Board index