Conference taec::temip

The problem described in the last 713.0 is solved - I could create the
STANDARD package.

But now the following problem arises:

When running sqlplus I get the following error messages:

ERROR: ORA-01034: ORACLE not available
ORA-07429: smsgsg: shmget() failed to get segment.
DEC OSF/1 (AXP) Error: 2: No such file or directory

I looked also in the ORACLE notes conference and found that there are
already problems like that, but I could not find any solution.

Do you have any ideas what happens?
Any help appreciated.

Christiane

    try checking the protection on the oracle executable... It should be
    set as follows:
    
    -rwsr-s--x   1 oracle   dba   12497600 Jun  6  1995  /oracle/bin/oracle
    
    
    
                                                         

Hello,

I still have problems with sqlplus. I read in the oracle notes
conference to run the sql script $ORACLE_HOME/rdbms/admin/catproc.sql.

I did so - this is also called when creating the temip_ah / temip_tt
database with the -c option - and I get the following error messages:

OER-1653: unable to extend table/cluster SYS.IDL_UB1$ by 41 in
tablespace SYSTEM
OER-1653: unable ... SYS.SOURCE$ by 140 ...
OER-1653: ...........SYS.OBJ by 18 ...

What is the exact command to solve this problem? It must be something
like "alter tablespace ... add datafile ... size ... "

What is the name of the datafile and of the tablespace?
What size is needed?

Thanx for any help
Christiane

	Hello Christiane,

	If you want you can use the -c option that will allow you t
generate ORACLE dictionary views (optional).

	* Now and assuming that all your configuration is OK, you can do

unser user temip :

sqlplus /@temip_tt

	Surely, you will obtain the errors you have still encountered.
You can get rid of these errors. They do not impact TeMIP use of ORACLE.
However, if you want them to disappear, then you can run the scripts 
/usr/kits/oracle/sqlplus/admin/pupbld.sql and
/usr/kits/oracle/rdbms/admin/catproc.sql under the system user. In this
case, modify the script temip_create_ora before creating your database
(Change the 5M in "datafile '$ORACLE_HOME/dbs/sys$1.dbf' size 5M" by
15M).

	Run the previous scripts to make the error messages dispappear 

$ORACLE_HOME/bin/sqlplus system/Manager@temip_tt
SQL> @$ORACLE_HOME/sqlplus/admin/pupbld.sql
SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql

PS : You need to configure SQL*NET even if you do not need to access
your ORACLE server from a remote station. This is the way ORACLE runs.
The listener process
waits for all calls even those coming locally.

PS : The involved tablespace is the system one which is build by default
and is represented by $ORACLE_HOME/dbs/systemip_tt.dbf datafile. It
should have been'possible to add a new data file to this tablespace
using the alter command. I think it is better for the time being to
restart from the beginning.

	Hope it helps.

	Best regards.

	D. Bozzi

Hello,

I tried the steps you told me in the right order and I get now the
following error messages:

ERROR:
ORA-06553: PLS-213: package STANDARD not accessible

Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06553: PLS-213: package STANDARD not accessible

Error accessing package DBMS_APPLICATION_INOF
You may need to install the Oracle Procedural option
SET APPINFO requires Oracle Server Release 7.2, or later




What does this mean? I installed ORACLE Server 7.3.2.
Aren't the packages STANDARD and DBMS_APPLICATION_INFO created when I
run the catproc.sql script?

What is wrong with that?


Christiane 

Hello,

I played a little bit more around the temip databases and did the 
following:

as user temip:  /usr/kits/TNM310/examples/temip_create_ora temip_tt

$sqlplus system/Manager@temip_tt
SQL> @$ORACLE_HOME/sqlplus/admin/pupbld.sql
SQL> exit


$sqlplus sys/change_on_install@temip_tt
SQL> @ORACLE_HOME/rdbms/admin/catproc.sql
SQL> exit


After that I can access the database with the command 
sqlplus /@temip_tt

without any errors.

Hope this solves the problem.
Christiane