Questions tagged [solaris]
The solaris tag has no usage guidance.
21
questions
0
votes
0
answers
96
views
Can an Oracle Database request a system crash (One Instance Crash)?
I am Junior Database Administrator at a Bank and there was an issue that caused the Oracle Database Instance one to crash (We have two instances). So the system rebooted itself and everything is ...
- 1
1
vote
0
answers
264
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 ...
- 183
0
votes
1
answer
1k
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
1
answer
185
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. ...
- 667
2
votes
1
answer
938
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 ...
- 21
0
votes
1
answer
1k
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?
- 197
0
votes
1
answer
1k
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
1
answer
9k
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
1
answer
386
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 ...
- 125
0
votes
1
answer
4k
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.
- 1,873
1
vote
1
answer
16k
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,873
1
vote
0
answers
551
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 =
(...
- 11
2
votes
1
answer
41
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 ...
- 133
1
vote
1
answer
184
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 ...
- 1,304
2
votes
0
answers
51
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: ...
- 21
0
votes
2
answers
433
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;
/
- 1
0
votes
1
answer
6k
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 ...
- 361
3
votes
2
answers
899
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, ...
- 569
0
votes
2
answers
572
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 ...
- 1
2
votes
1
answer
3k
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 ...
- 123
-1
votes
1
answer
1k
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 ...
- 1