Questions tagged [solaris]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
43 views

How to change permissions of Oracle generated logs?

The oracle generated logs (ie. alert and listener logs) are being created with 600 permissions. These files are of course created automatically by the oracle user. How would I change the permissions ...
0
votes
1answer
114 views

Informix - dbaccess vs dbexport to export tables to text files

Currently, we are using the dbaccess utility to export all tables in the Informix database to text files. These are used to "mirror" the database multiple Windows machines running MSSQL Server on a ...
0
votes
1answer
202 views

Migrating Oracle 10g on Solaris Sparc to Linux RHEL 5 VM

if i will rate my oracle expertise i would give it 3/10. i just started learning oracle, solaris and linux 2months ago and was given this task to migrate. yes our oracle version is quite old and might ...
0
votes
1answer
43 views

Update MySQL with Solaris 11 IPS Package

I'm barely new with Solaris OS and there are still a couple of things I definitely don't get it. I want to replicate a MySQL installation that someone did in the past in a development server we have. ...
2
votes
1answer
265 views

I am trying to restore an Oracle DB, but I am getting strange controlfile errors. What do I do next?

Oracle version = Oracle 8i (817_312) //Yes I know this is old. Database id = LED OS = Solaris 8 Oracle USERID = oraled Oracle DBA group = dba rman backups to disk. Sorry this is so long. I am ...
0
votes
1answer
494 views

Where can I download oracle 10g software for solaris?

I need 10g RAC software (Solaris 11 SPARC) for an audit. It's no longer on OTN. I've opened an SR, but it is taking forever then they gave me the wrong O/S. Do you know of any other place to get it?
0
votes
1answer
555 views

SGA size vs SWAP space in Oracle RAC

I’ve searched and read wide about the good practices of configuring swap space for Oracle Database installation. I am aware that for 1-2GB RAM, swap has to be 1.5x. For between 2GB and 8GB, swap needs ...
2
votes
1answer
5k views

ORA-48108 & ORA-01034

I'm trying to set up a database on a Solaris 10 platform that had its database corrupted before. Due to the lack of backups, I was forced to reinstall Oracle server. Currently I'm facing an issue ...
1
vote
1answer
300 views

Logging procedure, package errors to OS's Syslog

Good day, Setup: Oracle 11G on Solaris 10 x86 We'd like to capture the errors/failures of our nightly scheduled procedures/ packages in the OS's syslog. That log will then be sent to a remote NMS ...
0
votes
1answer
3k views

Where is oraenv located in solaris?

I had a problem recently with oraenv and oratab and finding out where oraenv is located was a bit challenging. Since it's a question I ask myself often, I wanted to have it here. It may help others.
0
votes
1answer
11k views

What is the path of oratab on solaris?

What is the path of oratab on solaris? This is actually a question I google a lot and switching from environment to another, I tend to mix them up and forget. Today I googled it again and I wanted ...
1
vote
0answers
411 views

SQLPlus TNS:protocol adapter error

i have two Oracle 12c instances. currently both are shutdown. when I try to connect with sqlplus / as sysdba it says tns protocol adapter error contents of tnsnames.ora are DB12102 = (DESCRIPTION = (...
2
votes
1answer
37 views

Is Oracle 10g smart enough to work on a WHERE clause identically as the equivalent INNER JOIN?

Way back when Michael Jackson was still alive, I made this question: https://stackoverflow.com/questions/1018822/inner-join-on-vs-where-clause And now I'm performance-auditing a system in which the ...
1
vote
1answer
142 views

Why does MySQLTuner only see 4Gb of RAM?

I ran MySQLTuner to verify the configuration of a MySQL database, and it reported this problem: [!!] Maximum possible memory usage: 40.9G (1022% of installed RAM) These figures come from computing ...
2
votes
0answers
45 views

what is causing the reads in this configuration?

i have a setup here where we use a Solaris 10 x86, zpool for oracle12c-redo-log using mirrored disks and mirrored ZIL. logbias="latency", recordsize=128: pool: xxxxxx01_redo00 state: ONLINE scan: ...
0
votes
2answers
148 views

sql script hangs in SQLplus on Solaris [closed]

Running an sql script in SQLplus on Solaris Any idea why script hangs in line 9 '/' and not executed? declare dummy number; begin select 1 into dummy from dual ; end; /
0
votes
1answer
5k views

How to know which process is causing high memory usage on DB?

I've got one Onesight alert mail stating below: Short Description: Onesight Alert: ZEUS DB Monitor (zeus04) Description: Solaris 5.8: vmstat memory(free) - Free Memory for zeus04 2065112 8:06:02 ...
3
votes
2answers
707 views

How can I load 'utf8' into plperl by default?

I am attempting to solve a problem explained in another question here. On Debian 7.4 with Postgres 9.1.12, I am able to use the Perl qr operator just fine. On Solaris 5.11 with Postgres 9.2.4, ...
0
votes
2answers
498 views

How to put Oracle Redo Log file at the outer edge of disk for performance?

I always read that the outer edge of disk is the fastest place. Somebody said "You better put your Oracle Redo Log file at the outer edge of disk". My question is: How to put Redo Log file at ...
2
votes
1answer
2k views

ORA-01658 on index tablespace when trying to insert into empty table of new database

We are getting ORA-01658 (Error :ORA-01658: unable to create INITIAL extent for segment in tablespace MYDATA_LDATA_INDEX) in our application logs. This happens when application is trying to insert ...
-1
votes
1answer
977 views

Slowness after migration to RAC 11gr2

we are getting slowness after migrate from ORacle 10gr2 single db to Oracle 11204 oracle rac (standard ed) with asm, on oracle solaris 11. at this momento we have only one node. In the next days we ...
0
votes
0answers
2k views

Database creation fails with ORA-12560

I installed Oracle 11g R2 PS4 on SunOS 5.10 sparc machine. When i try to create a new database using the Database Creation Assistant tool (dbca) i get the popup message ORA-12560: TNS:protocol ...
0
votes
0answers
293 views

Cannot find /etc/init.d file in opensolaris

While installing MySQL , I noticed a point, I mean to start the MySQL server manually , use the command cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql The error shown is : cp: ...